Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

end users connecting to one node only !!

userR12Oct 27 2010 — edited Oct 27 2010

Hi,

I am new to RAC. My environment: 10gAS (two nodes), 11gr2 RAC (2 nodes), on solaris10. I see all end users connecting to one node only. where other node is fine.

SQL> select a.inst_id,instance_name,program from gv$INSTANCE a, gv$session b where a.inst_id=b.inst_id and
2 username like 'HRAPPS';

INST_ID INSTANCE_NAME PROGRAM
---------- ---------------- -------------------------------
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode2 (TNS V1-V3)
1 mod11g1 frmweb@asnode2 (TNS V1-V3)
1 mod11g1 frmweb@asnode2 (TNS V1-V3)
1 mod11g1 java@asnode2 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode2 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode2 (TNS V1-V3)
1 mod11g1 frmweb@asnode2 (TNS V1-V3)
1 mod11g1 frmweb@asnode2 (TNS V1-V3)
1 mod11g1 frmweb@asnode2 (TNS V1-V3)
1 mod11g1 frmweb@asnode2 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
1 mod11g1 frmweb@asnode1 (TNS V1-V3)
.......

tnsnames.ora on two application server nodes

CONNDB11 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racdb1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = racdb2-vip)(PORT = 1521))
(LOAD_BALANCE = OFF)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mod11g)
)
)

grid@*racdb1* $ crs_stat -t

Name Type Target State Host
-----------------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE racdb1
ora.FRA.dg ora....up.type ONLINE ONLINE racdb1
ora....ER.lsnr ora....er.type ONLINE ONLINE racdb1
ora....N1.lsnr ora....er.type ONLINE ONLINE racdb2
ora....N2.lsnr ora....er.type ONLINE ONLINE racdb1
ora....N3.lsnr ora....er.type ONLINE ONLINE racdb1
ora.asm ora.asm.type ONLINE ONLINE racdb1
ora.eons ora.eons.type ONLINE ONLINE racdb1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora.mod11g.db ora....se.type ONLINE ONLINE racdb2
ora....network ora....rk.type ONLINE ONLINE racdb1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE racdb1
ora....SM1.asm application ONLINE ONLINE racdb1
ora....B1.lsnr application ONLINE ONLINE racdb1
ora.racdb1.gsd application OFFLINE OFFLINE
ora.racdb1.ons application ONLINE ONLINE racdb1
ora.racdb1.vip ora....t1.type ONLINE ONLINE racdb1
ora....SM2.asm application ONLINE ONLINE racdb2
ora....B2.lsnr application ONLINE ONLINE racdb2
ora.racdb2.gsd application OFFLINE OFFLINE
ora.racdb2.ons application ONLINE ONLINE racdb2
ora.racdb2.vip ora....t1.type ONLINE ONLINE racdb2
ora.scan1.vip ora....ip.type ONLINE ONLINE racdb2
ora.scan2.vip ora....ip.type ONLINE ONLINE racdb1
ora.scan3.vip ora....ip.type ONLINE ONLINE racdb1

grid@*racdb2* $ crs_stat -t

Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE racdb1
ora.FRA.dg ora....up.type ONLINE ONLINE racdb1
ora....ER.lsnr ora....er.type ONLINE ONLINE racdb1
ora....N1.lsnr ora....er.type ONLINE ONLINE racdb2
ora....N2.lsnr ora....er.type ONLINE ONLINE racdb1
ora....N3.lsnr ora....er.type ONLINE ONLINE racdb1
ora.asm ora.asm.type ONLINE ONLINE racdb1
ora.eons ora.eons.type ONLINE ONLINE racdb1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora.mod11g.db ora....se.type ONLINE ONLINE racdb2
ora....network ora....rk.type ONLINE ONLINE racdb1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE racdb1
ora....SM1.asm application ONLINE ONLINE racdb1
ora....B1.lsnr application ONLINE ONLINE racdb1
ora.racdb1.gsd application OFFLINE OFFLINE
ora.racdb1.ons application ONLINE ONLINE racdb1
ora.racdb1.vip ora....t1.type ONLINE ONLINE racdb1
ora....SM2.asm application ONLINE ONLINE racdb2
ora....B2.lsnr application ONLINE ONLINE racdb2
ora.racdb2.gsd application OFFLINE OFFLINE
ora.racdb2.ons application ONLINE ONLINE racdb2
ora.racdb2.vip ora....t1.type ONLINE ONLINE racdb2
ora.scan1.vip ora....ip.type ONLINE ONLINE racdb2
ora.scan2.vip ora....ip.type ONLINE ONLINE racdb1
ora.scan3.vip ora....ip.type ONLINE ONLINE racdb1

please advise,,,,
thanks

This post has been answered by Billy Verreynne on Oct 27 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 24 2010

Added on Oct 27 2010

#performance-availability, #real-application-clusters

10 comments

1,017 views