ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
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
