Re: Oracle at Windows startup

From: <akkha1234_at_gmail.com>
Date: 5 Oct 2006 09:08:15 -0700
Message-ID: <1160064494.950183.65390@e3g2000cwe.googlegroups.com>

Maybe it is something relatively simple. In order for your oracle to be started on starting windows, you need:

1. set the oracle service to automatic
2. bring up your registry, look at ORA_YOURSID_autostart, set it to TRUE.

Alternatively, you can do following:

net stop oracleserviceYOURSID
D:\ORACLE\ora920\bin\oradim -delete -sid YOURSID del ORACLE_HOME\database\pwdtest.ora /Q

ORACLE_HOME\bin\oradim -new -sid YOURSID -intpwd SYSPASSWORD -startmode a -pfile "ORACLE_BASE\YOURSID\pfile\initYOURSID.ora"

This will delete your original service and recreate one with the correct setup.
Check ORACLE_HOME\database\oradim.log for any error Received on Thu Oct 05 2006 - 11:08:15 CDT