981553 wrote:Naming two different databases the same is a very foolish thing to do. I'd correct that if I could. Nevertheless, assuming that 'rmandb' and 'test8' are the names of two different servers, your tnsnames would look like this
my catalog database SID is PROD @ rmandb
and target database SID is PROD @ test8
how would I configure the tnsnames and connect to database inorder to register the catalog
rman target sys/sys@PROD rcvcat rman/rman@PROD
Checking through tnsping on RMANDB
TNS Ping Utility for IBM/AIX RISC System/6000: Version 18.104.22.168.0 - Production on 24-FEB-2013 21:32:33
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=rmandb)(PORT=1524)) (CONNECT_DATA=(SID=PROD)))
OK (0 msec)
1. is it necessary to have different SIDs ?
2. DBID for both Database is different.
And your connect string would be
prod_rmandb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rmandb)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = prod) ) ) prod_tes8 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = test8)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = prod) ) )
rman target sys/sys@prod_test8 rcvcat rman/rman@prod_rmandb