Thursday, March 15, 2018

RMAN-04006: error from auxiliary database: ORA-12514

Error:

Got error while creating DUPLICATE TARGET DATABASE from auxiliary after create spfile from memory

sql statement: create spfile from memory

Oracle instance shut down

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/13/2018 13:08:27
RMAN-05501: aborting duplication of target 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.

Solution:

Create separate listener for RMAN duplication in Target,Update the Tnsnames.ora and try.

Create a static entry in listener configuration for auxiliary database.

RMAN-04006 And ORA-12514 During RMAN Duplicate [ID 883490.1]
Connection to Auxilary using connect string failed with ORA-12528 [ID 419440.1]
How to resolve ORA-16792 [ID 966472.1]

No comments:

Post a Comment