Starting an Instance
Table  1 - 5  describes how to use the ORADIM utility to start an instance. 

Table  1 - 5  Using the ORADIM Utility to Start an Instance 

To start an instance...  
Use this syntax: 
 ORADIM -STARTUP -SID SID [-USRPWD user_pwd] [-STARTTYPE SRVC | INST | SRVC, INST] [-PFILE  "FILENAME" ] 
 
Example to start an instance called puma: 
 C:\> ORADIM -STARTUP -SID puma -STARTTYPE SRVC -PFILE  "C:\ORACLE\ADMIN\PROD\PFILE\init.ora"   
 
Syntax description: 
 
-STARTUP 

  Indicates that you want to start an instance that already exists. This is a mandatory parameter. 
  
 -SID SID 

  The name of the instance you want to start. This is a mandatory parameter. 
  
 -USERPWD user_pwd 

  The password. 
 
 
 -STARTTYPE SRVC, INST 

  Indicates whether to start the service or the instance. One or both values can be specified. If not specified, the registry is checked for the current setting. 

su - oracle -c $ORA_HOME/bin/dbstart

E:\oracle\ora90\BIN>sqlplus.exe /nolog

SQL*Plus: Release  9 . 0 . 1 . 0 . 1  - Production on Mon Jan  20   17 : 46 : 16   2003 

(c) Copyright  2001  Oracle Corporation.  All rights reserved.

SQL> connect / as sysdba
ERROR:
ORA- 24314 : service handle not initialized