Oracle ORADIM
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
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]

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