Oracle ORADIM
Version 11.2.0.3

General Information
Note: ORADIM is a Windows only utility used for the creation, modification and deletion of the Windows Service
Definitions
ASMSID ASM instance name
ASMSRVC <service_name> ASM service name
NEW Indicates that a new instance is being created
PFILE <file_name> Parameter File Path and Name
RUNAS Options are OSUSR and OSPASS
SHUTDOWN Stopping a running instance
SHUTMODE How the Windows Service should shutdown the database. Options are ABORT, NORMAL,  and IMMEDIATE
SHUTTYPE "srvc" is a directive to stop a service "inst" is a directive to stop the instance: Both can be specified
SID Name of the Oracle instance
SPFILE Indicates that a server parameter file (SPFILE) be used during startup instead of a PFILE
SRVC <service_name> Name of the Oracle service
SRVCSTART Options are SYSTEM and DEMAND
STARTMODE Should Windows start the instance when the Database service is started. Options are AUTO and MANUAL
STARTTYPE "srvc" is equivalent to NET START oracleservice<SID> and "inst" is eqivalent to startup with SQL*Plus
STARTUP Start an instance that already exists
SYSPWD <password> System password
TIMEOUT <seconds> Sets the maximum time to wait (in seconds) before the service for a particular SID stops
 
Commands
DROP

Delete instances by specifying options
ORADIM -DELETE -SID sid | -ASMSID sid | -SRVC srvc | -ASMSRVC srvc
$ORACLE_HOME\bin\oradim -DELETE -SID orabase
HELP ORADIM -h
$ORACLE_HOME\bin\oradim -?

$ORACLE_HOME\bin\oradim -h

$ORACLE_HOME\bin\oradim -help
MODIFY

Edit an instance by specifying the options
ORADIM -EDIT -SID sid | -ASMSID sid [-SYSPWD pass]
[-STARTMODE auto|manual] [-SRVCSTART system|demand] [-PFILE file | -SPFILE]
[-SHUTMODE normal|immediate|abort] [-SHUTTYPE srvc|inst] [-RUNAS osusr/ospass]
$ORACLE_HOME\bin\oradim -EDIT -SID orabase -SHUTMODE immediate

$ORACLE_HOME\bin\oradim -EDIT -SID orabase -SPFILE
NEW

Specify new instance options
ORADIM  -NEW -SID sid | -SRVC srvc | -ASMSID sid | -ASMSRVC srvc
[-SYSPWD pass]
[-STARTMODE auto|manual]
[-SRVCSTART system|demand]
[-PFILE file | -SPFILE]
[-SHUTMODE normal|immediate|abort]
[-TIMEOUT secs]
[-RUNAS osusr/ospass]
$ORACLE_HOME\bin\oradim -NEW -SID orabase -SRVC orabase
-SYSPWD uwpwd -STARTMODE manual -SRVCSTART system
-SPFILE
-SHUTMODE immediate
STARTUP

Define service and instance startup options
ORADIM  -STARTUP -SID sid | -ASMSID sid
[-SYSPWD pass]
[-STARTTYPE srvc|inst|srvc,inst]
[-PFILE filename | -SPFILE]
$ORACLE_HOME/bin/oradim -STARTUP -SID orabase -STARTTYPE tstc -SPFILE
SHUTDOWN

Define service and instance shutdown options
ORADIM -SHUTDOWN sid | -ASMSID sid [-SYSPWD pass]
[-SHUTTYPE srvc | inst | srvc,inst]
[-SHUTMODE normal | immediate | abort]
$ORACLE_HOME\bin\oradim -SHUTDOWN -SID orabase -SHUTMODE abort
 
Demo
Start Oracle services on startup using the SPFILE ORADIM -EDIT -SID orabase -STARTMODE auto -SRVCSTART SYSTEM [-SPFILE]

Related Topics
Database
Startup & Shutdown

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved