Hi Len,
The link was created with Oracle down.
Also, I checked permission issues regarding the oracle user...like read/write
permission on dsmerrorl.log file (in my case located in /var/log).
I changed the permission on /opt/tivoli/tsm/client/oracle and
/opt/tivoli/tsm/client/ba directories with the _R option to allow the oracle
user to read/write/execute....
But nothing seems to work....the error persists...
Any ideas?
Mario
________________________________
From: Len Boyle <Len.Boyle AT SAS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Sent: Sat, January 23, 2010 4:09:20 PM
Subject: Re: RMAN error allocating TDP channel....
Good Day Mario,
After the link was created did you bounce the oracle data base. I am not sure
if it has changed, or different with the latest TSM client. But I was told that
the Oracle data base loads the libobk.so when it starts up and unless you
bounce Oracle it will not reload the file to pick up the tsm supplied copy.
Also is this a 32bit or 64bit instance of the Oracle data base.
A look on google seems to indicate that the problem may be a permissions
problem with the tsm log files.
One of the urls to look at is
http://linuxshellaccount.blogspot.com/2007/11/tsm-backups-most-misleading-error.html
Also look at
http://www.backupcentral.com/phpBB2/two-way-mirrors-of-external-mailing-lists-3/ibm-tsm-13/tdpo-rman-problems-96107/
len
-----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 11: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
|