startup database

How to start  database / make database up?

Before starting database make sure your pfile/spfile (spfile$ORACLE_SID.ora/init$ORACLE_SID.ora) is having sufficient parameters.

in OS prompt perform below operations:

setenv ORACLE_HOME  /u01/oracle/app/product/11.2.0/dbhome_1

setenv ORACLE_SID  ttdtest

setenv PATH ${PATH}:$ORACLE_HOME/bin

                          or

export ORACLE_HOME=/u01/oracle/app/product/11.2.0/dbhome_1

export  ORACLE_SID =ttdtest

we can startup database in directly or by step by step process.

Sqlplus / as sysdba

Direct method: 

SQL> STARTUP PFILE=/u01/oracle/app/product/11.2.0/dbhome_1/dbs/initttdtest.ora
or

SQL> STARTUP

Step by Step method :

SQL> startup  nomount pfile='/u01/oracle/app/product/11.2.0/dbhome_1/dbs/initttdtest.ora';

ORACLE instance started.

Total System Global Area   609681408 bytes

Fixed Size                              2215664 bytes

Variable Size                         549454096 bytes

Database Buffers                 50331648 bytes

Redo Buffers                        7680000 bytes

SQL> alter database mount;

Database altered.

SQL> alter database open;

Database altered.