Home » RDBMS Server » Networking and Gateways » TNS Error for seconds occasionally through out day (9208 on Win)
TNS Error for seconds occasionally through out day [message #288412] Mon, 17 December 2007 08:14 Go to next message
oraclestew
Messages: 13
Registered: December 2007
Location: Warrington, UK
Junior Member
I keep getting the following error in my listener log. It seems to occur for several seconds periodically throughout the day, then reconnects ok with no interferance from anyone. Any ideas?

TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directory
Re: TNS Error for seconds occasionally through out day [message #288415 is a reply to message #288412] Mon, 17 December 2007 08:23 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>TNS-12500: TNS:listener failed to start a dedicated server >process
Check your proceses parameter value.
sql>SHOW PARAMETER PROCESSES

Increase processes parameter value and check.
NOTE: after update processes parameter you have to bounce (restart) oracle database.

Re: TNS Error for seconds occasionally through out day [message #288417 is a reply to message #288415] Mon, 17 December 2007 08:28 Go to previous messageGo to next message
oraclestew
Messages: 13
Registered: December 2007
Location: Warrington, UK
Junior Member
SQL> show parameter processes;

NAME TYPE VALUE
------------------------------------ ----------- ----------
aq_tm_processes integer 2
db_writer_processes integer 6
job_queue_processes integer 30
log_archive_max_processes integer 1
processes integer 750

How much should i increase it by, make it up to 1000?
Re: TNS Error for seconds occasionally through out day [message #288421 is a reply to message #288412] Mon, 17 December 2007 08:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It could also be your server does not have memory enough (above all if you are on Windows).

Regards
Michel
Re: TNS Error for seconds occasionally through out day [message #288425 is a reply to message #288417] Mon, 17 December 2007 08:42 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>How much should i increase it by, make it up to 1000?
Try with 1000 and check.
Re: TNS Error for seconds occasionally through out day [message #288428 is a reply to message #288421] Mon, 17 December 2007 08:47 Go to previous messageGo to next message
oraclestew
Messages: 13
Registered: December 2007
Location: Warrington, UK
Junior Member
Thanks Michel. My server has 8GB of physical memory, i have a 1.5GB SGA and a 512mb PGA. The memory doesn't appear to be a problem, but i could increase the SGA and the processes value. Which one would you suggest i do first or will one have a knock-on effcet to the other?
Re: TNS Error for seconds occasionally through out day [message #288432 is a reply to message #288428] Mon, 17 December 2007 08:56 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't have any memory message from Windows (either pop-up or in event manager) then first increase processes value.

Regards
Michel
Previous Topic: Domain name adds to every new entry in tnsname.ora
Next Topic: Invalid Number error from gateway
Goto Forum:
  


Current Time: Fri Dec 09 03:42:06 CST 2016

Total time taken to generate the page: 0.10003 seconds