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
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
Previous Topic: Accessing Older Version DB from New Version
Next Topic: Oracle Error
Goto Forum:
  


Current Time: Fri Dec 09 10:01:38 CST 2016

Total time taken to generate the page: 0.09716 seconds