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: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:
and then issue a startup command? Why do I have to execute:
conn sys@DEV01 AS sysdba
net start OracleServiceDEV01