Home > Windows > Start Oracle service on Windows using ORADIM utility

Start Oracle service on Windows using ORADIM utility

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:\oracle\product\10.1.0\db_2>oradim -new -sid %ORACLE_SID% -intpwd password -startmode A
Instance created.

Startup:

C:\oracle\product\10.1.0\db_2>oradim –startup –sid %ORACLE_SID%

Shutdown:

C:\oracle\product\10.1.0\db_2>oradim –shutdown –sid %ORACLE_SID%

Delete:

C:\oracle\product\10.1.0\db_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:\oracle\product\10.1.0\db_2\database\PWDDBName.ORA

Registry Settings:

Check registry editor by typing regedit into the console.

HKLM\Software\Oracle\Key_<Oracle Home Name>\ORA<SID>_AUTOSTART
Start the database when the service starts

HKLM\Software\Oracle\Key_<Oracle Home Name>\ORA<SID>_PFILE
Location of the Configuration File

HKLM\Software\Oracle\Key_<Oracle Home Name>\ORA<SID>_SHUTDOWN
Shutdown the database when the service stops

HKLM\Software\Oracle\Key_<Oracle Home Name>\ORA<SID>_SHUTDOWNTYPE
Type of shutdown to do when stopping the server

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: