I am using Oracle 18.104.22.168 on Solaris 8. Database is running in Shared Server mode.
Sometimes "lsnrctl services" shows refused connections = 40. Users are not able to connect to DB for a while. If re-tried then works fine.
Why is it happening? Whats wrong with the setting.
I've posted my "init.ora" & "listener.ora" files in my earlier postings with subject "ORA-1003 & 12518" for your reference.
I would suggest a look at this page http://download-west.oracle.com/docs...ures.htm#22666
it has info on tuning the number of dispatchers you are setting up to handle user connections. One thing to note as they mention in the docs, simply adding more dispatchers is not always the best answer... pay close attention to the POOL and MULTIPLEX options too.
Instance "db01", status READY, has 2 handler(s) for this service...
"D001" established:1279 refused:9 current:84 max:972 state:ready
DISPATCHER <machine: sol8srv01, pid: 5689>
"DEDICATED" established:914 refused:0 state:ready
This shows refused = 9 now.
Please advice me how to read the listener.trc. What is wrong over here?