Home » RDBMS Server » Backup & Recovery » ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer (Oracle,11.2.0.3,AIX 64bit)
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer [message #570894] Sat, 17 November 2012 13:38 Go to next message
bhaarathim
Messages: 3
Registered: November 2012
Junior Member
Hi,

We have configured tivoli and getting the below error while execute rman backup.Can you please help me resolve the issue.

> rman target / catalog rman/*****@CATLOGDB

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Nov 17 13:35:03 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: AMTMXPRD (DBID=534215973)
connected to recovery catalog database

RMAN>
run {

RMAN> 2> allocate channel t1 type 'sbt_tape' MAXPIECESIZE 2G
3> parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> allocate channel t2 type 'sbt_tape' MAXPIECESIZE 2G
5> parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
6> allocate channel t3 type 'sbt_tape' MAXPIECESIZE 2G
7> parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
8> allocate channel t4 type 'sbt_tape' MAXPIECESIZE 2G
9> parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
10> allocate channel t5 type 'sbt_tape' MAXPIECESIZE 2G
11> parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
12> allocate channel t6 type 'sbt_tape' MAXPIECESIZE 2G
13> parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
14> allocate channel t7 type 'sbt_tape' MAXPIECESIZE 2G
15> parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel t8 type 'sbt_tape' MAXPIECESIZE 2G
parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
16> 17> 18> backup incremental level 0 cumulative database filesperset=1;
#delete noprompt force obsolete;
release channel t1;
19> 20> 21> release channel t2;
release channel t3;
release channel t4;
22> 23> 24> release channel t5;
25> release channel t6;
26> release channel t7;
27> release channel t8;
28> }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 11/17/2012 13:35:15
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
IBM AIX RISC System/6000 Error: 106: For future use
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 106, sbtopen: system error

RMAN> show all;

RMAN configuration parameters for database with db_unique_name AMTMXPRD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'DESK';
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DESK TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DESK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DESK TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DESK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/omxpd00/u00/app/oracle/product/11.2.0/dbs/snapcf_AMTMXPRD.f'; # default

RMAN>

Regards,
Bharati

Report message to a moderator

Re: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer [message #570895 is a reply to message #570894] Sat, 17 November 2012 13:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>RMAN-03009: failure of allocate command on t1 channel at 11/17/2012 13:35:15
>ORA-19554: error allocating device, device type: SBT_TAPE, device name:
>ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
>IBM AIX RISC System/6000 Error: 106: For future use
>Additional information: 7011
>ORA-19511: Error received from media manager layer, error text:
>SBT error = 7011, errno = 106, sbtopen: system error

Oracle is the victim; not the culprit.
Issue resides external to Oracle & between the OS & media (tape) library.

when was the last time RMAN successfully accessed Tivoli?
What changed since then?

[Updated on: Sat, 17 November 2012 13:45]

Report message to a moderator

Re: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer [message #570896 is a reply to message #570895] Sat, 17 November 2012 13:52 Go to previous messageGo to next message
bhaarathim
Messages: 3
Registered: November 2012
Junior Member
This is the first time we are trying to take backup.

Report message to a moderator

Re: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer [message #570897 is a reply to message #570896] Sat, 17 November 2012 14:00 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>This is the first time we are trying to take backup.

Good Luck.

consider posting in AIX or Tivoli forum

Report message to a moderator

Re: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer [message #570899 is a reply to message #570894] Sat, 17 November 2012 14:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68730
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Your TDPO installtion or configuration is not correct.
Check the logs you'll find in directory pointed by the parameter DSMI_LOG in your tdpo confirguration file. The file is tdpoerror.log. There is also a trace file generated in user_dump_dest.
Check you have a file agent.lic in opt/tivoli/tsm/client/oracle/bin64 directory.

The first thing is to check your tdpo file:
tdpoconf showenvironment -TDPO_OPTFILE==/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt


Then the first RMAN script to execute to chek your tdpo environment is a simple
run {	
   allocate channel t1 type 'sbt_tape' 	
      parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';	
}

Until this works you cannot do any backup.

Regards
Michel

Report message to a moderator

Re: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer [message #570901 is a reply to message #570899] Sat, 17 November 2012 14:53 Go to previous messageGo to next message
bhaarathim
Messages: 3
Registered: November 2012
Junior Member

Hi Michel,

Thank you for the information.

RMAN> run {
allocate channel t1 type 'sbt_tape'
parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
}2> 3> 4>

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on t1 channel at 11/17/2012 14:38:06
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
IBM AIX RISC System/6000 Error: 106: For future use
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 106, sbtopen: system error

RMAN>

=======
The below trc file was generated,but sbtio.log was zero byte.

> more AMTMXPRD_ora_24576104.trc
Trace file /omxpd00/u00/app/oracle/diag/rdbms/amtmxprd/AMTMXPRD/trace/AMTMXPRD_ora_24576104.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /omxpd00/u00/app/oracle/product/11.2.0
System name: AIX
Node name: odcattsm03-man
Release: 1
Version: 7
Machine: 00C2DB544C00
Instance name: AMTMXPRD
Redo thread mounted by this instance: 1
Oracle process number: 34
Unix process pid: 24576104, image: oracle@odcattsm03-man (TNS V1-V3)


*** 2012-11-17 14:46:00.700
*** SESSION ID:(1895.645) 2012-11-17 14:46:00.700
*** CLIENT ID:() 2012-11-17 14:46:00.700
*** SERVICE NAME:(SYS$USERS) 2012-11-17 14:46:00.700
*** MODULE NAME:(rman@odcattsm03-man (TNS V1-V3)) 2012-11-17 14:46:00.700
*** ACTION NAME:(0000001 STARTED1) 2012-11-17 14:46:00.700

SKGFQ OSD: Error in function sbtinit on line 2763
SKGFQ OSD: Look for SBT Trace messages in file /omxpd00/u00/app/oracle/diag/rdbms/amtmxprd/AMTMXPRD/trace/sbtio.log
SBT Initialize failed for libobk.a(shr.o)

Regards,
Bharathi

Report message to a moderator

Re: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer [message #570902 is a reply to message #570901] Sat, 17 November 2012 15:10 Go to previous message
Michel Cadot
Messages: 68730
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Start with the FIRST thing not with last one.

Regards
Michel

Report message to a moderator

Previous Topic: How to link asm file alias and db file names?
Next Topic: How to check for VSS support
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 13 20:12:25 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.