Skip to main content

ORA-15180: could not open dynamic library odm library, error [open]

Hello Friends,

Faced "ORA-15180: could not open dynamic library odm library, error [open]" which is linked with libodm11.so and libodmd11.so.

Target system was refreshed from a source system which was enabled to use Oracle Disk Manager (ODM), hence got source system configuration on target and while performing database PITR, this did not came easily at nomount stage. Have a look below.

Following was the way, how I sorted it out.

$> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 16:42:50 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-15180: could not open dynamic library odm library, error [open]
SQL> exit
Disconnected

Checked $ORACLE_HOME/lib/libod* condition. In your case, some of date related files may/may not be there.

$> ls -lart $ORACLE_HOME/lib/libod*
-rwxr-xr-x    1 orasid   dba           12892 Oct  1 2013  /oracle/SID/112_64/lib/libodm11.a
-rwxr-xr-x    1 orasid   dba            8651 Oct  1 2013  /oracle/SID/112_64/lib/libodmd11.so
lrwxrwxrwx    1 orasid   dba              12 Sep  5 2015  /oracle/SID/112_64/lib/libodm11.so.Jan24-2016 -> libodmd11.so
lrwxrwxrwx    1 orasid   dba              28 Mar 12 13:36 /oracle/SID/112_64/lib/libodm11.so.Mar2817 -> /opt/VRTSodm/lib/libodm64.so

Removed un-necessary soft links

$> /usr/sbin/unlink /oracle/SID/112_64/lib/libodm11.so.Jan24-2016
$> /usr/sbin/unlink /oracle/SID/112_64/lib/libodm11.so.Jan24-2016.12Sep
$> rm /oracle/SID/112_64/lib/libodm11.so.Jan24-2016
$> rm /oracle/SID/112_64/lib/libodm11.so.Mar2817

Check it now, how it looks like

$> ls -lart $ORACLE_HOME/lib/libod*
-rwxr-xr-x    1 orasid   dba           12892 Oct  1 2013  /oracle/SID/112_64/lib/libodm11.a
-rwxr-xr-x    1 orasid   dba            8651 Oct  1 2013  /oracle/SID/112_64/lib/libodmd11.so.Oct0117

Checked for libodm11.a file, how it looks like.

$> ls -ltr libodm*
-rwxr-xr-x    1 orasid   dba           12892 Oct  1 2013  libodm11.a
-rwxr-xr-x    1 orasid   dba            8651 Oct  1 2013  libodmd11.so.Oct0117

Moved this to correct name. In your case, this may/may not be there.

$> mv libodmd11.so.Oct0117 libodmd11.so
$> ls -lart $ORACLE_HOME/lib/libod*
-rwxr-xr-x    1 orasid   dba           12892 Oct  1 2013  /oracle/SID/112_64/lib/libodm11.a
-rwxr-xr-x    1 orasid   dba            8651 Oct  1 2013  /oracle/SID/112_64/lib/libodmd11.so

Finally linked it.

$> ln -s /oracle/SID/112_64/lib/libodmd11.so libodm11.so
$> ls -lart $ORACLE_HOME/lib/libod*
-rwxr-xr-x    1 orasid   dba           12892 Oct  1 2013  /oracle/SID/112_64/lib/libodm11.a
-rwxr-xr-x    1 orasid   dba            8651 Oct  1 2013  /oracle/SID/112_64/lib/libodmd11.so
lrwxrwxrwx    1 orasid   dba              35 Apr  6 17:08 /oracle/SID/112_64/lib/libodm11.so -> /oracle/SID/112_64/lib/libodmd11.so

At last, database was able to start up for database post restore steps.

$> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 6 17:08:58 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 5.7457E+10 bytes
Fixed Size                  2260112 bytes
Variable Size            6979322736 bytes
Database Buffers         5.0466E+10 bytes
Redo Buffers                9711616 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options




Please write your comments if this helped you and let me know, if I can help you further.

Comments

  1. Unknown10 April 2017 at 03:44

    Thank you Kanhaiya for the informative article.

    ReplyDelete
  2. Unknown19 April 2017 at 05:55

    This comment has been removed by the author.

    ReplyDelete
  3. Unknown19 April 2017 at 05:56

    Hi Kanhaiya,

    I was in between of same problem and found your solution.

    It helped me a lots of and saved my time and had learning as well.

    Appreciate your excellent blog

    ReplyDelete
    Replies
    1. Kanhaiya Lal27 April 2019 at 07:44

      appreciate your comments. let me know in case you find issues like this

      Delete
  4. Unknown30 April 2019 at 08:35

    Thanks for sharing

    ReplyDelete
  5. Unknown6 November 2019 at 06:34

    Brilliant Thanks for sharing

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle OS Watcher - Start and generate html report

Hi Guys, OS Watcher is an excellent utility for system performance investigation. OSWatcher invokes these distinct operating system utilities, each as a distinct background process, as data collectors. These utilities will be supported, or their equivalents, as available for each supported target platform. ps top ifconfig mpstat iostat netstat traceroute vmstat meminfo (Linux Only) slabinfo (Linux Only) OSWatcher is java program and requires as a minimum java version 1.4.2 or higher. This can run on on any Unix/Windows. An X Windows environment is required because oswbba uses Oracle Chart builder which requires it. Make sure java path is set $which java $<java path>/java Following will take system snapshot in every 30 seconds and will log last 24 hours data to OS Watcher archive log files. $cd <OS watcher dir> $nohup ./startOSWbb.sh 30 24 gzip <OS Watcher file location> & Without compress $nohup ./s...
9 comments
Read more

Alter System Checkpoint

Hello Techies, This happens most of the time that you need to add/drop redo log groups in Oracle databases due to any administrative reasons, however, if candidate redo group is in ACTIVE status, then you can't drop it and DBA need to wait until this comes in INACTIVE status to become this group available from drop. Here is the trick. Current status of redo log groups in my test database and you can see highlighted groups in ACTIVE status. In this situation, if DBA need to modify/drop these groups he/she need to wait until this comes in INACTIVE status. SQL> select * from v$log;     GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME      NEXT_CHANGE# NEXT_TIME ---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------...
12 comments
Read more