12 Replies Latest reply: Nov 22, 2010 10:05 AM by Chinar RSS

    RMAN-06403: could not obtain a fully authorized session

    Yoav
      Hi,
      I am trying to duplicate 10204 instance with ASM to clone machine .
      I have checked that i can connect to the target / aux / rman instances before runing the duplicate script as you can see bellow.
      Also i checked that the Env. variable are correct :
      $ ps -ef | grep pmon
      oracle    5157     1  0 Feb16 ?        00:00:17 asm_pmon_+ASM
      oracle   30838     1  0 17:15 ?        00:00:00 ora_pmon_b3dev
      
      $ echo $ORACLE_HOME
      /software/oracle/B3DEV10gR2
      $ echo $ORACLE_SID
      b3dev
      -- AUX
      $ sqlplus sys/xxxx@b3dev as sysdba
      SQL*Plus: Release 10.2.0.4.0 - Production on Sun Nov 21 17:01:25 2010
      Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
      Connected to an idle instance.
      -- TARGET
      $ sqlplus sysxxxx@MYB3PROD as sysdba                   
      SQL*Plus: Release 10.2.0.4.0 - Production on Sun Nov 21 17:01:44 2010
      Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
      
      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      -- catalog
      $ sqlplus catman_b3prd/xxxxx@rman
      SQL*Plus: Release 10.2.0.4.0 - Production on Sun Nov 21 17:01:59 2010
      Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
      
      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      I opened the AUX instance in NOMOUNT mode , and then run the rman script.
      rman TARGET sys/xxxx@MYB3PROD CATALOG catman_b3prd/xxxx@rman AUXILIARY sys/xxxx@b3dev
      
      
      RMAN> 
      run
      {
      allocate channel 'dev_0' type 'sbt_tape'
      parms 'SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=b3prd,OB2BARLIST=b3prd)' maxopenfiles 16;
      ...
      set until time "to_date('17-11-2010 10:45:00','dd-mm-yyyy hh24:mi:ss')";
      duplicate target database to b3dev
      PFILE = /software/oracle/B3DEV10gR2/dbs/initb3dev.ora
      NOFILENAMECHECK;
      }
      Then I got the following error:

      Starting Duplicate Db at 21-NOV-10
      released channel: dev_0
      released channel: dev_1
      released channel: dev_2
      released channel: dev_3
      released channel: dev_4
      released channel: dev_5
      released channel: dev_6
      released channel: dev_7
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 11/21/2010 17:14:20
      RMAN-06403: could not obtain a fully authorized session
      RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available
      Thanks
        • 1. Re: RMAN-06403: could not obtain a fully authorized session
          ora_tech
          Hi,

          Check the tns service name is properly defined for both the databases on both nodes.

          Try to do tnsping for both services from both nodes.

          thanks,
          X A H E E R
          • 2. Re: RMAN-06403: could not obtain a fully authorized session
            Yoav
            Hi,
            Tnsping is working fine.
            I also should that i can connect using @XYZ to each instance
            Thanks
            • 3. Re: RMAN-06403: could not obtain a fully authorized session
              sb92075
              6403, 1, "could not obtain a fully authorized session"
              // *Cause: The most likely cause of this error is that one of the databases
              //         to which RMAN had previously connected is not started or has
              //         has been shutdown.  Other error messages should identify
              //         exactly which database is the problem.
              // *Action: Startup the database causing the problem.
              • 4. Re: RMAN-06403: could not obtain a fully authorized session
                Yoav
                Thanks ,
                But its not seems to be my case:
                SQL> startup nomount pfile='initb3dev.ora';
                ORACLE instance started.
                
                Total System Global Area 1073741824 bytes
                Fixed Size                  1271616 bytes
                Variable Size             301992128 bytes
                Database Buffers          763363328 bytes
                Redo Buffers                7114752 bytes
                rman TARGET sys/xxxxx@MYB3PROD CATALOG catman_b3prd/xxxx@rman AUXILIARY sys/xxxx@b3dev

                Recovery Manager: Release 10.2.0.4.0 - Production on Sun Nov 21 17:34:27 2010
                Copyright (c) 1982, 2007, Oracle. All rights reserved.
                connected to target database: B3PRD (DBID=3967311322)
                connected to recovery catalog database
                connected to auxiliary database (not started)
                No problem to connect using sqlplus with @ .
                No problem to connect with RMAN , to target/AXU/RMAN catalog
                
                Yet , i am still getting the error message
                
                Thanks                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                • 5. Re: RMAN-06403: could not obtain a fully authorized session
                  Chinar
                  Yoav wrote:
                  Thanks ,
                  But its not seems to be my case:
                  SQL> startup nomount pfile='initb3dev.ora';
                  ORACLE instance started.
                  
                  Total System Global Area 1073741824 bytes
                  Fixed Size                  1271616 bytes
                  Variable Size             301992128 bytes
                  Database Buffers          763363328 bytes
                  Redo Buffers                7114752 bytes
                  rman TARGET sys/xxxxx@MYB3PROD CATALOG catman_b3prd/xxxx@rman AUXILIARY sys/xxxx@b3dev

                  Recovery Manager: Release 10.2.0.4.0 - Production on Sun Nov 21 17:34:27 2010
                  Copyright (c) 1982, 2007, Oracle. All rights reserved.
                  connected to target database: B3PRD (DBID=3967311322)
                  connected to recovery catalog database
                  connected to auxiliary database (not started)
                  No problem to connect using sqlplus with @ .
                  No problem to connect with RMAN , to target/AXU/RMAN catalog
                  
                  Yet , i am still getting the error message
                  
                  Thanks
                  You still did not started auxiliary instance because you got message through rman connected to auxiliary database (not started) but you must be get connected to auxiliary database  (not mounted) ,connect sqlplus sys/xxxx@b3dev as sysdba and startup nomount execute then try again
                  • 6. Re: RMAN-06403: could not obtain a fully authorized session
                    Pavan Kumar
                    Hi,

                    Does both Db's reside on same server.. ??
                    RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available
                    If you check error it's coming when RMAN connecting to your auxillary instance, try to check once again.

                    - Pavan Kumar N
                    • 7. Re: RMAN-06403: could not obtain a fully authorized session
                      Yoav
                      Hi,

                      Thanks for your feedback.
                      I tried to restart the aux. instance , as you suggested:
                      SQL> startup nomount
                      ORA-01081: cannot start already-running ORACLE - shut it down first
                      As you can see its already started

                      Thanks
                      • 8. Re: RMAN-06403: could not obtain a fully authorized session
                        mrak2
                        hi,

                        shutdown your aux instance.
                        startup nomount,

                        login via sqlplus :

                        try to : select * from v$database;
                        ->should have result as "ORA-01507: database not mounted"

                        so your database in not mounted now ;)

                        br,
                        mrak
                        • 9. Re: RMAN-06403: could not obtain a fully authorized session
                          Yoav
                          Hi,

                          From MetaLink note : Performing duplicate database with ASM/OMF/RMAN [ID 340848.1]
                          3) Start auxiliary instance in nomount mode. The auxiliary instance
                              should have access to the backups and archivelogs created by target 
                              database in order for duplicate to succeed
                          So , setting the auxiliary instance in NOMOUNT is action i should take.

                          Thanks
                          • 10. Re: RMAN-06403: could not obtain a fully authorized session
                            Chinar
                            Post there result of
                            sqlplus sys/xxxx@b3dev as sysdba
                            select status from v$instance;
                            • 11. Re: RMAN-06403: could not obtain a fully authorized session
                              Yoav
                              Hi,

                              SQL> select status from v$instance;

                              STATUS
                              ------------
                              STARTED

                              Thanks
                              • 12. Re: RMAN-06403: could not obtain a fully authorized session
                                Chinar
                                If auxiliary instance is started then you could not be get ORA-01034: ORACLE not available .There rests one thinks,check ORACLE_HOME and ORACLE_SID variable correctly before starting auxiliary instance and before executing your duplicate script.