Often we need to setup database to be started automatically when the server hosting the database is rebooted. This on linux can be done by settting the automatic database startup flag to "Y" in file /etc/oratab.
See the following -
# vi /etc/oratab
ORCL:/u01/app/oracle/product/10.2:N
In this file, check carefully the instance (SID) and Oracle home (directory) specified there and if you want this database to automatically start on linux server reboot, then just update the last character to "Y", as in following -
ORCL:/u01/app/oracle/product/10.2:Y
Save file and test it ! |