TNS Service failed to start a dedicated server process
Posted on 2004-08-22
I have a Windows 2000 server with oracle 9.1 version for Windows NT/2000
Since a fortnight now i have been receiving the following errors in the
listener log file
1. TNS-12500: TNS Service failed to start a dedicated server process
2. TNS-12560: TNS protocol adapter error
3. TNS-00530: Protocol adapter error
Is the problem related to window 2000 server
Also the no. of oracle process is set to 1000 and connections 1000 in the
In the morning when the users begin to login to the oracle server, the
connection is formed and they can work. but as the day progresses, and
after a certain number of connections have been formed, the server does not
allow any new connections to be formed. as a result the new users are dropped.
The ones which connected earlier stay connected and are able to work normally.
The problem occurs only in the case of new connections. the problem with
the new users remains only for a few minutes and then the same users are able
to connect to the same server. The connection used is a dedicated server
process at the default port of 1521. Each and every session uses a
dedicated server process.
Even those users who are only pulling a query from the oracle server (like
salary details) , even they are not able to get their details at times.
Is there any chance that there is some problem with the server 2000 operating
system we have server 2000 with sp3 running on the machine which model xseries 255/8685
processor 1.5ghz*2 Ram 3gb network card 1Gbps(2 nos)
please suugest what can be the problem