OraFAQ Forum: Networking and Gateways » "ORA-12500 TNS:Listerner failed to start the dedicated server process"

Home » RDBMS Server » Networking and Gateways » "ORA-12500 TNS:Listerner failed to start the dedicated server process"

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

"ORA-12500 TNS:Listerner failed to start the dedicated server process" [message #188583]

Sun, 20 August 2006 04:06

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 1677 times)

Report message to a moderator

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

Frank Naude
Messages: 4581
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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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 1802 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

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

Report message to a moderator

Previous Topic:	ODBC periodic disconnect from portable tablet PC
Next Topic:	Accessing Oracle Database behing Firewall via DB-link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 10:40:35 CST 2024