TDP for Oracle on SUN

T

tsmlover

ADSM.ORG Member
Joined
Oct 14, 2008
Messages
390
Reaction score
1
Points
0
hello Is there anyone who have implemented TDPO for Oracle on SUN?

its been a first time i am going to implement TDPO for Oracle on SUN plateform

plz gimme a q quick configuration like what file i need to configure to start the backup

and how to install it and what files do i need to change????

I never been work on oracle and RMAN

Do i also need to install the BAclient on sun solaris server with TDPO ?
 
Last edited:
tsmlover said:
hello Is there anyone who have implemented TDPO for Oracle on SUN?

its been a first time i am going to implement TDPO for Oracle on SUN plateform

plz gimme a q quick configuration like what file i need to configure to start the backup

and how to install it and what files do i need to change????

I never been work on oracle and RMAN

Do i also need to install the BAclient on sun solaris server with TDPO ?
Click to expand...

I would guess it is fairly similar to anything else on UNIX (aix or Linux)? In the redbook, there is a "quickstart" that was fairly simple...I've also written a doc, step by step on how to install it/configure it on Linux and AIX...Could that help? I have not done it on SCO though, but figure it can't be that much different...

Don't know how old this is, but found this on the web as well...

http://sunnotes.wordpress.com/
 
yes i am following the red book its pretty good....

but some things are confusing me ....

1, is there any BA client need to be installed on SUN server where i installed TDPO for oracle ?

2, I am confused about tdp.sys and tdp.opt, where i need to define server options like TSM server IP address, node name etc....

3, after the TDPO installation i am unable to perform the below tasks because there is no libobk.so and libobk64.a file exist in 'lib' directory

$ ln -s /usr/lib/sparcv9/libobk.so $ORACLE_HOME/lib/libobk.so
$ORACLE_HOME/lib/libobk.a -> /usr/lib/libobk64.a$ORACLE_HOME/lib/libobk.a -> /usr/lib/libobk64.a
 
Last edited:
BA client has to be installed as well as TDP client. You then need a tdp.opt file, i call them for example tdpo_ORACLEINSTANCENAME.opt just so i can know which is which. That file contains something along the sorts:

# cat tdpo_INTPRD.opt

DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm_INTPRD.opt
DSMI_LOG /var/tsm/INTPRD

TDPO_FS INTPRD
TDPO_NODE ora_intprd
*TDPO_OWNER <username>
TDPO_PSWDPATH /home/oracle9i

*TDPO_DATE_FMT 1
*TDPO_NUM_FMT 1
*TDPO_TIME_FMT 1

*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4

The dsm_INTPRD.opt is just like a standard dsm.opt file. it contains the name of the stenza to use in the typical dsm.sys config file. Mine looks like this:

# cat dsm_INTPRD.opt
SErvername tdpo_INTPRD

That then points to the stenza in the normal BAClient dsm.sys:

# cat dsm.sys
SErvername ServerA
NODENAME ServerA
COMMMethod TCPip
TXNBytelimit 25600
TCPPort 1500
TCPServeraddress backupserver.domain.ca
PASSWORDAccess Generate
DIRMC DISK_UNIX_DIR
SCHEDLOGName /var/tsm/dsmsched.log
ERRORLOGName /var/tsm/dsmerror.log
SCHEDLOGRetention 35
ERRORLOGRetention 35

RESOURceutilization 4

EXCLUDE.FS /db101
EXCLUDE.FS /migration
EXCLUDE.FS /oraredo
EXCLUDE.FS /oraundo
EXCLUDE.FS /oraarch

