To start a new service on Windows, Oracle provides a command-line utility, ORADIM. It can also be used to remove, edit and stop a service.
Create:
C:oracleproduct10.1.0db_2>oradim -new -sid %ORACLE_SID% -intpwd password -startmode A
Instance created.
Startup:
C:oracleproduct10.1.0db_2>oradim –startup –sid %ORACLE_SID%
Shutdown:
C:oracleproduct10.1.0db_2>oradim –shutdown –sid %ORACLE_SID%
Delete:
C:oracleproduct10.1.0db_2>oradim –delete –sid %ORACLE_SID%
- startup – Indicates that the specified instance should be started.
- shutdown – Indicates that the specified instance should be shutdown.
- sid – The SID of the database to start.
- intpwd – The password for the database user.
- startmode – It could be A(utomatic) or M(anual), this refers to whether or not starting the service automatically opens the database.
To verify whether the service is created or not, check Windows services by typing services.msc into the console. A service named OracleServiceDBName (DBName = %ORACLE_SID%) will be found.
Oracle also created a password file under %ORACLE_HOME%database.
C:oracleproduct10.1.0db_2databasePWDDBName.ORA
Registry Settings:
Check registry editor by typing regedit into the console.
HKLMSoftwareOracleKey_<Oracle Home Name>ORA<SID>_AUTOSTART
Start the database when the service starts
HKLMSoftwareOracleKey_<Oracle Home Name>ORA<SID>_PFILE
Location of the Configuration File
HKLMSoftwareOracleKey_<Oracle Home Name>ORA<SID>_SHUTDOWN
Shutdown the database when the service stops
HKLMSoftwareOracleKey_<Oracle Home Name>ORA<SID>_SHUTDOWNTYPE
Type of shutdown to do when stopping the server