Home » RDBMS Server » Server Administration » TNS:listener failed to start a dedicated server process
TNS:listener failed to start a dedicated server process [message #242436] Sat, 02 June 2007 01:48 Go to next message
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
Re: TNS:listener failed to start a dedicated server process [message #242437 is a reply to message #242436] Sat, 02 June 2007 01:59 Go to previous messageGo to next message
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


Re: TNS:listener failed to start a dedicated server process [message #242483 is a reply to message #242437] Sat, 02 June 2007 11:57 Go to previous message
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......
Previous Topic: monitoring alert log
Next Topic: doubt on tablespaces
Goto Forum:
  


Current Time: Wed Dec 07 05:14:12 CST 2016

Total time taken to generate the page: 0.13512 seconds