10 Replies Latest reply: Jan 27, 2013 2:30 AM by Osama_Mustafa RSS

    RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not

    987349
      Hello Guys
      I m trying to RMAN DUP from ACTIVE DATABASE
      I get this error whenever i tried to login

      rman target sys/xxxx@targetDB auxiliary sys/xxxx@auxiDB and only when the auxiliary is in NOMOUNT state
      PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.02 in TARGET database is not current
      PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.02 in TARGET database is not current
      connected to target database: ORDPRD10 (DBID=2195531574)
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-00554: initialization of internal recovery manager package failed
      RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
      But when the auxiliary is in OPEN state, I can log without a problem but can't run the RMAN DUPLICATE in open mode.
      /opt/oracle/etc: rman target sys/xxxxx@TARGETDB auxiliary sys/xxxxx@auxiDB
      
      Recovery Manager: Release 11.2.0.3.0 - Production on Sun Jan 27 03:19:18 2013
      
      Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
      
      PL/SQL package SYS.DBMS_BACKUP_RESTORE version 11.02.00.02 in TARGET database is not current
      PL/SQL package SYS.DBMS_RCVMAN version 11.02.00.02 in TARGET database is not current
      connected to target database: TARGETDB (DBID=2195531574)
      connected to auxiliary database: auxiDB (DBID=2063666840)
      
      RMAN>
      I do have three services on the listener and here is their status
      *LSNRCTL> services LISTENER_auxiDB_1580*
      Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=hostname.net)(PORT=1580)(QUEUESIZE=128))
      Services Summary...
      Service "auxiDB" has 1 instance(s).
        Instance "auxiDB", status UNKNOWN, has 1 handler(s) for this service...
          Handler(s):
            "DEDICATED" established:0 refused:0
               *LOCAL SERVER*
      Service "auxiDB.tname.net" has 1 instance(s).
        Instance "auxiDB", status READY, has 1 handler(s) for this service...
          Handler(s):
            "DEDICATED" established:2 refused:0 state:ready
               *LOCAL SERVER*
      Service "auxiDB.name.net" has 1 instance(s).
        Instance "auxiDB", status READY, has 1 handler(s) for this service...
          Handler(s):
            "DEDICATED" established:2 refused:0 state:ready
               *LOCAL SERVER*
      Service "auxiDBXDB.name.net" has 1 instance(s).
        Instance "auxiDB", status READY, has 1 handler(s) for this service...
          Handler(s):
            "D000" established:0 refused:0 current:0 max:1022 state:ready
               DISPATCHER <machine: hostname.net, pid: 14518>
               (ADDRESS=(PROTOCOL=tcp)(HOST=hostname.net)(PORT=13728))
      The command completed successfully
      *LSNRCTL> services LISTENER_auxiDB_1581*
      Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=hostname.net)(PORT=1581)(QUEUESIZE=128))
      Services Summary...
      Service "auxiDB.tname.net" has 1 instance(s).
        Instance "auxiDB", status READY, has 1 handler(s) for this service...
          Handler(s):
            "DEDICATED" established:1 refused:0 state:ready
               *LOCAL SERVER*
      Service "auxiDB.name.net" has 1 instance(s).
        Instance "auxiDB", status READY, has 1 handler(s) for this service...
          Handler(s):
            "DEDICATED" established:1 refused:0 state:ready
               LOCAL SERVER
      Service "auxiDBXDB.name.net" has 1 instance(s).
        Instance "auxiDB", status READY, has 1 handler(s) for this service...
          Handler(s):
            "D000" established:0 refused:0 current:0 max:1022 state:ready
               DISPATCHER <machine: hostname.net, pid: 14518>
               (ADDRESS=(PROTOCOL=tcp)(HOST=hostname.net)(PORT=13728))
      The command completed successfully
      *LSNRCTL> services LISTENER_auxiDB_1582*
      Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=hostname.net)(PORT=1582)(QUEUESIZE=128))
      Services Summary...
      Service "auxiDB.tname.net" has 1 instance(s).
        Instance "auxiDB", status READY, has 1 handler(s) for this service...
          Handler(s):
            "DEDICATED" established:3 refused:0 state:ready
               LOCAL SERVER
      Service "auxiDB.name.net" has 1 instance(s).
        Instance "auxiDB", status READY, has 1 handler(s) for this service...
          Handler(s):
            "DEDICATED" established:3 refused:0 state:ready
               *LOCAL SERVER*
      Service "auxiDBXDB.name.net" has 1 instance(s).
        Instance "auxiDB", status READY, has 1 handler(s) for this service...
          Handler(s):
            "D000" established:0 refused:0 current:0 max:1022 state:ready
               DISPATCHER <machine: hostname.net, pid: 14518>
               (ADDRESS=(PROTOCOL=tcp)(HOST=hostname.net)(PORT=13728))
      The command completed successfully
      HERE is my listener config
      LISTENER_auxiDB_1581=
              (ADDRESS_LIST=
                      (ADDRESS =
                              (PROTOCOL = TCP)
                              (HOST = hostname.net)
                              (PORT = 1581)
                              (QUEUESIZE = 128)
                      )
              )
      
      SID_LIST_LISTENER_auxiDB_1581 =
              (SID_LIST =
                      (SID_DESC =
                              (SID_NAME = auxiDB)
                              (ORACLE_HOME = /opt/oracle/product/11.2.0.3/rdbms)
                              (GLOBAL_DBNAME = auxiDB)
                      )
              )
      AND THE TNSNAME.ORA CONFIG
      auxiDB=
        (DESCRIPTION=
        (ADDRESS_LIST=
          (LOAD_BALANCE=ON)
          (FAILOVER=ON)
              (ADDRESS=
                      (PROTOCOL=TCP)
                      (HOST=hostname.net)
                      (PORT=1580))
              (ADDRESS=
                      (PROTOCOL=TCP)
                      (HOST=hostname.net)
                      (PORT=1581))
              (ADDRESS=
                      (PROTOCOL=TCP)
                      (HOST=hostname.net)
                      (PORT=1582)))
              (CONNECT_DATA=
                (SERVER=DEDICATED)
                (SERVICE_NAME=auxiDB.name.net)(UR = A)))
      
      auxiDB_local_listeners =
        (DESCRIPTION =
              (ADDRESS_LIST=
              (PROTOCOL = TCP)
                (ADDRESS=(PROTOCOL=TCP) (HOST=hostname.net) (PORT=1580))
                (ADDRESS=(PROTOCOL=TCP) (HOST=hostname.net) (PORT=1581))
                (ADDRESS=(PROTOCOL=TCP) (HOST=hostname.net) (PORT=1582))
        ))
      I wanted to mention that the TARGET database is on version 11.2.0.2 and the AUXILIARY database is 11.2.0.3

      Please let me know if i need to change something in my settings

      thanks
        • 1. Re: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not
          marksmithusa
          You can't perform a duplicate database between different versions - and I believe that includes the patch set levels. Try duplicating to a 11.2.0.2 and then upgrading that to 11.2.0.3.

          Have you tried performing a 'tnsping' to make sure you can see the aux database from the target?

          Also, you appear to have posted this multiple times...
          • 2. Re: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not
            sb92075
            ORA-12514 ALWAYS only occurs due to a problem on DB Server system.
            One cause of this problem is when the Oracle database is down & needs to be started.
            A remote client send a request to the Listener asking to be connected to a specific service.
            If/when the listener does not know anything about that service, the listener responds with ORA-12514

            post results from the following two OS commands:
            lsnrctl status
            lsnrctl service

            Since every connection request to the listener gets logged, listener.log file will contain a line with 12514 as status code.

            This line contains valuable debugging details. So post this line & surrounding lines.

            for additional debugging suggestions read the URL below:
            http://edstevensdba.wordpress.com/2011/03/19/ora-12514/
            • 3. Re: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not
              987349
              Here is the status of the listener when the db is in nomount mode and i have previously posted the SERVICES status earlier
              LSNRCTL> status LISTENER_auxiDB_1580
              Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=hostname.net)(PORT=1580)(QUEUESIZE=128))
              STATUS of the LISTENER
              ------------------------
              Alias                     LISTENER_auxiDB_1580
              Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
              Start Date                27-JAN-2013 03:59:56
              Uptime                    0 days 0 hr. 49 min. 12 sec
              Trace Level               off
              Security                  ON: Local OS Authentication
              SNMP                      OFF
              Listener Parameter File   /opt/oracle/etc/listener.ora
              Listening Endpoints Summary...
                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname.net)(PORT=1580)))
              Services Summary...
              Service "auxiDB" has 1 instance(s).
                Instance "auxiDB", status UNKNOWN, has 1 handler(s) for this service...
              Service "auxiDB.c020.namews.net" has 1 instance(s).
                Instance "auxiDB", status BLOCKED, has 1 handler(s) for this service...
              The command completed successfully
              LSNRCTL> status LISTENER_auxiDB_1581
              Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=hostname.net)(PORT=1581)(QUEUESIZE=128))
              STATUS of the LISTENER
              ------------------------
              Alias                     LISTENER_auxiDB_1581
              Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
              Start Date                27-JAN-2013 03:59:57
              Uptime                    0 days 0 hr. 49 min. 25 sec
              Trace Level               off
              Security                  ON: Local OS Authentication
              SNMP                      OFF
              Listener Parameter File   /opt/oracle/etc/listener.ora
              Listening Endpoints Summary...
                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname.net)(PORT=1581)))
              Services Summary...
              Service "auxiDB.c020.namews.net" has 1 instance(s).
                Instance "auxiDB", status BLOCKED, has 1 handler(s) for this service...
              The command completed successfully
              LSNRCTL> status LISTENER_auxiDB_1582
              Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=hostname.net)(PORT=1582)(QUEUESIZE=128))
              STATUS of the LISTENER
              ------------------------
              Alias                     LISTENER_auxiDB_1582
              Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
              Start Date                27-JAN-2013 03:59:59
              Uptime                    0 days 0 hr. 49 min. 31 sec
              Trace Level               off
              Security                  ON: Local OS Authentication
              SNMP                      OFF
              Listener Parameter File   /opt/oracle/etc/listener.ora
              Listening Endpoints Summary...
                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname.net)(PORT=1582)))
              Services Summary...
              Service "auxiDB.c020.namews.net" has 1 instance(s).
                Instance "auxiDB", status BLOCKED, has 1 handler(s) for this service...
              The command completed successfully
              Thanks guys
              • 4. Re: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not
                987349
                Mark
                the TNSPING gave me successful results
                /opt/oracle/etc: tnsping auxiDB
                
                TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 27-JAN-2013 04:55:46
                
                Copyright (c) 1997, 2011, Oracle.  All rights reserved.
                
                Used parameter files:
                
                
                Used TNSNAMES adapter to resolve the alias
                Attempting to contact (DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=ON) (FAILOVER=ON) (ADDRESS= (PROTOCOL=TCP) (HOST=hostname) (PORT=1580)) (ADDRESS= (PROTOCOL=TCP) (HOST=hostname) (PORT=1581)) (ADDRESS= (PROTOCOL=TCP) (HOST=hostname) (PORT=1582))) (CONNECT_DATA= (SERVER=DEDICATED) (SID=auxiDB)(UR = A)))
                OK (0 msec)
                    04:55 AM(oracle@server.c010:auxiDB)
                /opt/oracle/etc: tnsping target
                
                TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 27-JAN-2013 04:55:58
                
                Copyright (c) 1997, 2011, Oracle.  All rights reserved.
                
                Used parameter files:
                
                
                Used TNSNAMES adapter to resolve the alias
                Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server.dc2.namecom)(PORT = 1583)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = target_DGMGRL.namecom) (UR = A)))
                OK (10 msec)
                • 5. Re: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not
                  987349
                  So Mark, do you think that the version is the issue???
                  • 6. Re: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not
                    sb92075
                    984346 wrote:
                    So Mark, do you think that the version is the issue???
                    YES!
                    • 7. Re: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not
                      987349
                      Thanks SB

                      I wanted to mention one more thing, the auxiliary db reside on Linux and the target is on Solaris
                      AUXIDB
                      /opt/oracle/etc: uname -a
                      Linux gcdbsys002..net2.6.32-279.14.1.el6.x86_64 #1 SMP Mon Oct 15 13:44:51 EDT 2012 x86_64 x86_64 x86_64 GNU/Linux
                      and here is the TARGETDB
                      TARGETDB
                      /var/opt/oracle: uname -a
                      SunOS dc2db60 5.10 Generic_147441-10 i86pc i386 i86pc
                      QUESTION???
                      It this a problem as well?
                      Please give some recommendations

                      Thanks again guys

                      Edited by: 984346 on Jan 26, 2013 9:24 PM
                      • 9. Re: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not
                        Osama_Mustafa
                        Check MOS notes :
                        RMAN-04006 And ORA-12514 During RMAN Duplicate [ID 883490.1]

                        downgrade the aux database , or update it . should be the same version.
                        • 10. Re: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not
                          AmitGolia
                          RMAN cloning using active database feature can be use in the same platform and same oracle version only.

                          Thanks,
                          Amit Golia