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

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

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

ORA-12500: TNS:listener failed to start a dedicated server process [message #184204]

Tue, 25 July 2006 13:26

amcghie
Messages: 35
Registered: March 2005
Location: Sunny Dubai

Member

Hello all,

I am running Oracle 9.2 on Windows XP Professional, I usually start the listener and database using the Services dialog box in Control Panel, but today decided to use the command prompt - I know what a krazy kid eh?

I started the listener using:

Code: [Select all] [Show/ hide]

lnsrctl start

command and then attempt to log on to the database using sqlplus as the sys user with sysdba priviliges, however I get the following error message:

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

Why can I not just execute:

Code: [Select all] [Show/ hide]

sqlplus /nolog
conn sys@DEV01 AS sysdba

and then issue a startup command? Why do I have to execute:

Code: [Select all] [Show/ hide]

net start OracleServiceDEV01

Many Thanks

Andy

Report message to a moderator

Re: ORA-12500: TNS:listener failed to start a dedicated server process [message #184266 is a reply to message #184204]

Tue, 25 July 2006 23:05

bravobritto
Messages: 6
Registered: July 2006
Location: Somewhere in India

Junior Member

Memory? Limits?

Post your configuration ( amount of memory, size of SGA, etc...) and metrics. This will help in analyzing your problem.

Regards
Britto

Report message to a moderator

Previous Topic:	Accessing Older Version DB from New Version
Next Topic:	Oracle Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 17 04:08:09 CDT 2025