• startup – Indicates that the specified instance should be started.
• sid – The SID of the database to start.
• usrpwd – The password for the database user.
• starttype – Specifies whether to start the instance, the service, or both (SRVC, INST)
<li>-pfile is the fully qualified location of the init.ora file </li><li>-intpwd is the internal password </li><li>-timeout refers to the number of seconds Windows will give the service to respond to a “Start” command before timing out. </li><li>
Delete Instance – The following command can be used to delete an instance with oradim:
C:\oracle\bin\oradim –delete –sid MYSID
Notice that no password is needed to perform this task.
The shuttype parameter specifies what is to be stopped – the service (SRVC), the instance (INST), or both (SRVC, INST). The shutmode specifies the method that should perform the shutdown – (A)bort, (I)mmediate, or (N)ormal.
-NEWSID lets you rename the SID
-SHUTMODE refers to the “alter database shutdown xxx” command issued when the service is stopped, and can be A(bort), I(mmediate) or N(ormal) HKLM\Oracle\Homei\ORA_sid_SHUTDOWNTYPE.
-SHUTTYPE refers to what stops when you issue the “stop service” command: service, instance or both. If you don’t specify -SHUTTYPE for a service, Oracle checks the registry for the current setting.
You can also use ORADIM to startup and shutdown the service, instead of using the Services control panel in the GUI
</li>
<oradim Command Line Parameters>
The ORADIM tool supports the command line parameters described in Table 3-40. Use “oradim-help” for more syntax definition.
<h5 class=”docTableTitle”>Table 3-40. ORADIM Command Line Parameters</h5>
Parameter
Purpose
Additional Comments
-NEW
Tells ORADIM to create a new database service.
Only NEW, EDIT, DELETE, STARTUP, or SHUTDOWN can be specified.
-EDIT
Tells ORADIM to edit an existing service.
Only NEW, EDIT, DELETE, STARTUP, or SHUTDOWN can be specified.
-DELETE
Tells ORADIM to delete an existing service.
Only NEW, EDIT, DELETE, STARTUP, or SHUTDOWN can be specified.
-STARTUP
Tells ORADIM to start an existing service.
Only NEW, EDIT, DELETE, STARTUP, or SHUTDOWN can be specified.
-SHUTDOWN
Tells ORADIM to stop an existing service.
Only NEW, EDIT, DELETE, STARTUP, or SHUTDOWN can be specified.
-SID <database SID>
Specifies the database SID for which this service is to be configured.
This argument is mandatory in every version of the command.
-SRVC <service name>
Tells ORADIM what to name the service.
This parameter is optional.
-OSMSID <ASM SID>
Identifies this as an ASM instance, and tells ORADIM the associated SID.
Mutually exclusive with -SID.
-OSMSRVC <service name>
Tells ORADIM what to name the ASM service.
This parameter is optional and is mutually exclusive with -SRVC.
-SYSPWD <password> (10g)
-INITPWD <password> (9i)
-USRPWD <password> (9i)
Provides ORADIM with the SYSDBA password.
If OS authentication is enabled, this parameter is optional.
-STARTMODE [ a | m ]
Defines the startup mode for the service.
a = automatic m = manual
-SRVCSTART [ system | demand ]
Defines when the database service should start.
“system” means to start at boot time; “demand” means to start the first time the database is accessed.
-PFILE <filename>
Designates which init.ora file to use when starting the database.
Mutually exclusive with -SPFILE.
-SPFILE
Tells ORADIM to configure the service to expect a server parameter file at startup.
SPFILE must be in the default location, which is currently ORACLE_HOME\database.
-SHUTMODE [ n | i | a ]
Defines what type of shutdown to issue when the service is stopped.
n = normal
i = immediate
a = abort
-TIMEOUT <seconds>
Specifies the number of seconds to wait for database shutdown before stopping the service.
-RUNAS <OS user>/<OS password>
Causes the database to be started with a specific user as the process owner.
-NEWSID <database SID>
Tells ORADIM that the database associated with an existing service has been renamed.
Used only with the EDIT command.
-STARTTYPE [ srvc | srvc,inst ]
Defines whether just the service should be started, or both the service and the instance.
-SHUTTYPE [ inst | srvc,inst ]
Defines whether just the instance should be shut down, or both the instance and the service.
My name is Aly and I would like to know if you would have any interest to have your website here at epac.to promoted as a resource on our blog alychidesign.com ?
We are in the midst of updating our broken link resources to include current and up to date resources for our readers. Our resource links are manually approved allowing us to mark a link as a do-follow link as well
.
If you may be interested please in being included as a resource on our blog, please let me know.
Hello there,
My name is Aly and I would like to know if you would have any interest to have your website here at epac.to promoted as a resource on our blog alychidesign.com ?
We are in the midst of updating our broken link resources to include current and up to date resources for our readers. Our resource links are manually approved allowing us to mark a link as a do-follow link as well
.
If you may be interested please in being included as a resource on our blog, please let me know.
Thanks,
Aly