Re: RMAN error allocating TDP channel....
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:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Saturday, January 23, 2010 10:40 AM To: ADSM-L@VM.MARIST.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 To: ADSM-L@VM.MARIST.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= Regards, Wellington -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: Monday, January 18, 2010 10:27 AM To: ADSM-L@VM.MARIST.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* lrwxrwxrwx1 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.solonovi...@bkme.com Please consider the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of
Re: RMAN error allocating TDP channel....RESOLVED
Hi Harry...and all who answered to this I went through all this permission checking and password and many stuff several times with no success. Turns out that the problem was about LICENSE ! The agent.lic file was not there...probably because I downloaded the TDP agent from the FTP websiteand there is no License Package thereat least on the version I´ve got. Anyway...I downloaded some other version from the IBM PartnerWorld website (a Base version) and installed only the license package. It´s working now. Thank you all. Mario From: Harry Redl To: ADSM-L@VM.MARIST.EDU Sent: Sun, January 24, 2010 3:58:34 PM Subject: Re: RMAN error allocating TDP channel Hi, I am almost sure there is tdpoerror.log in your /opt/tivoli/tsm/client/api/bin and this must be set to be writeable by oracle user (I suggest chmod 666 /opt/tivoli/tsm/client/api/bin/tdpoerror.log) Harry From: Mario Behring To: ADSM-L@VM.MARIST.EDU Sent: Sat, January 23, 2010 5:39:42 PM 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 To: ADSM-L@VM.MARIST.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= Regards, Wellington -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: Monday, January 18, 2010 10:27 AM To: ADSM-L@VM.MARIST.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* lrwxrwxrwx1 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.solonovi...@bkme.com Please consider the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Monday, January 18, 2010 5:13 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] RMAN error allocating TDP channel Hi list, I´ve installed TDP for Oracle 5.2.0.0 on
Re: RMAN error allocating TDP channel....
Hi, I am almost sure there is tdpoerror.log in your /opt/tivoli/tsm/client/api/bin and this must be set to be writeable by oracle user (I suggest chmod 666 /opt/tivoli/tsm/client/api/bin/tdpoerror.log) Harry From: Mario Behring To: ADSM-L@VM.MARIST.EDU Sent: Sat, January 23, 2010 5:39:42 PM 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 To: ADSM-L@VM.MARIST.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= Regards, Wellington -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: Monday, January 18, 2010 10:27 AM To: ADSM-L@VM.MARIST.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* lrwxrwxrwx1 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.solonovi...@bkme.com Please consider the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Monday, January 18, 2010 5:13 AM To: ADSM-L@VM.MARIST.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 alloca
Re: RMAN error allocating TDP channel....
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 workthe error persists... Any ideas? Mario From: Len Boyle To: ADSM-L@VM.MARIST.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:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Saturday, January 23, 2010 11:40 AM To: ADSM-L@VM.MARIST.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 To: ADSM-L@VM.MARIST.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= Regards, Wellington -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: Monday, January 18, 2010 10:27 AM To: ADSM-L@VM.MARIST.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* lrwxrwxrwx1 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 Technol
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:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Saturday, January 23, 2010 11:40 AM To: ADSM-L@VM.MARIST.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 To: ADSM-L@VM.MARIST.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= Regards, Wellington -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: Monday, January 18, 2010 10:27 AM To: ADSM-L@VM.MARIST.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* lrwxrwxrwx1 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.solonovi...@bkme.com Please consider the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Monday, January 18, 2010 5:13 AM To: ADSM-L@VM.MARIST.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
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 To: ADSM-L@VM.MARIST.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= Regards, Wellington -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: Monday, January 18, 2010 10:27 AM To: ADSM-L@VM.MARIST.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* lrwxrwxrwx1 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.solonovi...@bkme.com Please consider the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Monday, January 18, 2010 5:13 AM To: ADSM-L@VM.MARIST.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 occur
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= Regards, Wellington -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: Monday, January 18, 2010 10:27 AM To: ADSM-L@VM.MARIST.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* lrwxrwxrwx1 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.solonovi...@bkme.com Please consider the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Monday, January 18, 2010 5:13 AM To: ADSM-L@VM.MARIST.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
Re: 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* lrwxrwxrwx1 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.solonovi...@bkme.com Please consider the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Monday, January 18, 2010 5:13 AM To: ADSM-L@VM.MARIST.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."
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