OraFAQ Forum: RAC & Failsafe » user session are not created on both nodes

Home » Server Options » RAC & Failsafe » user session are not created on both nodes (oracle 11 g r2 RAC of 2 nodes, solaris 10 with ASM)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

user session are not created on both nodes [message #683239]

Fri, 18 December 2020 07:42

janakors
Messages: 232
Registered: September 2009

Senior Member

Hi,
i have found zero sessions on one node of my 2 node RAC while other node have user session on it (70 at an average). in connection string of application we didnt use SCAN rather they are 2 x normal ips of both machines. the alert log doesn't say anything about it. the issue started some months ago but i couldn't find any help for it. earlier everything was ok and both nodes were having user sessions but now only one node has sessions. listeners are ok . what else i should check pl guide

Regards

Report message to a moderator

Re: user session are not created on both nodes [message #683241 is a reply to message #683239]

Fri, 18 December 2020 08:07

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

What is the connection string being used?

Report message to a moderator

Re: user session are not created on both nodes [message #683242 is a reply to message #683241]

Fri, 18 December 2020 08:19

janakors
Messages: 232
Registered: September 2009

Senior Member

the connection string AT application side(Websphere) is as

Code: [Select all] [Show/ hide]

jdbc:oracle:thin:@(Description=(ADDRESS_LIST=(Addres=(PROTOCOL=TCP)(HOST=10.X.X.31)PORT=1521))(Addres=(PROTOCOL=TCP)(HOST=10.X.X.32)PORT=1521)))CONNECT_DATA=(SERVICE_NAME=SERVCIE.KOT.TK)))

regards

Report message to a moderator

Re: user session are not created on both nodes [message #683249 is a reply to message #683242]

Fri, 18 December 2020 11:00

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

That is not the connect string you are using. It has spelling mistakes and wrong parantheses.

[Updated on: Fri, 18 December 2020 11:01]

Report message to a moderator

Re: user session are not created on both nodes [message #683253 is a reply to message #683249]

Sat, 19 December 2020 04:58

janakors
Messages: 232
Registered: September 2009

Senior Member

I have typed it as I don't have a download facility from the server/system. please ignore the typing mistake

I think its enough for you to take the idea of the connection string i am using. please reply

Report message to a moderator

Re: user session are not created on both nodes [message #683256 is a reply to message #683253]

Sat, 19 December 2020 08:59

John Watson
Messages: 8974
Registered: January 2010
Location: Global Village

Senior Member

You never had load balancing with that. You need to add (load_balance=on)(failover=on). Or use the SCAN, as you are meant to do since release 11.2.

Report message to a moderator

Previous Topic:	Oracle RAC error (2 merged)
Next Topic:	ORA-29701: unable to connect to Cluster Synchronization Service

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 12:53:38 CDT 2025