Oracle Training in Chennai Auto startup and shutdown of database

Ø  We are going to automatically startup and shutdown oracle database in linux server

In the first picture I didn’t startup any of my database,this can be checked by the below  linux command  “ps  –ef|grep pmon

Ø  Give sid name,ORACLE_HOME path,Y/N  in the “ /etc/oratab “ file as given in the picture

·         If we give Y the database will be startup automatically when server starts

·         If we give N the database will not be startup when server starts…

Ø  create the file in the “/etc/init.d” path with any name, I created the file with the name of “sssora”(your choice)

·         save  the commands in the  <sssora> file as show In the below picture

·         give the execution permission to that file using  “chmod  +x  sssora”

Ø  after that add the file to the startup and shutdown process of the server using the chkconfig command

                              “chkconfig  --add sssora”

Ø  using the same command add the file to diffent run levels

in the below command I added the sssora file to start the database in the runlevel  3&5 by giving the

command “chkconfig  --level  35 sssora on “

Ø  by using the same command we can add the sssora file to shutdown the database at run levels 0&6 when the server shutdowns… 

                      command  “ chkconfig –level 06 sssora off ”

Ø  reboot the server to check the configuration

Ø  see our database is startupped automatically whn the server starts…..