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

This error is due to server or it’s particular instance is not started yet. It should be automatics started when windows is started, but some times the PC have not enough resource, so you must do manually. On windows, you can open services.msc (start – run) and try to start it’s instance server, it’s name looks like OracleService%Oracle_SID% or you can use oradim to create a new and start oracle services.

oradim is a tool that can be use to create Oracle windows services, and to start instances. oradim has the option -sid to identifies system identifier. Here some actions using oradim :

1. Create a windows service

   c:\>oradim -new -sid SID_NAME -intpwd PASSWORD -startmode MODE -pfile PFILEse

   use sysdba password, mode shows start preference automatic or manual, if you choose manual then you have to start the service manually, when your windows has been started.

2. Start oracle service, instance or both of them

   c:\path> oradim -startup -sid<sid_name> -starttype srvc

   c:\path> oradim -startup -sid<sid_name> -starttype inst

   c:\path> oradim -startup -sid<sid_name> -starttype srvc,inst

the oradim messages are logged in %ORACLE_HOME%\database\oradim.log.

~ by efuzie on June 2, 2008.