14 Replies Latest reply: Nov 20, 2012 2:21 PM by timscn RSS

    ORA-27211 tsm6.3_aix7.1.0.0

    timscn
      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
          ping to test is established
          • 2. Re: ORA-27211 tsm6.3_aix7.1.0.0
            timscn
            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
              [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
                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
                  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
                    Try it:
                    {message:id=9452032}
                    • 7. Re: ORA-27211 tsm6.3_aix7.1.0.0
                      timscn
                      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
                        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
                          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
                            *** 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
                              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
                                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
                                  nice...
                                  Please, close your thread as answered
                                  • 14. Re: ORA-27211 tsm6.3_aix7.1.0.0
                                    timscn
                                    thanks a lot for help)