TDPO issue - can't load tdpoQueryVersion() function pointer

A

adam79

Active Newcomer
Joined
May 30, 2012
Messages
9
Reaction score
0
Points
0
Hello,
I have the following issue with TDPO installation. After installing TDPO 5.3 together with TSM 5.5 when I check the configuration it shows "0" version:

tdpoconf showenv:

Code: 
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:              0
 Release:              0
 Level:                0
 Sublevel:             0
 Platform:

Tivoli Storage Manager Server Information
 Server Name:          ****
 Server Address:       ****
 Server Type:          Windows
 Server Port:          1500
 Communication Method: TCP/IP

Session Information
 Node Name:            *************
 Node Type:            DP Oracle Win32
 DSMI_DIR:             C:\Program Files\Common Files\Tivoli\TSM\api
 DSMI_ORC_CONFIG:      C:\Program Files\tivoli\TSM\AgentOBA\dsm.opt
 TDPO_OPTFILE:         C:\Program Files\Tivoli\TSM\AgentOBA\tdpo.opt
 Compression:          FALSE
 License Information:  License file exists and contains valid license data.

tdpoerror.log shows the following errors:

Code: 
05/25/2012 11:49:51 TID<9080> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
05/25/2012 12:34:31 TID<9216> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
05/25/2012 12:37:24 TID<5404> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
05/25/2012 13:35:24 TID<5260> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
05/25/2012 13:35:44 TID<9408> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
05/28/2012 09:37:37 TID<6408> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
05/30/2012 09:40:13 TID<4676> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
05/30/2012 09:49:20 TID<7160> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
05/30/2012 10:02:59 TID<5520> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
05/30/2012 13:22:11 TID<4024> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
05/30/2012 13:22:23 TID<10204> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
05/31/2012 09:08:06 TID<6868> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.

Any ideas how to fix it?
I've tried to reinstall the TDPO client two times - still the same issue. I've also tried this with TSM client 5.5 and 6.2 - nothing helps.
Furthermore there are problems with rman scripts on this client - all scripts end with the following failure:

Code: 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: errore del comando allocate sul canale ch1 in 05/30/2012 11:26:04
ORA-19554: errore nell'allocare il dispositivo, tipo dispositivo: SBT_TAPE, nome dispositivo: 
ORA-27023: skgfqsbi: errore di protocollo di Media Manager
ORA-19511: E stato ricevuto un errore dal layer del gestore supporti, testo dell'errore:

Recovery Manager ha terminato.

Does this version issue can have influence on rman scripts ?
 
Hi,
try to check the bit size of your Oracle DB. In your configurations it must be 32bit.
Efim
 
Efim said:
Hi,
try to check the bit size of your Oracle DB. In your configurations it must be 32bit.
Efim
Click to expand...

Just checked:

Code: 
WORD_LENGTH
---------------------------------
32-bit

SQL>
 
Your tdpoconf output is showing the TDPO client at 5.5.1, but you say you installed TDPO 5.3? Check and see if there are any other installs of the TDPO client.
 
gimlet said:
Your tdpoconf output is showing the TDPO client at 5.5.1, but you say you installed TDPO 5.3? Check and see if there are any other installs of the TDPO client.
Click to expand...
My mistake in the post - I've installed TDPO 5.5.1. Then I uninstalled it and installed again - still the same issue.
 
I've just upgraded TDPO verison to the latest available: 5.5.2. And now tdpoconf showenv shows this error:

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


ANU2617E Could not get Data Protection for Oracle library version.


C:\Program Files\tivoli\TSM\AgentOBA>

tdpoerror.log:

Code: 
06/01/2012 09:26:46 TID<8080> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
06/01/2012 09:26:46 TID<8080> ==> ANU2617E Could not get Data Protection for Oracle library version.
06/01/2012 09:29:29 TID<7568> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
06/01/2012 09:29:29 TID<7568> ==> ANU2617E Could not get Data Protection for Oracle library version.
06/01/2012 09:32:43 TID<5448> ==> pscallTDPOQueryVersion(166): can't load tdpoQueryVersion() function pointer.
06/01/2012 09:32:43 TID<5448> ==> ANU2617E Could not get Data Protection for Oracle library version.

Unfortunetely there is no solution for this error:
http://pic.dhe.ibm.com/infocenter/t...com.ibm.itsm.db.orc.msgs.doc/msgs_orc159.html

ANU2617E: Could not get Data Protection for Oracle library version.
Explanation

The Data Protection for Oracle utility could not get Data Protection for Oracle library version. The library file used by Data Protection for Oracle utility is not a valid Data Protection for Oracle library.
System action

The Data Protection for Oracle utility exits.
User response

Check that Data Protection for Oracle was installed and set up correctly.
Click to expand...

I've double checked - after installation Windows gives a message that it was successfull.

I've also generated a TDPO trace file:

Code: 
TSM Trace   3067        8000       IBM Tivoli Storage Manager 5.5.0.05   Build date:  Tue Jun 02 15:10:06 2009

BEGINNING NEW TRACE

