11gR2 RAC SCAN Slow Connection
Hi,
I am using SCAN listener for on my 2-node RAC (11gR2). The connection is unstable, meaning
1. Sometimes it's quick and sometimes it's very slow (30 seconds).
2. Sometimes it gives ORA-12520: TNS:listener could not find available handler for requested type of server
3. On EM it shows 3 scan listeners up and downs every several minutes.
4. I tried using vip address but still slow.
Any idea how to fix it?
Thanks,
Sha
1. Sometimes it's quick and sometimes it's very slow (30 seconds).
2. Sometimes it gives ORA-12520: TNS:listener could not find available handler for requested type of server
3. On EM it shows 3 scan listeners up and downs every several minutes.
4. I tried using vip address but still slow.
Any idea how to fix it?
Thanks,
Sha
0