Tue Sep 18 22:12:34 2007
Errors in file /software/oracle/admin/OOOS/bdump/odsp_j001_25476.trc:
ORA-00081: address range [0x60000000000F5A40, 0x60000000000F5A44) is not readable
ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+7456] [SIGBUS] [Invalid address alignment] [0x00000002
B] [] []
Associated Bug: 5442780 on HP-UX Itanium platform
Tuesday, September 25, 2007
'Invalid Block Type' Reported During Default Database Install
Symptoms
Downloaded 10.2.0.3 from metalink. Oracle from OTN.
Started apply apply patch and DBCA fails with
ERROR IN WRITING TO FILE LIBJMISC.SL[INVALID BLOCK TPYE] at 11% while copying the datafiles.
Checked with metalink, this could be due to file corrupted while download.
To verify this, the download page for the patch on Metalink has a button "View Digest" which shows the checksums
of the zip file.
Patch: p5337014_10203_HP64.zip
1424057924 bytes
MD5 : AC57E417EA46F6A281B54ACC338FD86B
To check the checksum of the download with an
MD-5 checker.
Public Domain checkers are available like on
http://www.fourmilab.ch/md5/
In my case , the checksum are shown below.
F2310739DACE8F9EB7C6067A8A7A1434 (wrong md5 chksum)
AC57E417EA46F6A281B54ACC338FD86B (correct md5 chksum)
From here , I learned taht for big file, verify the Digest is really important.
Wednesday, September 19, 2007
modify inline constraint
ods01@/software/oraods/product/10.2.0/bin> ./oerr ora 1451
01451, 00000, "column to be modified to NULL cannot be modified to NULL"
// *Cause: the column may already allow NULL values, the NOT NULL constraint
// is part of a primary key or check constraint.
// *Action: if a primary key or check constraint is enforcing the NOT NULL
// constraint, then drop that constraint.
This problem occurred during a database migration.
Failed statement is "alter table test_table modify colname NULL;". Developer told me was working.
Did a "desc test_table"
The column of "NULL?" is blank, which usually means NULLable.
However, check dba_constraints, it shown column not null and enabled.
This is discrepancy caused by my migration steps" alter table modify constraint enable NOVALIDATE;"
After I issue " alter table modify constraint enable;" again. The DESC tallys with dba_constraint, i.e. show me NOT NULL.
Subsequently, the failed job went through.
01451, 00000, "column to be modified to NULL cannot be modified to NULL"
// *Cause: the column may already allow NULL values, the NOT NULL constraint
// is part of a primary key or check constraint.
// *Action: if a primary key or check constraint is enforcing the NOT NULL
// constraint, then drop that constraint.
This problem occurred during a database migration.
Failed statement is "alter table test_table modify colname NULL;". Developer told me was working.
Did a "desc test_table"
The column of "NULL?" is blank, which usually means NULLable.
However, check dba_constraints, it shown column not null and enabled.
This is discrepancy caused by my migration steps" alter table modify constraint
After I issue " alter table modify constraint
Subsequently, the failed job went through.
location of opatch lsenv
notice the location of "opatch lsinventory" changed in 10.2.0.2
Log file location : /software/oracle/product/10.2.0/cfgtoollogs/opatch/opatch-2007_Sep_14_09-54-43-SGT_Fri.log
Lsinventory Output file location : /software/oracle/product/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory-2007_Sep_14_09-54-43-SGT_Fri.txt
Log file location : /software/oracle/product/10.2.0/cfgtoollogs/opatch/opatch-2007_Sep_14_09-54-43-SGT_Fri.log
Lsinventory Output file location : /software/oracle/product/10.2.0/cfgtoollogs/opatch/lsinv/lsinventory-2007_Sep_14_09-54-43-SGT_Fri.txt
Sunday, September 02, 2007
Pro*c compilation error
Problem: Pro*c compilation error on HP-UX Itanium Platform
cc -o pass10g pass.c -I$ORACLE_HOME/precomp/public -L$ORACLE_HOME/lib -lclntsh
proc itanium ld: Can't find library or mismatched ABI for -lclntsh
Solution: change to 32bit lib , i.e.
cc -o pass10g pass.c -I$ORACLE_HOME/precomp/public -L$ORACLE_HOME/lib32 -lclntsh
cc -o pass10g pass.c -I$ORACLE_HOME/precomp/public -L$ORACLE_HOME/lib -lclntsh
proc itanium ld: Can't find library or mismatched ABI for -lclntsh
Solution: change to 32bit lib , i.e.
cc -o pass10g pass.c -I$ORACLE_HOME/precomp/public -L$ORACLE_HOME/lib32 -lclntsh
Subscribe to:
Posts (Atom)
