Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Failed to load Media Management Library with Oracle RMAN

Status
Not open for further replies.

brackovic

IS-IT--Management
May 13, 2004
50
I installed Legato NW and NMO as follows:
Servers: Windows 2000 Server
Oracle database (server, client and RMAN): version 9.2.0.5
NW Server and Client: version 6.2

When I started scheduled backup from NW Server through configured NW Client for NMO, RMAN made following errors:
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of allocate command on c1 channel at 05/12/2004 14:21:57 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library

Of course, after then backup failed with error:
* sazodbue:D:\dba\rman\hrplus_backup1.bat RMAN script execution is not successful. RMAN exited with return code '3'.
05/12/04 14:23:51 nsrd: runq: NSR group Oracle exited with return code 1.
05/12/04 14:24:12 nsrd: write completion notice: Writing to volume Oracle.001 complete

I have checked all environment variables and made installation procedures and everything seems to be OK.
I do emphasize that manual backup (when I start RMAN script directly on the Oracle server) finishes OK and I can see trace on the NW Server, also can see savesets on the tape and indexes in the appropriate media pool and volume.

Does somebody have some idea what’s going on here???

Thanks,
S
 
If manual RMAN script backup works, it looks like more of an install issue then. Try reinstalling the NMO again. Are the normal backups recognizing the jukebox/device correctly? You may also try reconfiguring the jukebox.

With Windows 2000, make sure you have disabled the Removable Storage service.
 
Rkrishnan, thanks for your suggestion.
All of listed issues were satisfied.

Today we found the source of problem, so if it could be help for someone else, here it is:

the prolem was about connecting to the target database. We made connection via TNS and put recommended connect command in the RMAN script:
connect target target_user/target_passwd@target_Netservicename;

But, it didn't work.
We changed the way of connection and by defining ORACLE_SID environment variable. In the nmoag stands that this variable is optional, but ...

So, instead to make connection with command:
connect target sys/*******@HRPLUS

we're making connection with command:
connect target sys/*******

and in the nsrnmo script have defined env variable:
ORACLE_SID=HRPLUS

Have a nice weekend.
S
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top