This discussion is archived
14 Replies Latest reply: Nov 20, 2012 12:21 PM by timscn RSS

ORA-27211 tsm6.3_aix7.1.0.0

timscn Newbie
Currently Being Moderated
hi all
help please;)
i have tiv 6.3 and aix 7.1 and oracle 11.2
i want to allocate channel but i have error((
RMAN> @1

RMAN> run
2> {
3> allocate channel sbt1 type sbt parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
4> release channel sbt1;
5> }
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on sbt1 channel at 11/19/2012 14:17:31
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 8

RMAN> **end-of-file**

RMAN>


-bash-3.00# ls -lp /usr/tivoli/tsm/client/oracle/bin64/
total 4128
drwxrwxrwx 2 root system 256 Jul 10 17:38 EN_US/
-rwxrwxrwx 1 root system 47 Sep 23 2011 agent.lic
-rwxrwxrwx 1 root system 130 Nov 13 18:00 dsm.opt
-rwxrwxrwx 1 root system 0 Nov 05 10:18 libobk64.a
-rwxrwxrwx 1 root system 783 Nov 05 13:00 tdpo.opt
-rwxrwxrwx 1 root system 691 Sep 23 2011 tdpo.opt.smp64
-rwxrwxrwx 1 root system 1018481 Sep 23 2011 tdpoconf
-rwxrwxrwx 1 root system 1074232 Sep 23 2011 tdposync
-bash-3.00# cat /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the AIX Data Protection for Oracle 64bit
*********************************************************************

*DSMI_ORC_CONFIG    /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
*DSMI_LOG           /home/oracle/DSMI_LOG

*TDPO_FS            orc9_db
*TDPO_NODE          <hostname>
*TDPO_OWNER         <username>
*TDPO_PSWDPATH      /usr/tivoli/tsm/client/oracle/bin64

*TDPO_DATE_FMT      1
*TDPO_NUM_FMT       1
*TDPO_TIME_FMT      1

*TDPO_MGMT_CLASS_2   mgmtclass2
*TDPO_MGMT_CLASS_3   mgmtclass3
*TDPO_MGMT_CLASS_4   mgmtclass4


dsmi_orc_config /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
dsmi_log /tivtemp

-bash-3.00# cat /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
SErvername tdpo
COMMMethod TCPip
TCPServeraddress 10.128.20.6
PASSWORDAccess generate
passworddir /home/oracle
nodename test
-bash-3.00# ls -lp /home/oracle/DSMI_LOG
total 0
-rwxrwxrwx 1 root system 0 Nov 19 14:06 1
-bash-3.00# ls -lp /home/oracle/DSMI_LOG
total 0
-bash-3.00# ls -lp /home/oracle/
total 200
-rw------- 1 oracle dba 15918 Nov 19 10:45 .bash_history
drwx------ 2 oracle dba 256 Dec 08 2011 .cedit/
drwxr-xr-x 3 oracle dba 256 Dec 08 2011 .java/
drwxr-xr-x 2 oracle dba 256 Nov 17 19:43 .mc/
-rwxr----- 1 oracle dba 590 Dec 08 2011 .profile
drwx------ 2 oracle dba 256 Feb 17 2012 .ssh/
-rw------- 1 oracle dba 59 Nov 14 15:29 .vi_history
-rw-r--r-- 1 oracle dba 133 Nov 13 18:30 1
drwxrwxrwx 2 root system 256 Nov 19 14:26 DSMI_LOG/
-rw------- 1 oracle dba 128 Jul 13 18:04 TSM.PWD
-rw-r--r-- 1 oracle dba 13258 Sep 17 09:55 test_120917_0954.nmon
-rw-r--r-- 1 oracle dba 511 Dec 09 2011 listener.ora
drwxr-xr-x 3 oracle dba 256 Dec 09 2011 oradiag_oracle/
-rw-r--r-- 1 oracle dba 29159 Nov 13 18:44 smit.log
-rw-r--r-- 1 oracle dba 1306 Nov 13 18:43 smit.script
-rw-r--r-- 1 oracle dba 3307 Nov 13 18:43 smit.transaction
-rw-r--r-- 1 oracle dba 138 Nov 05 14:16 test_tape_rman
-rw-r--r-- 1 oracle dba 1711 Sep 15 19:53 tnsnames.ora
-rw-r--r-- 1 oracle dba 0 Dec 10 2011 vi
-bash-3.00# ls -lp /home/oracle/ | grep DSMI_LOG
drwxrwxrwx 2 root system 256 Nov 19 14:26 DSMI_LOG/
-bash-3.00#
oracle@test:~>ls -lp $ORACLE_HOME/lib/libobk.a
lrwxrwxrwx 1 oracle dba 19 Nov 19 14:03 /oracle/OraHome11g/lib/libobk.a -> /usr/lib/libobk64.a
oracle@test:~>ls -lp /usr/lib/libobk64.a
lrwxrwxrwx 1 root system 46 Nov 19 14:02 /usr/lib/libobk64.a -> /usr/tivoli/tsm/client/oracle/bin64/libobk64.a
oracle@test:~>ls -lp /usr/tivoli/tsm/client/oracle/bin64/libobk64.a
-rwxrwxrwx 1 root system 0 Nov 05 10:18 /usr/tivoli/tsm/client/oracle/bin64/libobk64.a
oracle@test:~>


have i mistake in this configuration?
thanks a lot
  • 1. Re: ORA-27211 tsm6.3_aix7.1.0.0
    timscn Newbie
    Currently Being Moderated
    ping to test is established
  • 2. Re: ORA-27211 tsm6.3_aix7.1.0.0
    timscn Newbie
    Currently Being Moderated
    i have this installed package
    -bash-3.00# lslpp -l | grep tivoli
    tivoli.tivguid 1.3.4.1 COMMITTED IBM Tivoli GUID on AIX
    tivoli.tsm.client.api.64bit
    tivoli.tsm.client.oracle.aix.64bit
    tivoli.tsm.client.oracle.tools.aix.64bit
    tivoli.tsm.loc.client.oracle.aix.64bit.ela
    tivoli.tivguid 1.3.4.1 COMMITTED IBM Tivoli GUID on AIX
    -bash-3.00#
  • 3. Re: ORA-27211 tsm6.3_aix7.1.0.0
    timscn Newbie
    Currently Being Moderated
    [I followed this sequence |http://pic.dhe.ibm.com/infocenter/tsminfo/v6r3/topic/com.ibm.itsm.db.orc.doc/t_dporc_quickcfg.html]

    Edited by: standby_finich on 19/11/2012 4:46
  • 4. Re: ORA-27211 tsm6.3_aix7.1.0.0
    Levi-Pereira Guru
    Currently Being Moderated
    It's not a RMAN or Oracle issue, but is TSM issue.
    dsmi_orc_config /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
    dsmi_log /tivtemp
    Check if OS user "oracle" have permssion to read,write on DSM log directory "/tivtemp'

    Put here output of "/tivtemp/tdpoerror.log"
  • 5. Re: ORA-27211 tsm6.3_aix7.1.0.0
    timscn Newbie
    Currently Being Moderated
    hi thanks for reply


    -bash-3.00# cat /tivtemp/tdpoerror.log
    -bash-3.00# ls -lp /tivtemp/
    total 0
    -rw-r--r-- 1 root system 0 Nov 05 13:16 .toc
    drwxrwxrwx 3 root system 256 Nov 05 13:16 TSMORA_AIX/
    -rwxrwxrwx 1 oracle dba 0 Jul 13 18:03 tdpoerror.log
    -bash-3.00# ls -lp /tivtemp/
    total 0
    -rw-r--r-- 1 root system 0 Nov 05 13:16 .toc
    drwxrwxrwx 3 root system 256 Nov 05 13:16 TSMORA_AIX/
    -rwxrwxrwx 1 oracle dba 0 Jul 13 18:03 tdpoerror.log
    -bash-3.00#
    oracle@test:~>touch /tivtemp/test_oracle_user
    oracle@test:~>vi /tivtemp/test_oracle_user
    testoracle@test:~>cat /tivtemp/test_oracle_user
    test
    oracle@test:~>

    tivtemp/tdpoerror.log is empty ((
  • 6. Re: ORA-27211 tsm6.3_aix7.1.0.0
    Levi-Pereira Guru
    Currently Being Moderated
    Try it:
    {message:id=9452032}
  • 7. Re: ORA-27211 tsm6.3_aix7.1.0.0
    timscn Newbie
    Currently Being Moderated
    thanks but ((
    oracle@test:~>tdpoconf SHOWENV -TDPO_OPTfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
    exec(): 0509-036 Cannot load program tdpoconf because of the following errors:
    0509-150 Dependent module /usr/lib/libobk64.a(shr.o) could not be loaded.
    0509-153 File /usr/lib/libobk64.a is not an archive or
    the file could not be read properly.
    0509-026 System error: Cannot run a file that does not have a valid format.
    oracle@test:~>
    oracle@test:~>ls -lp /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
    -rwxrwxrwx 1 root system 783 Nov 05 13:00 /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
    oracle@test:~>ls -lp /usr/lib/libobk64.a
    lrwxrwxrwx 1 root system 46 Nov 19 17:01 /usr/lib/libobk64.a -> /usr/tivoli/tsm/client/oracle/bin64/libobk64.a
    oracle@test:~>ls -lp /oracle/OraHome11g/lib/libobk.a
    lrwxrwxrwx 1 oracle dba 46 Nov 19 17:00 /oracle/OraHome11g/lib/libobk.a -> /usr/tivoli/tsm/client/oracle/bin64/libobk64.a
    oracle@test:~>
  • 8. Re: ORA-27211 tsm6.3_aix7.1.0.0
    Levi-Pereira Guru
    Currently Being Moderated
    standby_finich wrote:
    thanks but ((
    oracle@test:~>tdpoconf SHOWENV -TDPO_OPTfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
    exec(): 0509-036 Cannot load program tdpoconf because of the following errors:
    0509-150 Dependent module /usr/lib/libobk64.a(shr.o) could not be loaded.
    0509-153 File /usr/lib/libobk64.a is not an archive or
    the file could not be read properly.
    0509-026 System error: Cannot run a file that does not have a valid format.
    oracle@test:~>
    oracle@test:~>ls -lp /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
    -rwxrwxrwx 1 root system 783 Nov 05 13:00 /usr/tivoli/tsm/client/oracle/bin64/tdpo.opt
    oracle@test:~>ls -lp /usr/lib/libobk64.a
    lrwxrwxrwx 1 root system 46 Nov 19 17:01 /usr/lib/libobk64.a -> /usr/tivoli/tsm/client/oracle/bin64/libobk64.a
    oracle@test:~>ls -lp /oracle/OraHome11g/lib/libobk.a
    lrwxrwxrwx 1 oracle dba 46 Nov 19 17:00 /oracle/OraHome11g/lib/libobk.a -> /usr/tivoli/tsm/client/oracle/bin64/libobk64.a
    oracle@test:~>
    That's your problem... contact TSM admin.
  • 9. Re: ORA-27211 tsm6.3_aix7.1.0.0
    timscn Newbie
    Currently Being Moderated
    thanks ))
    i reinstall tiv client
    and now have error

    RMAN> @1

    RMAN> run{
    2> allocate channel c1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)';
    3> release channel c1;
    4> }
    using target database control file instead of recovery catalog
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03009: failure of allocate command on c1 channel at 11/20/2012 11:53:51
    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: 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

    RMAN> **end-of-file**

    RMAN>

    how to describe this error and how repair?
    thanks;)
  • 10. Re: ORA-27211 tsm6.3_aix7.1.0.0
    timscn Newbie
    Currently Being Moderated
    *** 2012-11-20 12:32:01.459
    *** SESSION ID:(885.7) 2012-11-20 12:32:01.459
    *** CLIENT ID:() 2012-11-20 12:32:01.459
    *** SERVICE NAME:(SYS$USERS) 2012-11-20 12:32:01.459
    *** MODULE NAME:(rman@b2resnew (TNS V1-V3)) 2012-11-20 12:32:01.459
    *** ACTION NAME:(0000001 STARTED1) 2012-11-20 12:32:01.459

    skgfalo(se=0xffff3748, ctx=0x1083f9b8, dev=0x10984230, devparms=ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt), flags=33619970)
    skgfidev(se=0xffff3748 ctx=0x1083f9b8, dev=0x10984230)
    skgfidev(): processing: ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt)
    skgfidev(): setting environment variable: TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt
    skgfidev(): blkfactor_skgfqdev: 262144
    Try library from secure locations
    try loading : libobk.a(shr.o)
    Loaded (libobk.a(shr.o))
    entering sbtinit on line 2742
    SKGFQ OSD: Error in function sbtinit on line 2763
    SKGFQ OSD: Look for SBT Trace messages in file /oracle/diag/rdbms/b2resnew/work/trace/sbtio.log
    SBT Initialize failed for libobk.a(shr.o)
    skgfqfenvvars(): unsetenv environment variable: TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin/tdpo.opt

    it's with trace=1
  • 11. Re: ORA-27211 tsm6.3_aix7.1.0.0
    timscn Newbie
    Currently Being Moderated
    of course it's empty
    oracle@test:~>cat /oracle/diag/rdbms/test/work/trace/sbtio.log
    oracle@test:~>ls -lp /oracle/diag/rdbms/test/work/trace/sbtio.log
    -rw-r--r-- 1 oracle dba 0 Nov 05 10:12 /oracle/diag/rdbms/test/work/trace/sbtio.log
    oracle@test:~>
  • 12. Re: ORA-27211 tsm6.3_aix7.1.0.0
    timscn Newbie
    Currently Being Moderated
    it's work's fine
    thanks
    RMAN> @1

    RMAN> run{
    2> allocate channel c1 type 'SBT_TAPE' parms="ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)" trace=1;
    3> BACKUP CURRENT CONTROLFILE;
    4> release channel c1;
    5> }
    allocated channel: c1
    channel c1: SID=953 device type=SBT_TAPE
    channel c1: Data Protection for Oracle: version 6.3.0.0

    Starting backup at 20-NOV-12
    channel c1: starting full datafile backup set
    channel c1: specifying datafile(s) in backup set
    including current control file in backup set
    channel c1: starting piece 1 at 20-NOV-12
    channel c1: finished piece 1 at 20-NOV-12
    piece handle=01nqpgpk_1_1 tag=TAG20121120T125516 comment=API Version 2.0,MMS Version 6.3.0.0
    channel c1: backup set complete, elapsed time: 00:00:15
    Finished backup at 20-NOV-12

    released channel: c1

    RMAN> **end-of-file**

    RMAN>

    my mistake is :
    tdpoerror.log is located in /usr/tivoli/tsm/client/oracle/bin64

    thanks;)
  • 13. Re: ORA-27211 tsm6.3_aix7.1.0.0
    Levi-Pereira Guru
    Currently Being Moderated
    nice...
    Please, close your thread as answered
  • 14. Re: ORA-27211 tsm6.3_aix7.1.0.0
    timscn Newbie
    Currently Being Moderated
    thanks a lot for help)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points