This discussion is archived
10 Replies Latest reply: Jan 27, 2013 12:30 AM by Osama_Mustafa RSS

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

987349 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
  • 8. Re: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Close the duplicate thread
  • 9. Re: RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    RMAN cloning using active database feature can be use in the same platform and same oracle version only.

    Thanks,
    Amit Golia

Legend

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