ADSM-L

Re: [ADSM-L] RMAN error allocating TDP channel....

2010-01-25 10:55:10
Subject: Re: [ADSM-L] RMAN error allocating TDP channel....
From: Howard Coles <Howard.Coles AT ARDENTHEALTH DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 25 Jan 2010 09:53:40 -0600
Sure, too much distance between oracle versions / BA Client version and the TDP 
version.  Try backing down the BA Client and associated API to 5.2.2 and see 
what happens.  You're trying backup a version of Oracle that's too old, using a 
BA Client (and more than likely the API) that's too new.  I've used the 5.2.2 
client on a 5.5 server but it's very unsupported.  Suggestions would include 
upgrading oracle and OS.  

But, just guessing based on what I see so far, I'd point to the spread in 
versions between the 5.2.2 TDP and 5.5.2 BA client (you don't mention the 
version of API).

You *may* be able to install the BA Client and associated API into separate 
directories just to support the TDP and have the 5.5.2 client to support file 
backups, but not being familiar with Sun and its install methods I can't be 
sure of that.  (for example the 5.2.2 stuff in /opt/tivoli/tsm/522/ and the 
5.5.2 stuff in a /opt/tivoli/tsm/555/ directory)

See Ya'
Howard Coles Jr.
John 3:16!


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Mario Behring
Sent: Saturday, January 23, 2010 10:40 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] RMAN error allocating TDP channel....

Hi list,

Server is Solaris SunOS 5.8
TDP for Oracle is 5.2.2.0
TSM Server is 5.5.0.0
TSM BA Client is 5.5.2.0

The link was created using the root user....


oraserver [root] /u01/app/oracle/product/8.1.7.3/lib> ls -la libobk.so
lrwxrwxrwx   1 root     other         18 Jan 23 12:11 libobk.so -> 
/usr/lib/libobk.so

The password was set using tdpoconf and the showenv option runs normally:


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:             32bit TDP Oracle SUN

TSM SERVER INFORMATION
 Server Name:          TSMSERVER
 Server Address:       10.1.0.2
 Server Type:          Windows
 Server Port:          1500
 Communication Method: TCP/IP

SESSION INFORMATION
 Owner Name:           root
 Node Name:            ORACLE
 Node Type:            TDP Oracle SUN
 DSMI_DIR:             /opt/tivoli/tsm/client/api/bin
 DSMI_ORC_CONFIG:      /opt/tivoli/tsm/client/oracle/bin/dsm.opt
 TDPO_OPTFILE:         /opt/tivoli/tsm/client/oracle/bin/tdpo.opt
 Password Directory:   /opt/tivoli/tsm/client/oracle/bin
 Compression:          FALSE


I have the error below when executing a RMAN script. What could be wrong?

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-07004: unhandled exception during command execution on channel t1
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
SVR4 Error: 106: Error 106
Additional information: 7011
ORA-19511: SBT error = 7011, er...


 
Any help is appreciated.


Mario




________________________________
From: Wellington KMK <wellington.kirubhakaran AT WIPRO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Sent: Mon, January 18, 2010 3:22:20 AM
Subject: Re: RMAN error allocating TDP channel....

After Creating the symbolic link... Please check the oracle user having read & 
write access on below files...

1) dsmerror.log
2) tdpoerror.log
3) TSM.PWD(tsm password file)

Test the connectivity from oracle user by issuing the below cmd...
Tdpoconf showenv -tdpo_optfile=<tdpo opt file>

Regards,
Wellington

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Grigori Solonovitch
Sent: Monday, January 18, 2010 10:27 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] RMAN error allocating TDP channel....

I have no experience with Solaris, but in AIX after installing TDP (I hope you 
have installed 5.5.2 not 5.2.0) you need to link TDP library in 
$ORACLE_HOME/lib to TDP directory:



[LPAR05]>ls -ltr $ORACLE_HOME/lib/*obk*

lrwxrwxrwx    1 oracle   dba              19 Jun 24 2007  
/home/oracle/product/10g/lib/libobk.a -> /usr/lib/libobk64.a

[LPAR05]>



Maybe you need to do the same.



Grigori G. Solonovitch



Senior Technical Architect



Information Technology  Bank of Kuwait and Middle East  http://www.bkme.com



Phone: (+965) 2231-2274  Mobile: (+965) 99798073  E-Mail: G.Solonovitch AT bkme 
DOT com



Please consider the environment before printing this Email





-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Mario Behring
Sent: Monday, January 18, 2010 5:13 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] RMAN error allocating TDP channel....



Hi list,



I´ve installed TDP for Oracle  5.2.0.0 on a Solaris 8 machine. The BA Client is 
5.5.2.0 and works fine.



I am getting an RMAN error when trying to execute a RMAN backup script. Looks 
like RMAN cannot allocate a channel through TDP Oracle....





RMAN-03022: compiling command: allocate

RMAN-03023: executing command: allocate

RMAN-00571:

===========================================================

RMAN-00569: =============== ERROR MESSAGE

STACK FOLLOWS ===============

RMAN-00571:

===========================================================

RMAN-03007: retryable error occurred during

execution of command: allocate

RMAN-07004: unhandled exception during

command execution on channel t1

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

SVR4 Error: 106: Error 106

Additional information: 7011

ORA-19511: SBT error = 7011, errno = 106,

sbtopen: system error

RMAN-10031: ORA-19624 occurred during call

to DBMS_BACKUP_RESTORE.DEVICEALLOCATE



Any help is appreciated.



Mario











Please consider the environment before printing this Email.

________________________________
"This email message and any attachments transmitted with it may contain 
confidential and proprietary information, intended only for the named 
recipient(s). If you have received this message in error, or if you are not the 
named recipient(s), please delete this email after notifying the sender 
immediately. BKME cannot guarantee the integrity of this communication and 
accepts no liability for any damage caused by this email or its attachments due 
to viruses, any other defects, interception or unauthorized modification. The 
information, views, opinions and comments of this message are those of the 
individual and not necessarily endorsed by BKME."

Please do not print this email unless it is absolutely necessary. 

The information contained in this electronic message and any attachments to 
this message are intended for the exclusive use of the addressee(s) and may 
contain proprietary, confidential or privileged information. If you are not the 
intended recipient, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately and destroy all copies of this message and 
any attachments. 

WARNING: Computer viruses can be transmitted via email. The recipient should 
check this email and any attachments for the presence of viruses. The company 
accepts no liability for any damage caused by any virus transmitted by this 
email. 

www.wipro.com