Oracle ORADIM Windows Utility

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

$ORACLE_HOME\bin\oradim -EDIT -SID orabase -SHUTMODE immediate

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

NEW

Specify new instance options

$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

$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]