OraFAQ Forum: Server Administration » TNS:listener failed to start a dedicated server process

Home » RDBMS Server » Server Administration » TNS:listener failed to start a dedicated server process

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

TNS:listener failed to start a dedicated server process [message #242436]

Sat, 02 June 2007 01:48

chara
Messages: 81
Registered: April 2005
Location: th

Member

Dear all,

I ran oracle9i db server on windows2003 r2 and got the error as be low :

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
What happend?Pls suggest me.
Thanks for advance.

Chara

Report message to a moderator

Re: TNS:listener failed to start a dedicated server process [message #242437 is a reply to message #242436]

Sat, 02 June 2007 01:59

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

ORA-12500: TNS:listener failed to start a dedicated server process

For Above error there is couple of reason check below point.

1.Oracle Services is start.
Windows > c:\>net start OracleService
Unix > $ps -ef | grep ora_smon

2.Listener Services is start.

3.Take a look on LISTENER.LOG file {%ORACLE_HOME%/network/log}

4.if you received WINEXEC FORMAT ERROR 8

C:\>net helpmsg 8

Not enough storage is available to process this command.
Contact OS vendor for more information.

5.Sometimes it is happen due to PGA RAM shortage on database.
You have to set below parameters.
pga_aggregate_target, sort_area_size and hash_area_size.

6.TNS-00517: Lost contact
32-bit Windows Error: 54: Unknown error
If your received above error
C:\>net helpmsg 54

The network is busy.

7.TNS-00507: Connection closed
32-bit Windows Error: 109: Unknown error

C:\>net helpmsg 109

The pipe has been ended.

8.Recreate OracleService service through ORADIM utility

ORADIM -DELETE -SID
ORADIM -NEW -SID

Report message to a moderator

Re: TNS:listener failed to start a dedicated server process [message #242483 is a reply to message #242437]

Sat, 02 June 2007 11:57

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

Chara, As Taj suggested ... kindly check that and also check this also
32-bit Windows Error: 2: No such file or directory

Check your file or directory also......

Report message to a moderator

Previous Topic:	monitoring alert log
Next Topic:	doubt on tablespaces

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 14:24:32 CDT 2025