OraFAQ Forum: Networking and Gateways » TNS Error for seconds occasionally through out day

Home » RDBMS Server » Networking and Gateways » TNS Error for seconds occasionally through out day (9208 on Win)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS Error for seconds occasionally through out day [message #288412]

Mon, 17 December 2007 08:14

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

Report message to a moderator

Re: TNS Error for seconds occasionally through out day [message #288415 is a reply to message #288412]

Mon, 17 December 2007 08:23

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.

Report message to a moderator

Re: TNS Error for seconds occasionally through out day [message #288417 is a reply to message #288415]

Mon, 17 December 2007 08:28

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?

Report message to a moderator

Re: TNS Error for seconds occasionally through out day [message #288421 is a reply to message #288412]

Mon, 17 December 2007 08:39

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It could also be your server does not have memory enough (above all if you are on Windows).

Regards
Michel

Report message to a moderator

Re: TNS Error for seconds occasionally through out day [message #288425 is a reply to message #288417]

Mon, 17 December 2007 08:42

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.

Report message to a moderator

Re: TNS Error for seconds occasionally through out day [message #288428 is a reply to message #288421]

Mon, 17 December 2007 08:47

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?

Report message to a moderator

Re: TNS Error for seconds occasionally through out day [message #288432 is a reply to message #288428]

Mon, 17 December 2007 08:56

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 02:13:41 CDT 2025