ADSM-L

Re: TDP for Oracle 8.1.7.4 & 9.2.0.6 on same server

2005-09-02 10:28:51
Subject: Re: TDP for Oracle 8.1.7.4 & 9.2.0.6 on same server
From: Scott Grover <Scott.R.Grover AT SUPERVALU DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 2 Sep 2005 09:28:27 -0500
Thanks Neil !  Looks like my problems are solved.  I misunderstood and thought I
only needed the 64 bit install....duh.   I sure am becoming a huge fan of
adsm.org.   Thanks to all who have been responding and helping me out  !!!



             Neil Rasmussen
             <rasmussn AT US.IBM DOT CO
             M>                                                              To
             Sent by: "ADSM:             ADSM-L AT VM.MARIST DOT EDU
             Dist Stor Manager"                                              cc
             <[email protected]
             DU>                                                        Subject
                                         Re: [ADSM-L] TDP for Oracle 8.1.7.4 &
                                         9.2.0.6 on same server
             09/01/2005 07:26 PM


              Please respond to
              "ADSM: Dist Stor
                  Manager"
             <[email protected]
                     DU>






Scott,

TDP Oracle can interface with both a 32-bit and 64-bit Oracle instance by
defining the correct symbolic links.
The 32-bit Oracle should use the 32-bit TDP Oracle libobk.a
and the 64-bit Oracle should use the 64-bit TDP Oracle libobk.a.
To ensure this, define the symbolic links as follows:

32-bit Oracle 8i
$ORACLE_HOME/lib/libobk.a  -->  /usr/tivoli/tsm/oracle/bin/libobk.a.

64-bit Oracle 9.2
$ORACLE_HOME/lib/libobk.a  -->  /usr/tivoli/tsm/oracle/bin64/libobk64.a.
(With the 9.2 version of 64-bit Oracle the directory structure changed to
use
just the "lib" directory for the 64-bit library location. )

It is necessary to verify the library path that is being used (LIBPATH or
LD_LIBRARY_PATH).  Ensure that the /usr/lib is NOT first in the path.
$ORACLE_HOME/lib should be first in the path so that Oracle will look in
its
own library directory where the libobk.a links have been created.

The TDP for Oracle version 5.2 package is such that the 32-bit
installation
will be placed in the /usr/tivoli/tsm/client/oracle/bin and the 64-bit
version
will be installed in to the /usr/tivoli/tsm/client/oracle/bin64. Therefore
the
installed filesets will not be overwritten.  Please note, however, that
the
installation will automatically create a soft link in the /usr/lib
directory
for the libobk.a file.  You will need to either remove this link or ensure
that
it is pointing to the correct (32-bit versus 64-bit) location you want.




Regards,

Neil Rasmussen
Software Development
Data Protection for Oracle
rasmussn AT us.ibm DOT com




Scott Grover <Scott.R.Grover AT SUPERVALU DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
09/01/2005 01:51 PM
Please respond to
"ADSM: Dist Stor Manager"


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
TDP for Oracle 8.1.7.4 & 9.2.0.6 on same server






Hi all,
      I have TDP  64 bit for Oracle AIX 5.2.0  running on an AIX 5.2
client.  I
believe I have the symbolic links for both Oracle instances set up
properly, and
have done "relink all" for both successfully.  I also have permissions set
to
666 on the tdpoerror logs, etc. - but getting the following error on the
Oracle
8.1.7 instance (Oracle 9 runs fine):

RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-07004: unhandled exception during command execution on channel ch00
RMAN-10035: exception raised in RPC: ORA-19554: error allocating device,
device
type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
IBM AIX RISC System/6000 Error: 14: Bad address
Additional information: 585
ORA-19511: Unknown SBT error code = 585, errno = 14
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.DEVICEALLOCATE

Has anyone else run into this?
Thanks in advance if anyone has any ideas !
Here's showenv output for both oracle instances; ts90 is 64 bit and ts91
is 32
bit:

TS90:
svho1ds612 #  tdpoconf showenv
-tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo_ts90.opt


IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 2, Level 0.0
(C) Copyright IBM Corporation 1997, 2003. All rights reserved.


DATA PROTECTION FOR ORACLE INFORMATION
 Version:              5
 Release:              2
 Level:                0
 Sublevel:             0
 Platform:             64bit TDP Oracle AIX

TSM SERVER INFORMATION
 Server Name:          TDPO_TS90_DS612
 Server Address:       SVHO1TSM1.SUPERVALU.COM
 Server Type:          AIX-RS/6000
 Server Port:          1500
 Communication Method: TCP/IP

SESSION INFORMATION
 Owner Name:
 Node Name:            tdpo_ts90_ds612
 Node Type:            TDP Oracle AIX
 DSMI_DIR:             /usr/tivoli/tsm/client/api/bin64
 DSMI_ORC_CONFIG:      /usr/tivoli/tsm/client/oracle/bin64/dsmd_ts90.opt
 TDPO_OPTFILE:         /usr/tivoli/tsm/client/oracle/bin64/tdpo_ts90.opt
 Password Directory:   /etc/adsm
 Compression:          FALSE

TS91:
svho1ds612 # tdpoconf showenv
-tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo_ts91.opt


IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 2, Level 0.0
(C) Copyright IBM Corporation 1997, 2003. All rights reserved.


DATA PROTECTION FOR ORACLE INFORMATION
 Version:              5
 Release:              2
 Level:                0
 Sublevel:             0
 Platform:             64bit TDP Oracle AIX

TSM SERVER INFORMATION
 Server Name:          TDPO_TS91_DS612
 Server Address:       SVHO1TSM1.SUPERVALU.COM
 Server Type:          AIX-RS/6000
 Server Port:          1500
 Communication Method: TCP/IP

SESSION INFORMATION
 Owner Name:           oracle
 Node Name:            tdpo_ts91_ds612
 Node Type:            TDP Oracle AIX
 DSMI_DIR:             /usr/tivoli/tsm/client/api/bin64
 DSMI_ORC_CONFIG:      /usr/tivoli/tsm/client/oracle/bin64/dsmd_ts91.opt
 TDPO_OPTFILE:         /usr/tivoli/tsm/client/oracle/bin64/tdpo_ts91.opt
 Password Directory:   /etc/adsm
 Compression:          FALSE

svho1ds612 #