INCLUDE /oratempts/.../* TAPE_UV
INCLUDE /orabackup/.../* TAPE_UV

SErvername tdpo_INTPRD
NODENAME ora_intprd
COMMMethod TCPip
RESOURceutilization 6
TCPCLIENTPort 1505
TXNBytelimit 2097152
TCPServeraddress backupserver.domain.ca
PASSWORDAccess prompt
COMPRESSION on
SCHEDLOGName /var/tsm/INTPRD/dsmsched.log
ERRORLOGName /var/tsm/INTPRD/dsmerror.log
SCHEDLOGRetention 35
ERRORLOGRetention 35

INCLUDE /intprd/.../full* TDP_ORACLE_TAPE_INTPRD
INCLUDE /intprd/.../*arch_* TDP_ORACLE_DISK
INCLUDE /intprd/.../*ctlf_* TDP_ORACLE_DISK
 
dnt understand :(

first I installed TIVsmCapi.pkg and than i installed TDPoracle64.bin
is it okay?

than i modify tdop.opt file and add the below parameters
dsmi_orc_config /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
dsmi_log <directory with write permissions>

my dsm.opt file looks like this
SErvername server_a

my dsm.sys file looks like this
SErvername server_a
COMMMethod TCPip
TCPServeraddress x.x.x.x
PASSWORDAccess generate
passworddir /home/<oracle user>
nodename TDPONodeName

tell me what should i place in my dsm.opt file and what i place in dsm.sys file

there are only 3 files i need to configure TDPo_Opt DSM.sys and DSM.opt em i ryte ?
 
Again, i am basing this on an AIX or LInux install, which i would guess should be similar on the SCO.

You do install and configure the Tivoli API first. Get it running correctly. Then install the TDP for Oracle.

You then have 3 files to modify. The tdpo.opt file within .../oracle/bin64, the dsm.opt file in that same directory and the dsm.sys file within .../client/ba/bin.

You also need to "register" your TPD within TSM. You need to run the tdpoconf command to set your password prior to being able to use the TDP...

Steph
 
TSMlover,

Follow Stephan's instructions, but keep in mind that the path on Solaris is /opt/tivoli/...., AIX is the only UNIX that use /usr/tivoli...

Keep us updated on your progress...
 
Below are the path after installation

/opt/tivoli/tsm/client/api/bin64/ dsm.sys and dsm.opt

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

I have installed this TIVsmCapi.pkg and than i installed TDPoracle64.bin

there is no BA directory, is there any BA client for SUN Solaris that i have to install
do i want to install BA client for solaries ?

I have installed API and TDPO .. i am not sure the BA client

from where i can find the manual for installting and configuring BA client for sun solaries system?
 
Last edited:
Hi,

there are three packages - TIVsmCapi.pkg (TSM API), TIVsmCba.pkg (TSM BA client) and TDPoracle64.bin (TDP for Databases - Oracle)
You need just API and TDP, but it is good to install the BA (although not needed!) - you can test the TSM server connectivity and backup Oracle binaries, logs and configs ...
You have paid the license for the client anyway ....

steps:
1) install TSM API (using pkgadd)
2) configure dsm.sys (in /opt/tivoli/tsm/client/api/bin64/dsm.sys by default)
basic setup:
/opt/tivoli/tsm/client/api/bin64/dsm.sys:
servername tsmserver
commmethod tcpip
passwordaccess prompt
tcpserveraddress <IP>
tcpport <PORT>
*TXNbytelimit – LTO optimization
Txnbytelimit 2097152

3) install TDP (binary installator - use "-i console" or "-console" for text installation - depends on installer version)
4) IMPORTANT register 64bit libraries
crle –u -64 –l /opt/tivoli/tsm/client/api/bin64
crle –u -64 –l /opt/tivoli/tsm/client/oracle/bin64
5) IMPORTANT create link to libobk.so
ln –s /opt/tivoli/tsm/client/oracle/bin64/libobk.so /oracle/product/10.2/db_1/bin/
(your oracle location may vary - another version etc.)

6) create tdpo.opt and dsm.opt files

/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt:
DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/api/bin64
TDPO_NODE <TDP_nodename>
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64

/opt/tivoli/tsm/client/oracle/bin64/dsm.opt:
*servername must correspond to servername stanza in /opt/tivoli/tsm/client/api/bin64/dsm.sys
servername tsmserver

7) change permissions for the log files
chmod 666 /opt/tivoli/tsm/client/api/bin64/tdpoerror.log
8. register the TDP node on the server
9) test the setup using:
cd /opt/tivoli/tsm/client/oracle/bin64
./tdpoconf showenv
10) generate password for TDP
./tdpoconf password
11) confirm the password file is available
./tdpoconf showenv


Harry
 
Harry_Redl, I have never heard of registering libraries on Solaris.

Where did you get that information from?

Thanks,

M
 
Harry_Redl said:
Hi,

there are three packages - TIVsmCapi.pkg (TSM API), TIVsmCba.pkg (TSM BA client) and TDPoracle64.bin (TDP for Databases - Oracle)
You need just API and TDP, but it is good to install the BA (although not needed!) - you can test the TSM server connectivity and backup Oracle binaries, logs and configs ...
You have paid the license for the client anyway ....

steps:
1) install TSM API (using pkgadd)
2) configure dsm.sys (in /opt/tivoli/tsm/client/api/bin64/dsm.sys by default)
basic setup:
/opt/tivoli/tsm/client/api/bin64/dsm.sys:
servername tsmserver
commmethod tcpip
passwordaccess prompt
tcpserveraddress <IP>
tcpport <PORT>
*TXNbytelimit – LTO optimization
Txnbytelimit 2097152 this parameter is not available in my dsm.sys file do i need to add it ?
there is also "passworddir" parameter in this file do i need to supply some value ?
nodename do i need to provide tdp node name ?

3) install TDP (binary installator - use "-i console" or "-console" for text installation - depends on installer version)
4) IMPORTANT register 64bit libraries
crle –u -64 –l /opt/tivoli/tsm/client/api/bin64
crle –u -64 –l /opt/tivoli/tsm/client/oracle/bin64
5) IMPORTANT create link to libobk.so
ln –s /opt/tivoli/tsm/client/oracle/bin64/libobk.so /oracle/product/10.2/db_1/bin/
(your oracle location may vary - another version etc.)

when i execute this command ln -s /usr/lib/sparcv9/libobk.so $ORACLE_HOME/lib/libobk.so <----- there is no libobk.so file exist in oracle

6) create tdpo.opt and dsm.opt files

/opt/tivoli/tsm/client/oracle/bin64/ <-- there is tdpo.opt file is present and i configured it but there is no dsm.opt file exist

/opt/tivoli/tsm/client/api/bin64 <-- dsm.opt file is exist on this path

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

DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/api/bin64

TDPO_NODE <TDP_nodename>
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64

/opt/tivoli/tsm/client/oracle/bin64/dsm.opt:
*servername must correspond to servername stanza in /opt/tivoli/tsm/client/api/bin64/dsm.sys
servername tsmserver

7) change permissions for the log files
chmod 666 /opt/tivoli/tsm/client/api/bin64/tdpoerror.log
8. register the TDP node on the server
9) test the setup using:
cd /opt/tivoli/tsm/client/oracle/bin64
./tdpoconf showenv
10) generate password for TDP
./tdpoconf password
11) confirm the password file is available
./tdpoconf showenv


Harry
Click to expand...
...............
 
Path : /opt/tivoli/tsm/client/api/bin64 <-- in this path dsm.opt and dsm.sys files that i showed below

***dsm.opt****
SErvername TSMSrv01
**********************
***dsm.sys*****
SErvername TSMsrv01
COMMMethod TCPip
TCPPort 1500
TCPServeraddress 10.10.0.68
PASSWORDAccess prompt
* passworddir /export/home/oravis
**************************************
/opt/tivoli/tsm/client/oracle/bin64 <--this is the path where tdpo.opt file exist that i showed you below
********tdpo.opt**********
DSMI_ORC_CONFIG /opt/tivoli/tsm/client/api/bin64/dsm.opt
DSMI_LOG /opt/tivoli/tsm/client/oracle/bin64/
*TDPO_FS orc8_db
TDPO_NODE admin
*TDPO_OWNER <username>
TDPO_PSWDPATH /opt/tivoli/tsm/client/oracle/bin64
*TDPO_DATE_FMT 1
*TDPO_NUM_FMT 1
*TDPO_TIME_FMT 1
*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4

*****************************************

Output of my tdpoconf showenvi...


# tdpoconf showenvironment
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle
Version 5, Release 5, Level 1.0
(C) Copyright IBM Corporation 1997, 2008. All rights reserved.

Data Protection for Oracle Information
Version: 5
Release: 5
Level: 1
Sublevel: 0
Platform: 64bit TDP Oracle SUN
Tivoli Storage Manager Server Information
Server Name: IBTX-TSM
Server Address: 10.10.0.68
Server Type: Windows
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name:
Node Name: admin
Node Type: TDP Oracle SUN
DSMI_DIR: /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/api/bin64/dsm.opt
TDPO_OPTFILE: /opt/tivoli/tsm/client/oracle/bin64/tdpo.opt
Password Directory: /opt/tivoli/tsm/client/oracle/bin64
Compression: FALSE
License Information: License file exists and contains valid license data.

--------------------------------------------------------------
when i try to backup using RMAN i found the below error
RMAN> run {
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup archivelog all;
}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 06/02/2010 14:28:44
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
SVR4 Error: 106: Error 106
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 106, sbtopen: system error
 
Last edited:
TSM Lover,

error 106 indicates you have problem with accessing (writing) to error log. Check that first.

Second thing, is there any other backup system on this server?

I have similar problem on SUN that used to be backed up using Legato Networker...
 
Hi,

msosin:
had to figure it out when TDP refused to work - problem was that only 32bit API libraries were correctly registered during setup
Maybe it was related to installing TDP to local zone - but since I do that, I never had a problem
tsmlover:
7011 is OS error, it seems you did not follow 7. change the log permissions

Harry
 
Last edited:
Harry please explain the below thing

in my case the dsm.opt file is exist on this location """/opt/tivoli/tsm/client/api/bin64/"""


/opt/tivoli/tsm/client/oracle/bin64/dsm.opt:
*servername must correspond to servername stanza in /opt/tivoli/tsm/client/api/bin64/dsm.sys
servername tsmserver

plzz give me the output and path of your dsm.opt and dsm.sys please i am confused with server name stanza
 
Harry_Redl,

maybe you can help me (coz no one else can),

I used to have legato to backup oracle on one server. At the moment TDP and BA took its place.

The only problem is, that RMAN doesn't use right librart : NMO isntead of TDP.

I recomplied library, I relinked all possible libraries (as far as I know), and still same problem.

If you need any further info, you can go through this topic:

http://adsm.org/forum/showthread.php?p=85750#post85750

Thanks in advance,

M
 
put dsm.opt in /opt/tivoli/tsm/client/oracle/bin64
and dsm.sys in /opt/tivoli/tsm/client/api/bin64

if that doesn't work, create a softlink:

ln -s /opt/tivoli/tsm/client/api/bin64/dsm.sys /opt/tivoli/tsm/client/oracle/bin64/dsm.sys

That should do the job



tsmlover said:
Harry please explain the below thing

in my case the dsm.opt file is exist on this location """/opt/tivoli/tsm/client/api/bin64/"""


/opt/tivoli/tsm/client/oracle/bin64/dsm.opt:
*servername must correspond to servername stanza in /opt/tivoli/tsm/client/api/bin64/dsm.sys
servername tsmserver

plzz give me the output and path of your dsm.opt and dsm.sys please i am confused with server name stanza
Click to expand...
 
Hi,

tsmlover:
I gave you the path and the content of all files needed
/opt/tivoli/tsm/client/api/bin/dsm.sys
/opt/tivoli/tsm/client/oracle/bin64/dsm.opt
/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt

Do not forget that there are symbolic links to dsm.sys and dsm.opt created during setup (linked to /usr filesystem). What I do is to delete all the links and have just files I create - this way I am sure it accesses the files I want.
anything after "*" in the files is the comment, so the dsm.opt can have just only one line:
servername tsmsrv

msosin:
read the thread and it seems to me you have wrong links:
rwxrwxrwx 1 oracle dba 16 Oct 31 2008 /oradata/zbyt/app/product/9.2.0/lib/libobk.so -> /lib/libnwora.so
this should point to /opt/tivoli/tsm/client/oracle/bin64/libobk.so
... atleast I think ....


Harry
 
These are correct now (libobk.so), but nothing has changed eversince...
 
ok but there is no dsm.opt file in /opt/tivoli/tsm/client/oracle/bin64
what i do copy this file and past on /opt/tivoli/tsm/client/oracle/bin64


dsm.opt and dsm.sys are in the same directory
 
Last edited:
You must log in or register to reply here.

Data Privacy Impact Assessment

Compliance Assurance in Every Byte: Discover the Impact of Our DPIA Services.

Sponsor ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

Navigation Menu

Forums
   IBM TSM
   EMC Backup and Recovery
   Symantec NetBackup  
   SAN  
   NAS
   Platforms / OS
Mailing List Archives
   ADSM-L
User Groups

NordVPN 3 Months FREE

Help Support ADSM.ORG and Get NordVPN with 64% Off and 3 Months FREE.

NordVPN with 64% off + 3 months FREE

Forum statistics

Threads
31,974
Messages
135,448
Members
21,953
Latest member
jrogers
Back
Top