advertisements
_____________________________________________________________________________________________________________________
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