connect to the DB using descriptor
Below is what I used to connect to the DB
SQL>connect system/blah@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1521))(ADDRESS=(PROTOCOL= TCP)(HOST=server2)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=test.world)))
standby running on server1 and primary running on server2, service_name ONLY running on Primary instance. when I query to find out what server it connected, found out it connected to server1.
1) it looked like it connected to whatever the first entry on the descriptor. b/c I tried to switch the server2 to go first it will connect to server2
2) why it connected to standby instance? Standby instance doesn't have the service running so it shouldn't connect to standby. It should only connect to the instance which has the service running. I don't understand.......