Learn how to start an instance and services using ORADIM.
oradim -STARTUP -SID SID | -ASMSID SID [-SYSPWD password] [-STARTTYPE srvc | inst | srvc,inst] [-PFILE filename | -SPFILE]
For this command, note the following:
-STARTUPindicates that you are starting an instance that already exists. This is a mandatory parameter.
SIDis the name of the instance to start.
SIDis the name of the Oracle Automatic Storage Management instance to start.
instindicates whether to start the service or the instance. One or both values can be specified. If it is not specified, then the registry is checked for the current setting.
-STARTTYPE srvcis the equivalent of running
net start oracleservice
sidfrom the command line.
-STARTTYPE instis the equivalent of running
filenameis the initialization parameter file to be used with this instance. Ensure that you specify the complete path name of this file, including drive letter.
-SPFILEindicates that a server parameter file (SPFILE) be used during startup instead of a PFILE.
To start an instance called
puma, for example, enter:
C:\> oradim -STARTUP -SID puma -STARTTYPE inst -PFILE C:\app\username\admin\prod\pfile\init.ora