| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
ORADIM is a Windows only utility used for the creation, modification and deletion of the Windows Service. |
| Full Syntax |
Enter one of the following commands:
Create an instance by specifying the following options:
-NEW -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid | -APXSID sid|
-SRVC srvc | -ASMSRVC srvc | -MGMTDBSRVC srvc | -IOSSRVC srvc |
-APXSRVC srvc [-SYSPWD pass] [-STARTMODE auto|manual]
[-SRVCSTART system|demand] [-PFILE file | -SPFILE] [-MAXUSERS maxusers]
[-SHUTMODE normal|immediate|abort] [-TIMEOUT secs] [-RUNAS osusr/ospass]
Edit an instance by specifying the following options:
-EDIT -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid | -APXSID sid
[-SYSPWD pass] [-STARTMODE auto|manual] [-SRVCSTART system|demand]
[-PFILE file | -SPFILE] [-SHUTMODE normal|immediate|abort]
[-SHUTTYPE srvc|inst] [-MAXUSERS maxusers] [-RUNAS osusr/ospass]
Delete instances by specifying the following options:
-DELETE -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid |
-APXSID sid| -SRVC srvc | -ASMSRVC srvc | -MGMTDBSRVC srvc |
-IOSSRVC srvc | -APXSRVC srvc
Start up services and instance by specifying the following options:
-STARTUP -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid
|-APXSID sid [-SYSPWD pass] [-STARTTYPE srvc|inst|srvc,inst]
[-PFILE filename | -SPFILE]
Shut down service and instance by specifying the following options:
-SHUTDOWN -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid |
-APXSID sid [-SYSPWD pass] [-SHUTTYPE srvc|inst|srvc,inst]
[-SHUTMODE normal|immediate|abort]
Manipulate ACLs by specifying the following options:
-ACL -setperm|-addperm|-removeperm dbfiles|diag|registry
-USER username -OBJTYPE file|dir|registry -OBJPATH object-path
-RECURSE true|false [-HOST hostname]
Manipulate FAMILY settings by specifying the following options:
-FAMILY -set|-delete value [-SID sid | -ASMSID sid |
-MGMTDBSID sid | -IOSSID sid | -APXSID sid ]
Query for help by specifying the following parameters: -? | -h | -help |
| Definitions |
| ACL |
x |
| APXSID |
x |
| APXSRVC <service_name> |
x |
| ASMSID |
ASM instance name |
| ASMSRVC <service_name> |
ASM service name |
| FAMILY |
x |
| HOST |
x |
| IOSSID |
x |
| IOSSRVC <service_name> |
x |
| MAXUSERS |
x |
| MGMTDBSID |
Cluster Health Monitior instance name |
| MGMTDBSRVC <service_name> |
Cluster Health Monitior service name |
| NEW |
Indicates that a new instance is being created |
| OBJPATH |
x |
| OBJTYPE |
x |
| PFILE <file_name> |
Parameter File Path and Name |
| RECURSE |
x |
| 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 |
| USER |
x |
|
| |
| Commands |
DELETE
Delete instances by specifying options |
-DELETE -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid |
-APXSID sid| -SRVC srvc | -ASMSRVC srvc | -MGMTDBSRVC srvc |
-IOSSRVC srvc | -APXSRVC 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 |
MANIPULATE ACLS
??? |
-ACL -setperm|-addperm|-removeperm dbfiles|diag|registry
-USER username -OBJTYPE file|dir|registry -OBJPATH object-path
-RECURSE true|false [-HOST hostname] |
| TBD |
MANIPULATE FAMILY
??? |
-FAMILY -set|-delete value [-SID sid | -ASMSID sid |
-MGMTDBSID sid | -IOSSID sid | -APXSID sid ] |
| TBD |
MODIFY
Edit an instance by specifying the options |
-EDIT -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid | -APXSID sid
[-SYSPWD pass] [-STARTMODE auto|manual] [-SRVCSTART system|demand]
[-PFILE file | -SPFILE] [-SHUTMODE normal|immediate|abort]
[-SHUTTYPE srvc|inst] [-MAXUSERS maxusers] [-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 |
-NEW -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid | -APXSID sid|
-SRVC srvc | -ASMSRVC srvc | -MGMTDBSRVC srvc | -IOSSRVC srvc |
-APXSRVC srvc [-SYSPWD pass] [-STARTMODE auto|manual]
[-SRVCSTART system|demand] [-PFILE file | -SPFILE] [-MAXUSERS maxusers]
[-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 |
-STARTUP -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid
|-APXSID 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 |
-SHUTDOWN -SID sid | -ASMSID sid | -MGMTDBSID sid | -IOSSID sid |
-APXSID 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] |