-
connect to the DB using descriptor
Hi all,
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)))
SQL> connected
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.......
thx
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|