Hello all,
We just did a fresh install of oracle 11.2.0.3 on RHEL6. This is a 2 node RAC.
Below is my tns entry on my local machine/laptop...
TESTDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan-test)(PORT = 1527))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TESTDB)
)
)
Now when i try to connect using above tns, it always takes me to node2. I have tried like quite a few times.
The above is my db name and service name is the default.
Wierd part is when i create a NEW service and use that as my service name, it dose the load balancing part.
connects me to node1 first then node2, then node1, then node1, then node2 ......
I understand we should create a seperate service to use with RAC and should not use the DEFAULT service name.
But i want to figure out why this is happening with my default service...
Here is my info about DB and listener... scan listener2 and 3 are running on node1 and scan listener1 is running on node2
both nodes are pretty idle as we only have a dummy DB on it and nothing else running.
The local listener(LISTENER) have the local instance (testdb1 and asm1) registred with status of ready,
same with node2
the scan listner have TESTDB service with 2 instance registred(testedb1, testdb2)...
--node1
SQL> show parameter listener%;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=110.20.10.77)(PORT=1521))))
remote_listener string scan-test:1527
SQL>
--node2
SQL> show parameter listener%;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=110.20.10.78)(PORT=1521))))
remote_listener string scan-test:1527
SQL>
here are all my resources
NAME TARGET STATE SERVER STATE_DETAILS
------------------------- ---------- ---------- ------------ ------------------
ora.DATA.dg ONLINE ONLINE node1
ora.DATA.dg ONLINE ONLINE node2
ora.FLASH.dg ONLINE ONLINE node1
ora.FLASH.dg ONLINE ONLINE node2
ora.LISTENER.lsnr ONLINE ONLINE node1
ora.LISTENER.lsnr ONLINE ONLINE node2
ora.OCR_VOTE.dg ONLINE ONLINE node1
ora.OCR_VOTE.dg ONLINE ONLINE node2
ora.asm ONLINE ONLINE node1 Started
ora.asm ONLINE ONLINE node2 Started
ora.gsd OFFLINE OFFLINE node1
ora.gsd OFFLINE OFFLINE node2
ora.net1.network ONLINE ONLINE node1
ora.net1.network ONLINE ONLINE node2
ora.ons ONLINE ONLINE node1
ora.ons ONLINE ONLINE node2
ora.LISTENER_SCAN1.lsnr ONLINE ONLINE node2
ora.LISTENER_SCAN2.lsnr ONLINE ONLINE node1
ora.LISTENER_SCAN3.lsnr ONLINE ONLINE node1
ora.testdb.db ONLINE ONLINE node1 Open
ora.testdb.db ONLINE ONLINE node2 Open
ora.cvu ONLINE ONLINE node1
ora.oc4j ONLINE ONLINE node1
ora.scan1.vip ONLINE ONLINE node2
ora.scan2.vip ONLINE ONLINE node1
ora.scan3.vip ONLINE ONLINE node1
ora.node1.vip ONLINE ONLINE node1
ora.node2.vip ONLINE ONLINE node2
i would like to understand why i always connect to node2 when using the default service name?