The following is from the
bestselling book Oracle Utilities: Using
Hidden Programs, Import/Export, SQL Loader,
oradebug, Dbverify, Tkprof and More today
and receive 30% off plus immediate access to
the Online Code Depot!
Starting and Stopping Oracle on Windows with
The dbstart and dbstop shell scripts do not exist on Windows
platforms. Consequently Oracle database startup and shutdown is
implemented completely differently. The oradim utility provides
more than just the ability to start and stop Windows databases.
Windows oradim can create and edit databases. It also allows DBAs
to configure script-based installation mechanisms.
The oradim utility is used on the Windows
platform to perform these tasks.
C:\oracle9i\bin\oradim -startup -sid ORCL92
-starttype SRVC,INST -pfile
• startup – Indicates that the specified instance should be started.
• sid – The SID of the database to start.
• usrpwd – The password for the database user.
• starttype – Specifies whether to start the instance, the service, or
The following command can be used to shutdown
the instance with oradim:
C:\oracle9i\bin\oradim -shutdown -sid ORCL92
-shutttype SRVC,INST –shutmode A
Notice that no password is needed to perform
The shuttype parameter specifies what is to be
stopped – the service (SRVC), the instance
(INST), or both (SRVC, INST). The shutmode
specifies the method that should perform the
shutdown – (A)bort, (I)mmediate, or (N)ormal.
Each operation, regardless of success, is
logged in the oradim log file.
For a reference of all oradim commands, use
the oradim scripts here.
oradim script download