Start up & Shut Down Oracle

After Install Oracle, go to $ORACLE_HOME/bin

run :

$ export ORACLE_SID={ORACLE_SID}
$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 4 16:21:17 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect system/manager as sysdba

**Note: if you prompted this error, means you didn't set the ORACLE_SID :
ORA-12162: TNS:net service name is incorrectly specified

To shutdown database :

SQL> shutdown immediate


To startup database :

SQL> startup