TDP for Oracle on Solaris 10

May 29, 2008 at 2:53 pm Leave a comment

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

Advertisement

Entry filed under: backups, oracle. Tags: , , .

TDP for Oracle redux, how to really do it

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Calendar

May 2008
M T W T F S S
     
 1234
567891011
12131415161718
19202122232425
262728293031  

Most Recent Posts


Follow

Get every new post delivered to your Inbox.