Fix terminating the instance due to error 27625; Instance terminated by RBAL, pid = ; summary=[abnormal instance termination]

_____________________________________________________________________________________________________________________

Error description
ASM instance is down with following messages in the alert.log file.
NOTE: ASMB mounting group 2 (DATA_T1)
Fri Sep 16 01:39:42 2016
WARNING: cellinit.ora is missing. RBAL is terminating the instance.
RBAL (ospid: 11489): terminating the instance due to error 27625

Fri Sep 16 01:39:42 2016
System state dump requested by (instance=1, osid=11489 (RBAL)), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/onlprod/TMLPRODSTBY/trace/TMLPRODSTBY_diag_11446_20160916013942.trc
Fri Sep 16 01:39:42 2016
Dumping diagnostic data in directory=[cdmp_20160916013942], requested by (instance=1, osid=11489 (RBAL)), summary=[abnormal instance termination].
Fri Sep 16 01:39:42 2016
Instance terminated by RBAL, pid = 11489

Solution Description

This is an Ownership issue. The reason for the ownership change must be because of the oracle software reinstallation or a patch apply. This changed the group (ASMADMIN) to (OINSTALL) for ORACLE user and   $ORACLE_HOME/bin folder. So now you have to change the group back again to ASMADMIN and give appropriate permission also.

[oracle@ bin]$ ls -tlr oracle
-rwsr-s--x. 1 oracle oinstall 323943640 Sep 14 07:36 oracle

[oracle@ trace]$ cd $ORACLE_HOME/bin
[oracle@ bin]$ ls -tlr oracle
-rwsr-s--x. 1 oracle oinstall 323943640 Sep 14 07:36 oracle
[oracle@ bin]$ su - root
Password:
Last login: Thu Sep 15 06:26:41 EDT 2016 on pts/1
[root@~]# cd $ORACLE_HOME/bin
[root@bin]# chgrp asmadmin oracle
[root@bin]# chmod 6751 oracle
[root@bin]# ls -tlr oracle

-rwsr-s--x. 1 oracle asmadmin 323943640 Sep 14 07:36 oracle

_____________________________________________________________________________________________________________________

0 comments:

Post a Comment

 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google