Oracle Database Startup and Shutdown Procedure

thanks the geek stuff How To Startup Oracle Database 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 – Production on Sun Jan 18 11:11:28 2009 Copyright (c) 1982,… Continue Reading