How To Startup Oracle Database

[NURAN]

1. Login to the system with oracle username

Typical oracle installation will have oracle as username and dba as group. On Linux, do su to oracle as shown below.
$ su - oracle

2. Connect to oracle sysdba

Make sure ORACLE_SID and ORACLE_HOME are set properly as shown below.
$ env | grep ORA ORACLE_SID=DEVDB ORACLE_HOME=/u01/app/oracle/product/10.2.0

You can connect using either ?/ as sysdba? or an oracle account that has DBA privilege.
$ sqlplus '/ as sysdba'
SQL*Plus: Release 10.2.0.3.0 - Production on Sun Jan 18 11:11:28 2009 Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production With the Partitioning and Data Mining options SQL>

3. Start Oracle Database

The default SPFILE (server parameter file) is located under $ORACLE_HOME/dbs. Oracle will use this SPFILE during startup, if you don?t specify PFILE.
Oracle will look for the parameter file in the following order under $ORACLE_HOME/dbs. If any one of them exist, it will use that particular parameter file.

1. spfile$ORACLE_SID.ora
2. spfile.ora
3. init$ORACLE_SID.ora

Type ?startup? at the SQL command prompt to startup the database as shown below.
SQL> startup
ORACLE instance started. Total System Global Area 812529152 bytes Fixed Size 2264280 bytes Variable Size 960781800 bytes Database Buffers 54654432 bytes Redo Buffers 3498640 bytes Database mounted. Database opened.
SQL>
If you want to startup Oracle with PFILE, pass it as a parameter as shown below.
SQL> STARTUP PFILE=/u01/app/oracle/product/10.2.0/dbs/init.ora

<!-- google_ad_section_start -->vBulletin Puf noktalari<!-- google_ad_section_end --> </h2> <div class="content"> <script type="text/javascript"><!--
google_ad_client = "pub-8193046932458938";
/* 468x15, olu?turulma 12.08.2011 */
google_ad_slot = "3651401931";
google_ad_width = 468;
google_ad_height = 15;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>