ORA-15183: ASMLIB
initialization error [driver/agent not installed]
After reinstalling grid
infrastructure and oracle software or
applying patch (PSU) in linux server. You may face below error (and in alert
log ORA-15183 error) when you will try to startup the oracle database.
Only three command give you the
solution. Solution is below.
SQL>
SQL> host rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Wed Oct 15
15:05:21 2014
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup
Oracle instance started
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
===========================================================
RMAN-03002: failure of startup command at 10/15/2014 15:05:41
ORA-03113: end-of-file on communication channel
Process ID: 16205
Session ID: 199 Serial number: 44057
RMAN> shutdown immediate
using target database control file instead of recovery catalog
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
===========================================================
RMAN-03002: failure of shutdown command at 10/16/2014 10:23:44
RMAN-12001: could not open channel default
RMAN-10008: could not create channel context
RMAN-10005: error opening cursor
RMAN-10002: ORACLE error: ORA-03114: not connected to ORACLE
RMAN> exit
Alert log
content:
NOTE: ASMB registering with ASM instance as Standard client
0xffffffffffffffff (reg:4060941312) (new connection)
Wed Oct 15 15:05:37 2014
Errors in file
/userdata/app/oracle/diag/rdbms/icmsdb1/ICMSDB/trace/ICMSDB_rbal_16178.trc:
ORA-15183: ASMLIB initialization error [driver/agent not
installed]
Wed Oct 15 15:05:37 2014
WARNING: FAILED to load library:
/opt/oracle/extapi/64/asm/orcl/1/libasm.so
Wed Oct 15 15:05:37 2014
starting up 1 shared server(s) ...
Wed Oct 15 15:05:37 2014
NOTE: ASMB connected to ASM instance +ASM osid: 16186 (Flex
mode; client id 0xffffffffffffffff)
NOTE: initiating MARK startup
Starting background process MARK
Wed Oct 15 15:05:37 2014
MARK started with pid=27, OS id=16192
Wed Oct 15 15:05:37 2014
NOTE: MARK has subscribed
ORACLE_BASE from environment = /userdata/app/oracle
Wed Oct 15 15:05:39 2014
alter database mount
Wed Oct 15 15:05:40 2014
NOTE: ASMB mounting group 1 (DATA)
Wed Oct 15 15:05:40 2014
WARNING: cellinit.ora is missing. RBAL is terminating the
instance.
RBAL (ospid: 16178): terminating the instance due to error 27625
Wed Oct 15 15:05:41 2014
System state dump requested by (instance=1, osid=16178 (RBAL)),
summary=[abnormal instance termination].
System State dumped to trace file
/userdata/app/oracle/diag/rdbms/icmsdb1/ICMSDB/trace/ICMSDB_diag_16152_20141015150541.trc
Wed Oct 15 15:05:41 2014
Dumping diagnostic data in directory=[cdmp_20141015150541],
requested by (instance=1, osid=16178 (RBAL)), summary=[abnormal instance
termination].
Wed Oct 15 15:05:41 2014
Instance terminated by RBAL, pid = 16178
Cause:
This is an Ownership issue. After
reinstalling grid and oracle software, or applying Patch, it 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.
Solution:
With root user :-
[oracle@icms-test-db-st bin]$
[oracle@icms-test-db-st bin]$
[oracle@icms-test-db-st bin]$ su - root
Password:
[root@icms-test-db-st ~]#
[root@icms-test-db-st ~]#
[root@icms-test-db-st ~]# cd $ORACLE_HOME/bin
[root@icms-test-db-st bin]#
[root@icms-test-db-st bin]# chgrp asmadmin oracle
[root@icms-test-db-st bin]#
[root@icms-test-db-st bin]# chmod 6751 oracle
[root@icms-test-db-st bin]#
[root@icms-test-db-st bin]#
After that Database will be startup ..
SQL>
SQL>
SQL>
SQL> host rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Thu Oct 16
10:24:01 2014
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup mount ;
Oracle instance started
database mounted
Total System Global Area
4110417920 bytes
Fixed Size
2932096 bytes
Variable Size
2197815936 bytes
Database Buffers
1895825408 bytes
Redo Buffers
13844480 bytes
RMAN>
No comments:
Post a Comment