11.2.0.2.0. 2 node rac. OEL
RAC services.
My issue is with a service running on node 1.
have an application build in devart, Pointed directly at 1 of my SCAN addresses so I know which node its coming to.
connection comes in fine, but 2-3 times a day, for no reason we can find yet, the connection from client (several of them with same issue) times out. restart app and works fine.
Ive found that the SCAN address that its coming on has an entry in the SCAN listener log on the node where the service lives, but not the local listener.
For example,
listener_Scan2.log
08:25:01 > entry
08:27:03 > entry
08:28:38 > entry
but in the local listener log I only have
08:25:01 > entry
08:28:38 > entry
The 8:27:03 connection attempt coincides with the timeout on the app.
Firewall logs show same behaviour, for the good entries, connection coming and handing off and coming back out, for the bad connection, connection comes in but doesnt go back out.
Anyone got any experience of the SCAN listener not handing off a connection to local listener?