Home » RDBMS Server » Networking and Gateways » "ORA-12500 TNS:Listerner failed to start the dedicated server process"
"ORA-12500 TNS:Listerner failed to start the dedicated server process" [message #188583] Sun, 20 August 2006 04:06 Go to next message
chinni_00
Messages: 30
Registered: October 2005
Member
Hi Everyone,

We are Working on a Server with Oracle 8i Database which connects to an application.

Few days back The MaxExtents of a table reached the Maximum(200) so the work was holded up so i have Updated the size and increased the MaxExtents to 300

Then it worked for the next two days including the Restarted day of the server,after that the server is disconnecting the Dispatcher Services every two days and when i try restarting the service it doesnt works so i have to restart the Complete server and the work is scheduled for 24X7 basics so it is holding up the work even on a Holidays so is there any suggestions or Idea regarding this will help me a Lot

I will also post some of the Log files for your reference
Note: Pls rename the file as .zip

Thanks & Regards
Prem
  • Attachment: Log.zap
    (Size: 303.60KB, Downloaded 297 times)
Re: "ORA-12500 TNS:Listerner failed to start the dedicated server process" [message #188626 is a reply to message #188583] Mon, 21 August 2006 01:22 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Error extracted from your log files:

TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12537: TNS:connection closed
  TNS-12560: TNS:protocol adapter error
   TNS-00507: Connection closed
    32-bit Windows Error: 109: Unknown error

Re: "ORA-12500 TNS:Listerner failed to start the dedicated server process" [message #188827 is a reply to message #188626] Mon, 21 August 2006 22:55 Go to previous messageGo to next message
chinni_00
Messages: 30
Registered: October 2005
Member
Hi Frank,

So do you have any idea regarding this error any Suggestions or Ideas realated to it.

As i have clearly explained that the Application cant able to access the Database exactly after two days

So when we restart the Server and then the Services the System starts to work fine

Regards
Prem
Re: "ORA-12500 TNS:Listerner failed to start the dedicated server process" [message #188846 is a reply to message #188827] Tue, 22 August 2006 01:57 Go to previous messageGo to next message
dinu_dba
Messages: 8
Registered: August 2006
Location: Hyderabad
Junior Member

hi prem
i tried to open the log file u hav sent but its not opening ok ..first of all just let me know how many database are there in your server ? i belive more than one right ?
send ur log file to my emailid ok
bye hope we will solve the problem
bye from dinu
Re: "ORA-12500 TNS:Listerner failed to start the dedicated server process" [message #188849 is a reply to message #188846] Tue, 22 August 2006 02:05 Go to previous messageGo to next message
chinni_00
Messages: 30
Registered: October 2005
Member
Hi Dinu,

Download the file to your computer rename the file to .zip

so that u can able to view it

Any how i will also send the attachment to ur mail
Regards
Prem
  • Attachment: Log.zip
    (Size: 303.22KB, Downloaded 370 times)

[Updated on: Tue, 22 August 2006 02:12]

Report message to a moderator

Re: "ORA-12500 TNS:Listerner failed to start the dedicated server process" [message #190896 is a reply to message #188583] Sat, 02 September 2006 00:31 Go to previous message
chinni_00
Messages: 30
Registered: October 2005
Member
Thanks Guys for all your help to rectify the Error occured.

Finally i found the thing which is causing the problem it is just a virus so when i cleared it the Server started to work perfectly so no problems any more

Thanks Again,
Regards
Prem
Previous Topic: ODBC periodic disconnect from portable tablet PC
Next Topic: Accessing Oracle Database behing Firewall via DB-link
Goto Forum:
  


Current Time: Fri Dec 02 14:08:43 CST 2016

Total time taken to generate the page: 0.13479 seconds