Thursday, 1 August 2019

RMAN-06174: not connected to auxiliary database

When duplicating from an active database I was getting this error:

sql statement: alter system set  db_name =  ''TESTDB2'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

released channel: disk1

released channel: disk2
released channel: disk3
released channel: disk4
released channel: disk5
released channel: disk6
released channel: disk7
released channel: disk8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/01/2019 14:24:24
RMAN-06174: not connected to auxiliary database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

The new instance was not properly registered with the listener on the destination server.
Registering the destination instance statically with the listener [on the destination server] has fixed the issue:

In the destination/target server Add the lines in green color to the listener.ora file with the right destination/target instance name:
      (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521))


    (SID_DESC =
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)

Then reload the listener: [On the Target/Destination Server]
# lsnrctl reload

No comments:

Post a Comment