Hi Folks,
I have had situations when the oracle listener just hangs intermitently on the server (AIX 4.3.3) and the only solution is to abort the db and reboot the box. No ORA-error messages produced which is rather odd. The question here is - is there a bug in AIX 4.3.3?
Does anyone ever experience this case and if so any idea why?
We have approx 80 concurrent users logged on daily (that is the max number), all from all sorts of front end applications such as web based application, application via sql server, access, excel and so on.
The number of processes on parameter file is 300 and the max no of processes per user on AIX is 256 and the max number of maxuproc requests is 16384.
It is difficult to pinpoint the cause of the listener problem and I am finding it difficult how to marry the number of processes on both oracle and AIX server.
Any feedbacks would be greatly appreciated.
Thanking you all in advance.
Regards
Katherine
I have had situations when the oracle listener just hangs intermitently on the server (AIX 4.3.3) and the only solution is to abort the db and reboot the box. No ORA-error messages produced which is rather odd. The question here is - is there a bug in AIX 4.3.3?
Does anyone ever experience this case and if so any idea why?
We have approx 80 concurrent users logged on daily (that is the max number), all from all sorts of front end applications such as web based application, application via sql server, access, excel and so on.
The number of processes on parameter file is 300 and the max no of processes per user on AIX is 256 and the max number of maxuproc requests is 16384.
It is difficult to pinpoint the cause of the listener problem and I am finding it difficult how to marry the number of processes on both oracle and AIX server.
Any feedbacks would be greatly appreciated.
Thanking you all in advance.
Regards
Katherine