Many users experienced “ORA-07445” error after applying any patch on 10.2.0.2 version and unable to start the RAC database instances on NODE2 or remote NODE’S (if more than 2 nodes). This also leads to dumps or internal errors on the remote nodes.
ORA-07445: exception encountered: core dump [kkxsyn()+584] [SIGSEGV]
The issues is a known bug 5128575 and the effected version are >=10.2.0.2
Check for possible Error messages in ASM/Database alert.log and trace files on NODE2 or Remote nodes. If you find the below SYMPTOMS then you are hitting a BUG 5128575.
ASM alert.log errors:
Errors in file /oracle/v10202/admin/+ASM/udump/+asm2_ora_30841.trc:
ORA-07445: exception encountered: core dump [kkxsyn()+584] [SIGSEGV] [Address not mapped to object] [0x000000168] [] []
Trace file errors:
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x168, PC: [0x3f06748, kkxsyn()+584]
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kkxsyn()+584] [SIGSEGV] [Address not mapped to object] [0x000000168] [] []
No current SQL statement being executed.
Database errors:
Startup database fails with below errors
SQL> startup database
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/testdb/spfiletestdb.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/testdb/spfiletestdb.ora
ORA-03113: end-of-file on communication channel
Cause:
Installing the 10.2.0.2 Patch Set in RAC on any Unix platform does not correctly update the libknlopt.a file on all remote nodes. The local node where the installer is run does update libknlopt.a file and remote nodes do not get the updated file.
Workaround:
Step 1: Shutdown ASM and all Database instances
Step 2: Manually copy $ORACLE_HOME/rdbms/lib/libknlopt.a from the local node to NODE2 or all remote nodes (if more than 2 nodes)
$ scp libknlopt.a oracle@testrac2:$ORACLE_HOME/rdbms/lib/libknlopt.a
Step 3: Re-link Oracle on all remote nodes.
3. cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk ioracle
Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com
Subscribe to:
Post Comments (Atom)
Hi, Satish,
ReplyDeleteIts really nice workaround.
I like it.
I have one question,
Re-link Oracle on all remote nodes?
What is meaning and purpose?
Thanks And Reagrds
Balasaheb Kambale
I mean re-link the oracle libraries on the nodes where you are facing the issues.
ReplyDeleteRelinking Oracle manually is suggested under these circumstances:
1.A new install failed during the relinking phase.
2.An OS upgrade has occurred.
3.Individual Oracle executable core dump during initial startup.
4.An individual Oracle patch has been applied (However, explicit relink instructions are usually either included in the README or integrated into the patch install script)
5.A change has been made to the OS system libraries. This can occur during the application of an OS patch.
Hope this helps,
Regards
Satish
تلك الشركة الجيدة التي تقدم خدمات جيدة في تنظيف المنازل من الداخل ومن الخارج وتسمى شركه تنظيف فلل بجده وهي التي تختص بأعمال التنظيف للمنازل الجديدة والمفروشة في مدينة جدة
ReplyDeleteفي العاصمة المقدسة التي هي مكة المكرمة توجد لدينا امكانيات كبيرة في مجال تنظيف المنازل والشقق والفلل كما في شركة تنظيف فلل بمكة المكرمة فلو تريد تنظيف بيتك او منزلك وانت في مكة تواصل معنا في حالة ان كان المنزل جديد
اما في حال ان كان المنزل مفروش واصاب الفرش من الأوساخ والأتربة مثل الكنب والمجالس والسجاد وتريد التنظيف بالبخار تواصل مع شركة تنظيف كنب بمكة المكرمة وهي شركة متميزة في أعمال الغسيل والتنظيف بالبخار