link to tape fails with oracle

[new_user_netbac]

Hello all,

I am trying to setup media backup on one of the server.  Here is the situation.

This server have 3 DB, 2 DB(11g) are being backed up tape(netbackup 7.1).  Now we have created a 3rd DB on this.

the 3rd db version is 10.2.0.4

The 3rd db has all the same setup as other 2 db being backuped.  From netbackup doc, we created the link using the oracle_link script under /usr/openv/netbackup/bin (just like other 2 db)...it created a link for file libobk.so under $ORACLE_HOME/lib to /usr/open/netbackup/bin

now when i try to allocate a channel to tape...it fails with below error...

$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Mar 12 13:16:10 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: ORCL (DBID=1454534343)

RMAN> run {

allocate channel ch1 type 'SBT_TAPE' PARMS='SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so';

release channel ch1;

}2> 3> 4>

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 ch1 channel at 03/12/2012 13:16:23

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27211: Failed to load Media Management Library

RMAN> exit

Recovery Manager complete.

$

$ cd $ORACLE_HOME/lib

$

$ ls -ltr *bob*

lrwxr-xr-x   1 oracle     dba             34 Mar  9 13:49 libobk.so_org -> /usr/openv/netbackup/bin/libobk.so

lrwxr-xr-x   1 oracle     dba             34 Mar  9 14:09 libobk.so -> /usr/openv/netbackup/bin/libobk.so

$

ALSO, there is a test we can run from oracle(sbttest)...to see if it talking to the tape or not...

get below error....looks like its looking for a file called libobk.sl (should that be under oracle or netbackup?)

$ cd $ORACLE_HOME/bin

$ ./sbttest test

The sbt function pointers are loaded from oracle.static library.

libobk.sl could not be loaded.  Check that it is installed

$

we are on hp-ux itanium 11.31

wat can be done to troubleshoot this?

[Will_Restore]

I see you asked on OTN Oracle forum which appropriate.  Sorry there is no answer yet.

[new_user_netbac · Accepted solution]

I just wanted to point this out, so the community can benefit from it.  

I am still trying to figure this out, but we might know what the problem is here.

The oracle bit version is PA-RISC, while the MML bit version is IA64.  So we have 2 different bit version,

my question is...if my MML bit version is IA 64, and my oracle bit version is different.  Would the MML support this or not, if not is there a workaround for this...my OS is hp-ux Itanium 11.31... we have a oracle DB running (which was copied over from a PA-RISC server)....

$ file /usr/openv/netbackup/bin/libobk.so

/usr/openv/netbackup/bin/libobk.so:     ELF-64 shared object file - IA64

$ file oracle

oracle:         ELF-64 executable object file - PA-RISC 2.0 (LP64)

[Yasuhisa_Ishika]

I'm not sure IA64 HP-UX has cross platform runtime for PA-RISC codes.
Is this supported by both Oracke and HP?

The issueis, PA-RISC oracle try to load MML library for PA-RISC(libobk.sl), but NetBackup installed on this host is IA64 code, and does not provide PA-RISC MML library.

Why don't you use native IA64 oracle?

[Marianne]

"oracle DB ... was copied over from a PA-RISC server"

Looks like this was not a good idea...

Rather use backup and redirected restore.