Cannot connect to auxiliary instance
501899Jun 14 2007 — edited Nov 2 2009Hi All,
I am trying to duplicate a db(oracle 9i) using rman. I read the oracle document about "Duplicating a Database with Recovery Manager", but got stuck in the step of "Ensure Oracle Net Connectivity to the Auxiliary Instance". I created an entry in tnsnames with netmgr and added the database name to the listener, then use sqllus to connect to auxiliary instance but it said "ora-12523:TNS:listener could not find instance appropriate for the client connection". I also, tried the following rman command: rman target sys/password@orc9i auxiliary sys/password@dupdb and it came out with the same error(RMAN-04006:error from auxiliary database: ora-12523:TNS:listener could not find instance appropriate for the client connection). Any ideas on what went wrong?. Thanks in advance.