Servive names in Oracle 11g
Hi Experts,
We are going to switch roles of databases in dataguard environment, I mean primary to standby and standby to primary.
But here real problem comes from client.
Our clients want to use same tns file , they don't want to add any entries , I mean they do not want to change hostnames etc.
then we used following approach.
TEST.world=
(DESCRIPTION=
(ADDRESS= (PROTOCOL=TCP) (HOST=prod.com) (PORT=1531))
(ADDRESS= (PROTOCOL=TCP) (HOST=stby.com) (PORT=1531))
(CONNECT_DATA=
(SERVICE_NAME=test)
)
)
Then we created services using srvctl utilty with same name in both primary and standby side.
srvctl add service -d prod -s test