Cause
ORA-00600: internal error code, arguments: [kghstack_free1], [context for tx CR rollback], [], [], [], [], [], []
Result if Don’t apply
#Instance crash database down and write to alert log and oracle shadow process
#DB writer trace
#Oracle shadow process trace
Result After apply Patch 7662491
#Instance No crash but oracle server process die
#Pointer in memory is overwritten in error by a software problem
#No DB writer trace
#Oracle shadow process log=/oracle/PRD/saptrace/usertrace/PRD_ora_27810.trc
Step apply Interim patch
1. Stop database and listener (by ora<sid> user)
SQL>shutdown immediate;
lsnrctl stop
2. Install interim patch 7662491 on (by ora<sid> user)
#$ORACLE_HOME/OPatch/opatch apply /<Patch_Base_Path>/7662491
3. Check interim inventory report
#$ORACLE_HOME/OPatch/opatch lsinventory
4. Startup database (by ora<sid>user)
SQL>startup;
5. Startup listener (by ora<sid>user)
lsnrctl start
6. Check oracle process and listener
ps -ef|grep smon
ps -ef|grep tns
7. Check listener
tnsping <SID>
0 comments:
Post a Comment