TDP for Oracle redux, how to really do it

Ok, updates needed to:

dsm.sys

Servername hostname_tdp

———————-

dsm.opt

Servername myTSMserver

———————-

/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt

TDPO_NODE hostname_tdp

———————-

/opt/tivoli/tsm/client/ba/bin/dsm-tdpora.opt

SERVER myTSMserver_tdp

———————-

Stop oracle

as Oracle, cd $ORACLE_HOME/bin

# ln -s /usr/lib/sparcv9/libobk.so .

restart oracle

run sbttest test again

———————-

remember, need agent.lic, readable by oracle

———————–

set password:

/opt/tivoli/tsm/client/oracle/bin64/tdpoconf password -tdpo_optfile=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt

TDP for Oracle on Solaris 10

Notes on installing TDP (Tivoli Data Protection) for Oracle on Solaris 10

Start:

TDP package installed, configuration done by backup guy, getting error trying to run sbttest test.  Asked to check it out.

===> sbttest test
The sbt function pointers are loaded from libobk.so library.
Return code -1 from sbtinit, bsercoer = 7011, bsercerrno = 409
sbtopen: System error – eg. malloc, fork errors

Checking package:

#  pkginfo -l TDPOrc64
PKGINST:  TDPOrc64
NAME:  IBM Tivoli Storage Manager for Databases – Oracle 64-bit Solaris 7/8/9
CATEGORY:  application
ARCH:  sparc
VERSION:  Version 5 Release 2 Level 0
BASEDIR:  /opt/tivoli/tsm/client
VENDOR:  IBM Tivoli
PSTAMP:  2003.073.00:58:32
INSTDATE:  May 15 2008 09:09
STATUS:  completely installed
FILES:        8 installed pathnames
2 shared pathnames
3 directories
4 executables
3750 blocks used (approx)

Now, I mean, that seems old to me, but according to the download dir, that’s it.

ftp://ftp.software.ibm.com/storage/tivoli-storage-management/maintenance/tivoli-data-protection/oracle_sun/

There is, of course, no verbage on Solaris 10 in the readme, so let’s hope that’s not the problem.

Back to the error.  Google searches on the error (such as http://bigdaveroberts.wordpress.com/page/2/) entice me to double-check on that library.

Checking ldd oracle shows

dbserverct1# ls -lah oracle
-rwsr-s–x   1 oracle   dba         121M May 14 08:51 oracle
dbserverct1# ldd oracle|grep obk
dbserverct1#

i.e. nothing.

Check links:

dbserverct1# find / -name “libobk*” -exec ls -la {} \; 2>/dev/null
lrwxrwxrwx   1 root     other         45 May 15 09:09 /usr/lib/sparcv9/libobk.so -> /opt/tivoli/tsm/client/oracle/bin64/libobk.so
-rwxr-xr-x   1 root     other    1153840 Feb 23  2003 /opt/tivoli/tsm/client/oracle/bin64/libobk.so
lrwxrwxrwx   1 oracle   dba           26 May 27 10:12 /u00/app/oracle/product/10.2.0/lib/libobk.so -> /usr/lib/sparcv9/libobk.so
dbserverct1# find / -name “libobk*” -exec ls -laL {} \; 2>/dev/null
-rwxr-xr-x   1 root     other    1153840 Feb 23  2003 /usr/lib/sparcv9/libobk.so
-rwxr-xr-x   1 root     other    1153840 Feb 23  2003 /opt/tivoli/tsm/client/oracle/bin64/libobk.so
-rwxr-xr-x   1 root     other    1153840 Feb 23  2003 /u00/app/oracle/product/10.2.0/lib/libobk.so
dbserverct1#
Looks ok, if convoluted.

However, looks like Oracle hasn’t been restarted since the link in $ORACLE_HOME/lib was made.

e.g.
oracle 26528     1   0   May 20 ?           1:14 oraclerman2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
Due to the overly convoluted organization this is part of, I will have to get the DBA to do the restart.

Stay tuned.

Update:  Restart didn’t help.  After much tracing of TSM config files (jeez it has a lot), found the issue was (perhaps among others, but the last item fixed was…)

had the wrong servername set up in dsm-tdpora.opt.  removing that fixed the error.

Here’s the ‘correct’ output from sbttest test

> sbttest test
The sbt function pointers are loaded from libobk.so library.
— sbtinit succeeded
Return code -1 from sbtinit, bsercoer = 0, bsercerrno = 0
Message 0 not found;  product=RDBMS; facility=SBT