Hi All,
I have 1 RAC database called CPROD with 2 instances called CPROD1 and CPROD2.
the tnsnames.ora node 1 is:
CPRD1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.15.21)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CPRD1)
)
)
node 2 is:
CPRD2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.15.22)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CPRD2)
)
)
If I create another RAC database with different IPs, but with the same name called CPROD, and two instances CPROD1 and CPROD2, how can I change the names in the tnsnames.ora and listener.ora?
I created a tnsnames.ora with a different name
Node 1:
DPRD1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.0.15.31)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CPRD1)
)
)
but got error when connecting in s:qlplus remotely
conn system@DPRD1
ORA-12154: TNS
What am I doing wrong? Can someone help me to solve this issue?
Thanks
KZ