Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

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…..




This post first appeared on Sakthi Software Solutions, please read the originial post: here

Share the post

Oracle Training in Chennai Auto startup and shutdown of database

×

Subscribe to Sakthi Software Solutions

Get updates delivered right to your inbox!

Thank you for your subscription

×