| 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
|
|
|
|
|
|
| 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?
|
|
|
|
|
|
|
|
| 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?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
