DG service name with scan
edited Jun 17, 2013 7:02PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
Hi,
I have a primary standby configuration on 11.2
My service looks like the following.
connect_db =
(DESCRIPTION =
(ENABLE=BROKEN)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =cscan01.te.com)(PORT = 1525))
(ADDRESS = (PROTOCOL = TCP)(HOST =cscan02.te.com)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = connect_db.world)
)
)
cscan01.te.com - Primary scan name
cscan02.te.com - secondary scan name
The above setting works fine and i am able to connect to the primary
But when i change the scan names like the below.
connect_db =
(DESCRIPTION =
(ENABLE=BROKEN)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =cscan02.te.com)(PORT = 1525))
(ADDRESS = (PROTOCOL = TCP)(HOST =cscan01.te.com)(PORT = 1525))
I have a primary standby configuration on 11.2
My service looks like the following.
connect_db =
(DESCRIPTION =
(ENABLE=BROKEN)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =cscan01.te.com)(PORT = 1525))
(ADDRESS = (PROTOCOL = TCP)(HOST =cscan02.te.com)(PORT = 1525))
)
(CONNECT_DATA =
(SERVICE_NAME = connect_db.world)
)
)
cscan01.te.com - Primary scan name
cscan02.te.com - secondary scan name
The above setting works fine and i am able to connect to the primary
But when i change the scan names like the below.
connect_db =
(DESCRIPTION =
(ENABLE=BROKEN)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =cscan02.te.com)(PORT = 1525))
(ADDRESS = (PROTOCOL = TCP)(HOST =cscan01.te.com)(PORT = 1525))
0