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