ADSM-L

ANS0237E TDP for Oracle for Windows

2001-11-30 09:45:43
Subject: ANS0237E TDP for Oracle for Windows
From: "paolo.nasca AT inwind DOT it" <paolo.nasca AT INWIND DOT IT>
Date: Fri, 30 Nov 2001 16:43:00 +0200
Hi,
I have a problem with TDP for Oracle.

This is my environment:
SERVER (AIX)
TSM server v. 4.1.4.4

CLIENT (Windows 2000 SP2)
TSM backup/archive client v. 4.2.0.0
TDP for Oracle for Windows v. 2.2.0.0
Oracle v. 8.1.7.1

STEP 1
On the server, I have created the client node.

STEP 2
On the client, I have stored the password on the registry by the command
C:\Program Files\Tivoli\TSM\AgentOBA>tdpoconf password -tdpo_optfile=.\tdpo.opt

STEP 3
I have checked my configuration by the command
C:\Program Files\Tivoli\TSM\AgentOBA>tdpoconf showenv -tdpo_optfile=.\tdpo.opt
but something is wrong.
Be carefull, the "Tivoli Data Protection for Oracle for Windows Installation and
user's guide, version 2 release2 (SH26-4113-01)" pag. 15 and the Redbook 
"Backing Up
Oracle Using Tivoli Storage Managment (SG24-6249-00)" pag. 131 advise to use
"PASSWORDAccess GENERATE" and not "PASSWORDAccess PROMPT"

You can see the ouput
====START OUTPUT FROM tdpoconf showenv====
TDP FOR ORACLE INFORMATION
  Version:              2
  Release:              2
  Level:                0
  Sublevel:             0
  Platform:             TDP Oracle NT

TSM SERVER INFORMATION
  Server Name:          CALDERONE
  Server Address:       172.18.64.119
  Communication Method: TCP/IP

SESSION INFORMATION
  Owner Name:
  Node Name:            XXXX-ORA-ORA1
  DSMI_DIR:             C:\Program Files\Tivoli\TSM\api
  DSMI_ORC_CONFIG:      c:\program files\tivoli\tsm\agentoba\dsm.opt
  TDPO_OPTFILE:         .\tdpo.opt
  Password Directory:
  Compression:          FALSE

ANS0237E (RC2033) On dsmInit, the node is not allowed when 
PASSWORDACCESS=generate.
====STOP OUTPUT FROM tdpoconf showenv====

This is the tdpo.opt
DSMI_ORC_CONFIG    c:\program files\tivoli\tsm\agentoba\dsm.opt
DSMI_LOG           c:\program files\tivoli\tsm\agentoba\
TDPO_NODE          XXX-ORA-ORA1
*TDPO_AVG_SIZE     2000
TDPO_FS             orc8_db
*TDPO_NUM_BUFFERS   5
*TDPO_MGMT_CLASS2   mgmtclass2
*TDPO_MGMT_CLASS3   mgmtclass3
*TDPO_MGMT_CLASS4   mgmtclass4
tdpo_trace_flags orclevel0 orclevel1 orclevel2
tdpo_trace_file  C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.out

This is the dsm.opt
Servername        calderone
COMMMETHOD        tcpip
TCPPORT           1500
TCPSERVERADDRESS  172.18.64.119
NODENAME          XXX-ORA-ORA1
PASSWORDAccess    GENERATE
tracefile         C:\Program Files\Tivoli\TSM\AgentOBA\tsmapi.out
traceflag         api api_detail pid tid

This is the tdpo_trace_file file:
===========================================================
Tracing started for:
-----------------------------------------------------------
   Application Client :   TDP Oracle NT
   Application Client :   TDP Oracle NT
              Version :   2.2.0.0
      Build Date/Time :   Mar 26 2001 at 09:58:41
===========================================================
11/30/2001 14:15:54 <pid: 1524> <T1604>tdpoconf.cpp(287): main():Enter
 rc         : 0
 dsmHandle  : 0

11/30/2001 14:15:54 <pid: 1524> <T1604>tdpoconf.cpp(319): main()
 DSMI_DIR           : C:\Program Files\Tivoli\TSM\api\
 DSMI_LOG           : c:\program files\tivoli\tsm\agentoba\
 DSMI_ORC_DIR       : C:\Program Files\Tivoli\TSM\AgentOBA\
 DSMI_ORC_CONFIG    : c:\program files\tivoli\tsm\agentoba\dsm.opt
 TDPO_AVG_SIZE      : 50
 TDPO_FS            : \orc8_db
 TDPO_NODE          : XXXX-ORA-ORA1
 TDPO_OWNER         :
 TDPO_PSWDPATH      :
 TDPO_MAX_DEBUG_SIZE: 1024
 TDPO_TRACE_FILE    : C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.out
 TDPO_TRACE_FLAGS   : orclevel0 orclevel1 orclevel2
 TDPO_MGMT_CLASS_2  :
 TDPO_MGMT_CLASS_3  :
 TDPO_MGMT_CLASS_4  :

11/30/2001 14:15:54 <pid: 1524> <T1604>showenv.cpp(176): tdpoShowEnv(): Enter
11/30/2001 14:15:54 <pid: 1524> <T1604>session2.cpp(170): tdpoSession(): Enter
 rc       : 0
 dsmHandle: 0

11/30/2001 14:15:54 <pid: 1524> <T1604>session2.cpp(176): tdpoSession()
 ctxID    : 0
 dsmHandle: 0

11/30/2001 14:15:54 <pid: 1524> <T1604>session2.cpp(237): tdpoSession(): 
Calling dsmInitEx()
 dsmInit() retry: 0
 node           : XXXX-ORA-ORA1
 owner          :
 rc             : 0

11/30/2001 14:15:54 <pid: 1524> <T1604>session2.cpp(261): Exit: tdpoSession() 
dsmInit() failed
 rc       : 2033
 dsmHandle: 0

11/30/2001 14:15:54 <pid: 1524> <T1604>showenv.cpp(233): tdpoShowEnv(): 
tdpoSession() failed rc = 2033
11/30/2001 14:15:54 <pid: 1524> <T1604>showenv.cpp(254): tdpoShowEnv(): 
tdpoSession() - dsmHandle = 0, rc = 0
11/30/2001 14:15:54 <pid: 1524> <T1604>showenv.cpp(633): tdpoShowEnv(): Exit - 
OK
11/30/2001 14:15:54 <pid: 1524> <T1604>tdpoconf.cpp(412): main(): Exit
 rc       : 0

Be carefull, no tracefile is generated!!
No activity log messages from the node XXXX-ORA-ORA1 is present on the TSM 
server.


Any ideas?
Thank you


Paolo Nasca
Cleis Technology srl
Via E. Raggio, 4
16124 Genoa (ITALY)
Genoa switchboard: +39 010 24858.11
Milan switchboard: +39 02 66740.11
Mobile: +39 347 5927323
<Prev in Thread] Current Thread [Next in Thread>