Oracle backup fails to load Media Manager Library

Technote (troubleshooting)


Problem(Abstract)

When the oracle database is loaded with svrctl for the cluster access, then the backup fails with:
ORA-27211: Failed to load Media Management Library
Additional information: 2

Symptom

Errors seen: 

run
{
allocate channel t1 type sbt parms='ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';  
backup database;
}
using target database control file instead of recovery catalog
RMAN-00571: ===============================================
RMAN-00569: ======== ERROR MESSAGE STACK FOLLOWS =========
RMAN-00571: ===============================================
RMAN-03009: failure of allocate command on t1 channel at 08/08/2012 08:51:48
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 2



Environment

Oracle 11gR2 RAC

Diagnosing the problem

If SQLPlus is used to start the database, then it will successfully load the library.

Also, if the database is set to stand-alone mode, the Data Protection for Oracle library can be loaded.

The problem to load the library is only seen when the Oracle grid software is used to startup the Oracle database in cluster mode.


Resolving the problem

The issue is that the Oracle grid needs to know the Library paths, such that it can search for and load the necessary library files from these related paths. As mentioned in Oracle Metalink document 1439674.1, you would want to set the paths in the grid for example:

srvctl setenv database -d dbname -t "PATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib, LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib, LIBPATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib:/usr/lib/libobk.a, SHLIB_PATH=/u01/app/oracle/product/11.2.0.2/dbhome_1/lib:/usr/lib/libobk.a"

Please note that it is necessary to bounce the database via srvctl even though this extra step is not stated within the Metalink document.

This should allow the database to be started/controlled by the Oracle grid and allow the backups to work successfully with the Data Protection for Oracle library interface.


Product Alias/Synonym

TSM DP

Rate this page:

(0 users)Average rating

Document information


More support for:

Tivoli Storage Manager for Databases
Data Protection for Oracle

Software version:

5.5.1, 5.5.2, 6.3

Operating system(s):

AIX

Reference #:

1608546

Modified date:

2013-07-23

Translate my page

Machine Translation

Content navigation