| 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
|
|
|
|
|
|
| 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
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)))
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
