Thursday, October 16, 2014

ORA-15183: ASMLIB initialization error [driver/agent not installed] in oracle database at linux server.



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: