• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

TDPO/RMAN backup error

unixandtsm

ADSM.ORG Member
#1
Hi all,

RMAN backup failed with below error. Any suggestion on how to solve this issue ?

Code:
ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer

Linux-x86_64 Error: 406: Unknown system error

Additional information: 7011

ORA-19511: Error received from media manager layer, error text:

   SBT error = 7011, errno = 406, sbtopen: system error
Thanks in advance!
 

moon-buddy

ADSM.ORG Moderator
#6
how and where to check if passwd is expired ?
There are two passwords - the TDP for Oracle password set at the dsmc prompt (dsmc -se=<TDP_Server_name>) and the TDPO password set at tdpoconf password.

To check if these are OK, login with dsmc -se=<TDP_Server_name> and if the password is OK, you will not be prompted.

The TDPO side should be checked by your DBA team. If they engage RMAN manually, they would know if the password has expired.

But, ask first if there has been any other changes before chasing after paswords.
 
Last edited:

mccleld

ADSM.ORG Senior Member
#7
What @moon-buddy says and also I'd suggest running the 'tdpoconf showenv' utility to check that the TSM side of the TDPO configuration is all still setup correctly.

A common gotcha: check that the options files and any errorlogs they specify are still accessible by the user the RMAN backup script is invoked by - for example, the 'oracle' user rather than the 'root' user.

___________
David Mc
London, UK
 

unixandtsm

ADSM.ORG Member
#8
Hi Ed and David,

Now the backup is failing with
Code:
ANS1192E (RC959)  Specifying the error log '*' as a symbolic link is not allowed
below IBM link says that location specified for ERRORLOGNAME in dsm.sys should have write permissions but the file is having write permissions
http://www-01.ibm.com/support/docview.wss?uid=swg1IC46968

below is the part of dsm.sys
Code:
errorlogname            /var/opt/tivoli/tsm/log/dsmerror.log
and below are the permissions on the file specified above
Code:
-rw-rw-rw- 1 root root 266M Sep 11 05:19 /var/opt/tivoli/tsm/log/dsmerror.log
Please help on this.
Thanks in advance!
 

moon-buddy

ADSM.ORG Moderator
#9
When using TDP for Oracle, TSM is usually setup with a mulitple stanza DMS.SYS file. The location and name of the error.log file you specified, is it for the BA Client or for the TDP client?
 

unixandtsm

ADSM.ORG Member
#10
Hi Ed,

Not sure, because there is only one entry in dsm.sys file for errorlogname.
Below is the dsm.sys file
Code:
SErvername  TSM_ BA
   COMMmethod         TCPip
   TCPPort            1500
   Passwordaccess     generate
  * nodename           <node_name>
   TCPServeraddress   <tsm_server_name>


SErvername  TSM-Oracle
PASSWORDACCESS PROMPT
QUERYSCHEDPERIOD 12
NODENAME node_name
   COMMmethod         TCPip
   TCPPort            1500
   TCPServeraddress   <tsm_server_name>

*nodename               YourNameHere
resourceutilization     10
commrestartduration     10
commrestartinterval     120
compression             yes

errorlogname            /var/opt/tivoli/tsm/log/dsmerror.log
errorlogretention       30 d

schedlogname            /var/opt/tivoli/tsm/log/dsmsched.log
schedlogretention       30 d
inclexcl                /opt/tivoli/tsm/client/config/dsmc/inclexcl.dat
largecommbuffers        yes
maxcmdretries           2
memoryefficientbackup   no
*passwordaccess         generate
*passwordaccess          prompt
password                client
queryschedperiod        2
retryperiod             1

schedmode               prompt
tcpbuffsize             32
tcpnodelay              no
tcpwindowsize           32
txnbytelimit            25600
tcpnodelay              no
managedservices         schedule webclient
 

unixandtsm

ADSM.ORG Member
#12
Back to the first error again

Code:
ORA-19554: error allocating device, device type: SBT_TAPE, device name: 
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux-x86_64 Error: 2534: Unknown system error
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
   SBT error = 7011, errno = 2534, sbtopen: system error
 

moon-buddy

ADSM.ORG Moderator
#13
Back to the first error again

Code:
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux-x86_64 Error: 2534: Unknown system error
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
   SBT error = 7011, errno = 2534, sbtopen: system error
Can you check how many channels the DBA set RMAN for? You many need to enter a RESOURCEUTILIZATION value at the TDP stanza to avoid this error:

RESOURCEUTILIZATION <some_value_up_to_10>
 

meurnt

ADSM.ORG Member
#14
This error seems oracle package was installed without a license file, can you please verify the license file(agent.lic) under your tdpo installation path..
If it missed, install new oracle tdpo package or copy license file from other valid server

Thanks
Krish
Http://www.tsmguide.co.cc
 

iscadmin

ADSM.ORG Member
#15
Hi There,

Even I am facing same error for our TDP environment. We have IBM Spectrum protect and Oracle TDP configured on AIX.
Earlier also was facing same issue some two weeks back. Then we have changed path for it so it worked fine till day before yesterday and since yesterday its failing.

Error:
ORA-19554: error allocating device, device_type: SBT_TAPE, device_name:
ORA-27211: Failed to load Media Management Library

Thanks,
Vivek Kadam
Pune, IND
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 9 20.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 23 52.3%
  • Let's be formal and just say Spectrum Protect

    Votes: 8 18.2%
  • Other (please comement)

    Votes: 4 9.1%

Forum statistics

Threads
31,058
Messages
132,247
Members
21,273
Latest member
ctauber
Top