Home » RDBMS Server » Server Administration » ORA-12500: TNS:listener failed to start a dedicated server process
ORA-12500: TNS:listener failed to start a dedicated server process [message #184204] Tue, 25 July 2006 13:26 Go to next message
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:
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:
sqlplus /nolog
conn sys@DEV01 AS sysdba
and then issue a startup command? Why do I have to execute: 
net start OracleServiceDEV01


Many Thanks

Andy

Report message to a moderator

icon12.gif  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 Go to previous message
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 Mad

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 23:03:32 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.