Oracle TDP Configuration

D

djchopps0013

ADSM.ORG Senior Member
Joined
Jun 29, 2007
Messages
286
Reaction score
5
Points
0
Location
St Louis
Hey yall, Hope everyone had a good new years.

I have some questions regarding TSM TDP for Oracle. I originally didnt set up the TDP for Oracle so I am kinda confused.

We have recently created a new TSM server, we are in the process of migrating some of our clients from old to new server. I changed the option in the dsm.sys file for the baclient, but am not quite sure about the TDP. I checked the TDPO.CONF and found:
DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.opt

Then I cat on dsm.opt and see this
[root@stlam03d]:/opt/tivoli/tsm/client/oracle/bin64 # cat dsm.opt
SErvername tdpo


This doesnt make sense to me. There are no references to tcpserveraddress and the TDP is still backing up on the old TSM server.
Any help would be appreciated.
 
Last edited:
hi Chopps -

mind posting the corresponding stanza from the dsm.sys file?
the servername doesn't matter there as much as the TCPSERVERADDRESS field...

-Chef.
 
Last edited:
This is it. Thats why I am so confused. I dont even know where the SErvername tdpo came from. Our server is server1.

[root@stlam03d]:/opt/tivoli/tsm/client/oracle/bin64 # cat dsm.opt
SErvername tdpo


There is nothing else in the dsm.sys in the /opt/tivoli/tsm/client/oracle/bin64 directory. Here is the tdpo.opt.

[root@stlam03d]:/opt/tivoli/tsm/client/oracle/bin64 # cat tdpo.opt
***************************************************************************
* IBM Tivoli Storage Manager for Databases,
* Data Protection for Oracle 5.3.3.0
*
* Sample tdpo.opt for the HP-UX 11i (64bit)
* Data Protection for Oracle
*********************************************************************

DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /adv/logs/TSM
*to ensure RMAN can run correctly, make sure that tdpoerror.log has world write permissions

*TDPO_FS adsmorc
TDPO_NODE stlam03d_oracle
*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
 
You also need a dsm.sys in your /opt/tivoli/tsm/client/api/bin64 directory containing SErvername tdpo
and the option TCPServeraddress (your DNS servername)

The servername option here and the one in: /opt/tivoli/tsm/client/oracle/bin64 just have to correspond.
 
I usually just make a link back from my /opt/tivoli/tsm/client/ba/bin/dsm.sys to the api/bin64 dir -
that way you only have to change 1 and all are affected equally...

so what I was asking was for you to check your dsm.sys file for the TCPSERVERADDRESS field to be sure it was pointed to your new TSM server...

(I had originally posted for dsm.opt but then changed it -
you must have read the post before I changed it up!)

-Chef.
 
[root@stlam07t]:/opt/tivoli/tsm/client/oracle/bin64 # cat dsm.sys
Severname tdpo
tcpserveraddress stltsm3p.centene.com

[root@stlam07t]:/opt/tivoli/tsm/client/oracle/bin64 # tdpoconf showenv

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


Data Protection for Oracle Information
Version: 5
Release: 3
Level: 3
Sublevel: 0
Platform: 64bit TDP Oracle HP

Tivoli Storage Manager Server Information
Server Name: TDPO
Server Address: STLTSM1P.CENTENE.COM
Communication Method: TCP/IP

Session Information
Owner Name:
Node Name: stlam07t_oracle
DSMI_DIR: /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /opt/tivoli/tsm/client/oracle/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.



ANS1353E (RC53) Session rejected: Unknown or incorrect ID entered

Its still trying to hit the old TSM server.
 
you need some more info in that dsm.sys.
it should have a full blown stanza corresponding to the dsm.opt for stlam07t_oracle

also - did you notice this - and is it right?

Tivoli Storage Manager Server Information
Server Name: TDPO
Server Address: STLTSM1P.CENTENE.COM
Communication Method: TCP/IP
Click to expand...

it's obviously getting somewhere...is that the old server?
your dsm.sys file here is saying a different tcpserveraddress -

tcpserveraddress stltsm3p.centene.com
Click to expand...

what is in the /opt/tivoli/tsm/client/ba/bin/dsm.sys file for this stanza?

also - what is set in your oracle users env for DSMI_CONFIG &/or DSM_CONFIG -


-Chef.
 
Last edited:
[root@stlam07t]:/opt/tivoli/tsm/client/ba/bin # cat dsm.sys
************************************************************************
* IBM Tivoli Storage Manager *
* *
* Sample Client System Options file for UNIX (dsm.sys.smp) *
************************************************************************

* This file contains the minimum options required to get started
* using TSM. Copy dsm.sys.smp to dsm.sys. In the dsm.sys file,
* enter the appropriate values for each option listed below and
* remove the leading asterisk (*) for each one.

* If your client node communicates with multiple TSM servers, be
* sure to add a stanza, beginning with the SERVERNAME option, for
* each additional server.

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

SErvername server1
nodename stlam07t

COMMMethod TCPip
TCPPort 1500
TCPServeraddress stltsm3p.centene.com
Enablelanfree no
LANFREECommmethod TCPIP
LANFREETCPServeraddress stlam07t
LANFREETCPPort 1502
schedlogretention 3 D
errorlogr 3 D
Enablelanfree no

PasswordAccess generate
ManagedServices webclient schedule
SchedLogName /adv/logs/TSM/dsmsched.log
ErrorLogName /adv/logs/TSM/dsmerror.log

exclude.dir /.../oradata
exclude.dir /.../oralog
exclude.dir /.../oraarch
exclude.dir /adv/logs/TSM


SErvername tdpo

COMMMethod TCPip
TCPServeraddress stltsm3p.centene.com
Enablelanfree yes
LANFREECommmethod TCPIP
LANFREETCPServeraddress stlam07t
LANFREETCPPort 1502
 
cheffern said:
you need some more info in that dsm.sys.
it should have a full blown stanza corresponding to the dsm.opt for stlam07t_oracle

also - did you notice this - and is it right?



it's obviously getting somewhere...is that the old server?
your dsm.sys file here is saying a different tcpserveraddress -



what is in the /opt/tivoli/tsm/client/ba/bin/dsm.sys file for this stanza?

also - what is set in your oracle users env for DSMI_CONFIG &/or DSM_CONFIG -


-Chef.
Click to expand...

No this is not correct this is the old TSM server. STLTSM3P is the new. No environmental variables are set at all.

the only reference to any file is in the RMAN script

TDPO_OPT_FILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.${DATABASE}.opt
 
Last edited:
I would start out by grepping for any files that have this in them -

STLTSM1P / stltsm1p

see if you can find anything on the box at all that is really pointing to the old setup...
I'd even remove it from /etc/hosts if it is there...

-Chef.
 
Ok found a separate dsm.sys in the /opt/tivoli/tsm/cleint/api/bin64 dir that wasnt linked it was a static file. Changed it and it resolved my issue.

Thanks everybody.
 
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,982
Messages
135,471
Members
21,953
Latest member
smeegama
Back
Top