06/01/2012 09:50:33.268 [007564] [10028] : ..\common\ut\trace.cpp(2596): Tracing to file: C:\Program Files\tivoli\TSM\AgentOBA\tdpo.out.1
06/01/2012 09:50:33.268 [007564] [10028] : ..\common\ut\trace.cpp(2597): Tracefile maximum length set to 8000 MB.
06/01/2012 09:50:33.268 [007564] [10028] : ..\common\ut\trace.cpp(2609): ----------------------------------------------------------------
06/01/2012 09:50:33 - Trace begun.
06/01/2012 09:50:33.299 [007564] [10028] : psutil2.cpp         (1155):  tdpoDoDsmSetUp(): Enter
06/01/2012 09:50:33.299 [007564] [10028] : psutil2.cpp         (1172):  tdpoDoDsmSetUp(): dsmiDir = 'C:\Program Files\Common Files\Tivoli\TSM\api\', dsmiConfig = 'C:\Program Files\tivoli\TSM\AgentOBA\dsm.opt', dsmiLog = 'C:\Program Files\tivoli\TSM\AgentOBA\'
06/01/2012 09:50:33.424 [007564] [10028] : psutil2.cpp         (1195):  tdpoDoDsmSetUp(): Exit - OK

06/01/2012 09:50:33.424 [007564] [10028] : utility2.cpp        (1985): 
===========================================================
Tracing started for:
-----------------------------------------------------------
       Application Client:  DP Oracle Win32 32bit
              TDP Version:  5.5.2.0
  Compile Time API Header:  5.4.0.0
      Run Time API Header:  5.5.2.12
      Client Code Version:  5.5.0.5
===========================================================

06/01/2012 09:50:33.424 [007564] [10028] : utility2.cpp        (2029): 
 DSMI_DIR           : C:\Program Files\Common 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            : \adsmorc
 TDPO_NODE          : 
 TDPO_OWNER         : 
 TDPO_PSWDPATH      : C:\Program Files\Tivoli\TSM\AgentOBA\
 TDPO_TRACE_MAX     : 8000
 TDPO_TRACE_FILE    : C:\Program Files\tivoli\TSM\AgentOBA\tdpo.out
 TDPO_TRACE_FLAGS   : orclevel0 orclevel1 orclevel2
 TDPO_TEST_FLAGS    : 
 TDPO_MGMT_CLASS_2  : 
 TDPO_MGMT_CLASS_3  : 
 TDPO_MGMT_CLASS_4  : 
 TDPO_NUM_BUFFERS   : 1
 TDPO_DATE_FORMAT   : 
 TDPO_TIME_FORMAT   : 
 TDPO_NUM_FORMAT    : 
 TDPO_LANGUAGE      : 

06/01/2012 09:50:33.424 [007564] [10028] : showenv.cpp         ( 259):  tdpoShowEnv(): Enter
06/01/2012 09:50:33.471 [007564] [10028] : showenv.cpp         ( 305):  tdpoShowEnv(): 'ANU2617E Could not get Data Protection for Oracle library version.'
06/01/2012 09:50:33.471 [007564] [10028] : showenv.cpp         ( 310):  tdpoShowEnv(): pscallTDPOQueryVersion() failed. rc = -1

06/01/2012 09:50:33.471 [007564] [10028] : tdpoconf.cpp        ( 504):  main(): Exit - tdpoShowEnv() failed. rc = -1

06/01/2012 09:50:33.471 [007564] [10028] : tdpoconf.cpp        ( 641):  closeSess(): Enter
06/01/2012 09:50:33.471 [007564] [10028] : tdpoconf.cpp        ( 650):  closeSess(): Exit - OK


END OF DATA - close

No idea what else can be done here :/
 
Last edited:
Hi
Check version %ORACLE_HOME%/bin/orasbt.dll and compare it with dll from TDPO installation package.
Did you restart the Oracle instance after install TDPO ?
Efim
 
I've found orasbt.dl in winnt/system32 and in fact yes, it was different from the orasbt.dl in TDPO installation package. I've replaced it with the file from package and it solved the version issue - now TDPO correctly shows its version :)

But unfortunately I still can't execute rman scripts, the same errors still occurs:

Code: 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: errore del comando allocate sul canale ch1 in 06/05/2012 15:37:48
ORA-19554: errore nell'allocare il dispositivo, tipo dispositivo: SBT_TAPE, nome dispositivo: 
ORA-27023: skgfqsbi: errore di protocollo di Media Manager
ORA-19511: È stato ricevuto un errore dal layer del gestore supporti, testo dell'errore:

Recovery Manager ha terminato.

+==============================================================================+
 [RMAN-END $Name: tvdbackup-10.05.final.b $, $Revision: 369 $]: 2012-06-05_15:37:52
+==============================================================================+

And I can't restart Oracle because this is an important productive server. Do you think that restarting would help here ?
 
Hi,
I believe it is necessary.
Efim
 
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,975
Messages
135,449
Members
21,952
Latest member
jrogers
Back
Top