| 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 |
| SHUTMODE |
How the Windows Service should shutdown the database. Options are ABORT, NORMAL, and IMMEDIATE |
| 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 |
| 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 |
| |
| Demos |
| Start Oracle services on startup using the SPFILE |
ORADIM -EDIT -SID orabase -STARTMODE auto -SRVCSTART SYSTEM [-SPFILE] |
