I'm working on Linux 7.2,Oracle 9i on production box. My users are very frequently getting this error when they are trying to connect from TOAD or SQL*PLUS, or on telnet session. At the same time, at $ prompt, i'm getting core dumped error too. This is my ulimit parameters with their values, please try to help me.
This is from TOAD/SQLPLUS/DBASTUDIO
ERROR:ORA-12500: TNS:listener failed to start a dedicated server process
This is from Telnet/Hyperterminal session:
ERROR: Enter user-name: devlcms
ORA-12547: TNS:lost contact
This is my ulimit
core file size (blocks) 1000000
data seg size (kbytes) unlimited
file size (blocks) unlimited
max locked memory (kbytes) unlimited
max memory size (kbytes) unlimited
open files 1024
pipe size (512 bytes) 8
stack size (kbytes) 8192
cpu time (seconds) unlimited
max user processes 136192
virtual memory (kbytes) unlimited
Please suggest me . Your earliest responce is most appreciated.
Thanks in advance
i think you have a dedicated listener process for the users.In dedicated listener the server process keep on waiting for the user queries even if user is not working.you can change the dedicated mode to shared server mode and start 5 dispatchers initally and max you can set to 10 and as and when necessary you can start more process dynamically.
but we are already running with the similar set up and environment on another machine very smoothly and absolutely fine. is No.of dipatchers=5 is the default value for either a dediacted server or an MTS?? Are there any other parameters need to be set along with this? please let me know.
i think there are no default value for dedeicated server.
In dispatchers parameter there is no default value but oracle recomends that you have atleast 2.i gave you 5 because i think you have very excessive load.
i think you should read "Oracle9i Database Administrator's Guide".
There they have given the shared server configuration.
The ora-12500 & ora-12547 errors may be an indication that the RAM amount may be reaching its limit.
What is the size of your physical RAM, and the sum of the sizes of all instances on that linux box ? Moreover, at peak time what is the memory usage(free also), using top.