ORA-27211: Failed to load Media Management Library

Recently after database out-of-place upgrade to a higher version (11.2.0.x to 11.2.0.x+1), TAPE backup started failing with following error

RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE SBT;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ORA_MAINT_SBT_TAPE_2 channel at 01/02/2012 02:27:30
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

As this was an out-of-place upgrade, ORACLE_HOME has changed. Due to ORACLE_HOME change, link between oracle MML & vendor libraries is broken.

1. Verify the link

Db-01:ORCL:/u01/app/oracle/product/11.2.0.x/database/lib>ls -al | grep obk | wc -l
0

2. Create the required link

$ ln -s /usr/lib/libobk64.a $ORACLE_HOME/lib/libobk.a

3. Verify the link again

Db-01:ORCL:/u01/app/oracle/product/11.2.0.x/database/lib>ls -al | grep obk
lrwxrwxrwx 1 oracle dba 19 Feb 01 05:45 libobk.a -> /usr/lib/libobk64.a
NOTE: I’m using tdpo (Tivoli/TDP for oracle) as my TAPE library solution. The steps I’ve mentioned are specific to tdpo. Location for other media vendor library files will be different.

Once this link was established, I was able to run the TAPE backups again

RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE SBT;
using target database control file instead of recovery catalog
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: SID=25 device type=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Data Protection for Oracle: version 5.5.2.0
Advertisements
This entry was posted in Oracle Database Backup, Oracle Database Upgrade, Oracle Recovery Manager and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s