Issue:
We are running a RAC 2 nodes with database version:11.2.0.4.This morning after a kernel update or host reboot one of the instance i.e 2nd instance refuse to startup due to the following error :
ORA-00600: internal error code, arguments: [kjxmgmb_nreq:!bat], [17], [56], [9], [], [], [], [], [], [], [], []
LMS0 (ospid: 24928): terminating the instance due to error 484
System state dump requested by (instance=2, osid=24928 (LMS0)), summary=[abnormal instance termination].
Fixes:
As temporary fix was :-
1. After another reboot, the instance has finally started.
Complete instance bounce including database
2.The permanent fix of the issue should be the patch 20250147 - ORA 600 [KJXMGMB_NREQ:!BAT]
Bug 20250147 - ORA-600 [kjxmgmb_nreq:!bat] can occur in RAC crashing the instance (Doc ID 20250147.8)
ORA-600 [kjxmgmb_nreq:!bat] (Doc ID 2211714.1)
Main Fix:
LMS are not running in RT and same as VKTM.
In 10gR2 and above the LMS process is intended to run in the real time scheduling class. In some instances we have seen this prevented due to incorrect ownership or permissions for the oradism executable which is stored in the $ORACLE_HOME/bin directory. See Document 602419.1 for more details on this.
Check the file permissions of '$ORACLE_HOME/bin/oradism' the database instance.
The permissions for 'oradism' must be 6550 with the setid for the group: e.g. (-r-sr-s--- 1 root oinstall 129 12 Feb 16 2008 oradism) .
REFERENCE: RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent) (Doc ID 810394.1)
$ ls -l $ORACLE_HOME/bin/oradism
-rwxr-x--- 1 oracle orainst 71780 Sept 24 2011 $ORACLE_HOME/bin/oradism
Exachk reports incorrect oradism ownership and permission (Doc ID 2009788.1)
Also, the exachk must be run as root user. If not run as root user, warnings such as this can be flagged incorrectly.
Ensure root user was used to run exachk. The user will be reported in the top summary of the html report.
If reported on the db home, you can do the following to change permissions.
Run the following commands with root permission to resolve the issue.
#cd $ORACLE_HOME/bin/
#chown root oradism
#chmod u+s oradism
You can make the changes with the db open.
We are running a RAC 2 nodes with database version:11.2.0.4.This morning after a kernel update or host reboot one of the instance i.e 2nd instance refuse to startup due to the following error :
ORA-00600: internal error code, arguments: [kjxmgmb_nreq:!bat], [17], [56], [9], [], [], [], [], [], [], [], []
LMS0 (ospid: 24928): terminating the instance due to error 484
System state dump requested by (instance=2, osid=24928 (LMS0)), summary=[abnormal instance termination].
Fixes:
As temporary fix was :-
1. After another reboot, the instance has finally started.
Complete instance bounce including database
2.The permanent fix of the issue should be the patch 20250147 - ORA 600 [KJXMGMB_NREQ:!BAT]
Bug 20250147 - ORA-600 [kjxmgmb_nreq:!bat] can occur in RAC crashing the instance (Doc ID 20250147.8)
ORA-600 [kjxmgmb_nreq:!bat] (Doc ID 2211714.1)
Main Fix:
LMS are not running in RT and same as VKTM.
In 10gR2 and above the LMS process is intended to run in the real time scheduling class. In some instances we have seen this prevented due to incorrect ownership or permissions for the oradism executable which is stored in the $ORACLE_HOME/bin directory. See Document 602419.1 for more details on this.
Check the file permissions of '$ORACLE_HOME/bin/oradism' the database instance.
The permissions for 'oradism' must be 6550 with the setid for the group: e.g. (-r-sr-s--- 1 root oinstall 129 12 Feb 16 2008 oradism) .
REFERENCE: RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent) (Doc ID 810394.1)
$ ls -l $ORACLE_HOME/bin/oradism
-rwxr-x--- 1 oracle orainst 71780 Sept 24 2011 $ORACLE_HOME/bin/oradism
Exachk reports incorrect oradism ownership and permission (Doc ID 2009788.1)
Also, the exachk must be run as root user. If not run as root user, warnings such as this can be flagged incorrectly.
Ensure root user was used to run exachk. The user will be reported in the top summary of the html report.
If reported on the db home, you can do the following to change permissions.
Run the following commands with root permission to resolve the issue.
#cd $ORACLE_HOME/bin/
#chown root oradism
#chmod u+s oradism
You can make the changes with the db open.
No comments:
Post a Comment