Database Administration (MOSC)

MOSC Banner

RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of servic

edited Jul 1, 2019 10:59AM in Database Administration (MOSC) 22 commentsAnswered

when run rman duplicate from active database, got error as below. Please advice. I followed all required steps such as 1. static Listener, 2.  (UR = A) in tnsname entry.

RMAN> connect auxiliary sys/****@nwamprd

connect target sys/****@wamprod

connected to auxiliary database: NWAMPRD (not mounted)

RMAN>

connected to target database: WAMPROD (DBID=4199108311)

RMAN> DUPLICATE DATABASE TO nwamprd FROM ACTIVE DATABASE;

Starting Duplicate Db at 25-JUN-19

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=254 device type=DISK

current log archived

contents of Memory Script:

{

   sql clone "create spfile from memory";

}

executing Memory Script

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center