CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle ORADIM
Version 11.1
 
GENERAL
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
 
DROP ORADIM -DELETE 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 Shutmode 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
NEW 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
-PFILE c:\oracle\product\ora102\database\initorabase.ora
-SHUTMODE immediate
SPFILE Selection ORADIM -STARTUP sid | -ASMSID sid [-SYSPWD pass]
[STARTTYPE srvc | inst | srvc,inst]
[-PFILE filename | -SPFILE]
$ORACLE_HOME\bin\oradim -EDIT -SID orabase -SPFILE
STARTUP ORADIM -STARTUP sid | -ASMSID sid [-SYSPWD pass]
[STARTTYPE srvc | inst | srvc,inst]
[-PFILE filename | -SPFILE]
$ORACLE_HOME/bin/oradim -STARTUP -SID orabase 
-STARTTYPE tstc -SPFILE
SHUTDOWN 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
 
Related Topics
Database
Starting & Stopping
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [207 users online]    © 2010 psoug.org