Oracle RMAN: Failed to load Media Manager Library

[Alex_Tetyukhin]

Hi!

I am trying to backup Oracle 9i on Windows with Netbackup Enterprise Server 5.0. I use template wizard.
But here's an error from RMAN:

*************************************************************
INF - RMAN-00571: ===========================================================
INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
INF - RMAN-00571: ===========================================================
INF - RMAN-03009: failure of allocate command on ch00 channel at 07/19/2005 13:44:08
INF - ORA-19554: error allocating device, device type: SBT_TAPE, device name:
INF - ORA-27211: Failed to load Media Management Library
INF - Recovery Manager complete.
INF - End of Recovery Manager output.
INF - End Oracle Recovery Manager.

**************************************************
And here's an Oracle log:
*************************************************

Dump file c:\oracle\admin\orabase1\udump\orabase1_ora_2644.trc
Tue Jul 19 12:42:47 2005
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 , CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.2 , CPU type 586
Instance name: orabase1

Redo thread mounted by this instance: 1

Oracle process number: 15

Windows thread id: 2644, image: ORACLE.EXE


*** SESSION ID:(13.170) 2005-07-19 12:42:47.000
SKGFQ OSD: Error in function sbtinit on line 2323
SKGFQ OSD: Look for SBT Trace messages in file C:\oracle\admin\orabase1\udump\sbtio.log
SBT Initialize failed for oracle.static
*** 2005-07-19 13:37:38.000
SKGFQ OSD: Error in function sbtinit on line 2323
SKGFQ OSD: Look for SBT Trace messages in file C:\oracle\admin\orabase1\udump\sbtio.log
SBT Initialize failed for oracle.static
*** 2005-07-19 13:38:02.000
SKGFQ OSD: Error in function sbtinit on line 2323
SKGFQ OSD: Look for SBT Trace messages in file C:\oracle\admin\orabase1\udump\sbtio.log
SBT Initialize failed for oracle.static
************************************************************

I have checked sbtio.log file but it is empty...
Also I have checked that library orasbt.dll in the c:\windows\system32. I have tried to copy it to thr %install path%\oracle\bin but it changes nothing.

Can anybody give me any ideas what to do to resolve it?
Environment: Oracle 9i on Windows Server 2003, NBU 5.0GA MP5 on Windows Server 2003

Thanks...

[patrickkuah]

Seems like Oracle unable to communicate with orasbt.dll
Is "%install path%\oracle\bin" in the environement variable???

patrick

[Brice_Avila_2]

ORA-27211 is usually a linking problem, but on windows this usually isn't a problem since the linking is done when NetBackup is installed.

If you upgraded NetBackup, did you bounce Oracle? Sometimes Oracle will take NetBackup's orasbt.dll library and load it into shared memory, and use it. So even if you change the library, RMAN is still using the old library.

Otherwise, probably should open a case with support. Hope this helps.

Brice Avila

[Stumpr2]

Brice,
You always have helpful posts concerning Oracle. Are you perhaps a dba?

[G_S]

When you installed Netbackup was all the Oracle services down? Generally I would recommend setting all the services to manual, rebooting, installing NBU, setting the services to automatic and rebooting again. It really sounds like orasbt.dll hasn't been updated. Can you post the time/date stamp and version # for orasbt.dll as wel?

[Alex_Tetyukhin]

The problem was resolved when I manually copy orasbt.dll from \windows\system32 to %install path%\oracle\bin and restarted server. But I wonder why Netbackup didn't do it itself?

[Alex_Tetyukhin]

I think it's not a very convenient feature of Netbackup. What to do if it's a production database server and it is not desirable to stop and restart it?

[patrickkuah]

In Windows, It should be automatic link for you. In UNIX, we have to execute the oracle_link.

If im not wrong, from Oracle 9.x and beyond... we do not required to stop the Oracle services before installing NBU. Correct me if i'm wrong.

patrickkuah

[Richard_Bannist]

i don't know how the linking of MML is done in Windows. In Unix you have to shut down the Oracle database in question, run the oracle_link script which is a glorified symbolic link command, then start the database.

[patrickkuah]

Hi Richard,

We still need to down Oracle even from version 9i and beyond??
Thanks :)

patrick

[Richard_Bannist]

as far as i know, yes (i would happily be proved wrong though) . i have been known to do just the oracle_link with database up, if it's a non-PROD database, but i think it's still best practice to shut oracle down. For me it's one of those things where i stick to being safe. we have a mixture of 9i and 10g databases so it's easier for me to arrange a 2min outage for any database than try and remember if i should or shouldn't shut it down

[patrickkuah]

Thanks... You are right, it still a best practice to shutdown Oracle first :)

patrick

[Brice_Avila_2]

Was an Informix DBA, but many large shops have a mixture of RDBMS, so I picked-up some Oracle.

Brice

[satyakotni]

Giving example of legato, Assuming Legato client is installed on your server.

UNIX
create soft link under ORACLE_HOME/lib
 libobk.a -> /usr/lib/libnwora.a

Windows NT
create shortcut under $ORACLE_HOME\bin\
orasbt.dll pointing to "C:\Program Files\Legato\nsr\bin\orasbt.dll"

Restart the oracle service and database

Try running the backup again.
This error implied oracle is unable to contact to Storage Media (Legato, Tivoli ..etc)

[rj_nbu]

No Offence, but the last update to this thread was 4 years ago.

[Will_Restore]

speaking of legato and tivoli  :)