There are 2 options to solve this problem
Option 1
Start rman from Auxiliary environment.
So you can connect to the auxiliary instance using OS authentication (as /) , then you need to use sqlnet connection for target database.
For example make below connection in RMAN from auxiliary database server
E:>rman target sys/sys@original auxiliary /
Recovery Manager: Release 10.2.0.1.0 – Production on Thu Mar 15 23:57:08 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORIGINAL (DBID=1451288337) connected to auxiliary database: DUPLICATE (not mounted)
Option 2
Create a static entry for the auxiliary database in the listener.ora file of the auxiliary database Oracle_home and restart the listener. For example
Listener.ora ————-
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = SAIRAM) (ORACLE_HOME = G:oracleproduct10.2.0db_1) (SID_NAME = SAIRAM) ) )
Or
Use the Oracle10G feature ( specify (UR=A) in connect data ) Make below entry in the tnsnames.ora file of the auxiliary database Oracle_home
tnsnames.ora ————
SAIRAM = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = apadhi-idc)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SAIRAM)(UR=A) ) )
Comments