Home » RDBMS Server » Networking and Gateways » Urgent:TNS-00530 :Protocol adapter error
Urgent:TNS-00530 :Protocol adapter error [message #66128] Wed, 05 December 2001 23:26 Go to next message
Messages: 86
Registered: August 2000
i have a Windows NT 4.0 server with oracle 8.0.3 version for Windows NT
> 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
> Also the no. of oracle process is set to 400 and connections 600 in the
> oranit file.
> 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
> a certain number of connections have been formed, the server does not
> any new connections to be formed. as a result the new users are dropped.
> 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
> new users remains only for a few minutes and then the same users are able
> 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
> 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 NT operating
> we have NT 4.0 with sp4 running on the machine which is PIII 700 mhz xeon
> (twin processors) with 2 MB cache per processor and 512 RAM.
please suugest what can be the problem

Re: Urgent:TNS-00530 :Protocol adapter error [message #66139 is a reply to message #66128] Thu, 13 December 2001 05:17 Go to previous messageGo to next message
Messages: 4
Registered: December 2001
Junior Member
How many users do you have?
You might have reached your max_processes.
Maybe the easy way out is to increase the Oracle processes to something like 800

Re: Urgent:TNS-00530 :Protocol adapter error [message #66165 is a reply to message #66128] Fri, 04 January 2002 20:55 Go to previous message
Messages: 1
Registered: January 2002
Junior Member
I am not able to start listener service on sco machine.i am having oracle 7.3.2.it was working properly,when i restarted the machine and started the database and tried to start listener it is giving the TNS-12560 and TNS-00530 error.
Also the system parameter file it is showing is /etc/listener.ora not $ORACLE_HOME/network/admin.
How to change this.
Your suggestion is solicited.
Thank you
Previous Topic: Re: oracle and d2k installation on the same system
Next Topic: Re: how to configure tnsnames.ora in the server?
Goto Forum:

Current Time: Thu Feb 29 15:43:25 CST 2024