{"id":81,"date":"2014-02-02T10:07:00","date_gmt":"2014-02-02T12:07:00","guid":{"rendered":"http:\/\/maxoracle.com\/2014\/02\/02\/automatically-startup-the-database-when-oracle-linux-starts\/"},"modified":"2014-02-02T10:07:00","modified_gmt":"2014-02-02T12:07:00","slug":"automatically-startup-the-database-when-oracle-linux-starts","status":"publish","type":"post","link":"https:\/\/www.soudba.com.br\/?p=81","title":{"rendered":"Automatically startup the database when Oracle Linux Starts"},"content":{"rendered":"
To make a startup of Oracle database automatically please follow these steps.<\/div>\n
1. First of all we\u2019ve to change our \/etc\/oratab<\/strong> file. This file have some hints like, database name, Oracle home, and start or not – N\/Y<\/div>\n
orcl:\/home\/oracle\/product\/10.2.0\/Db_1:N<\/em><\/div>\n
The first field is the name of my database (orcl<\/strong>), the second one is my home directory (\/home\/oracle\/product\/10.2.0\/Db_1<\/strong>)<\/em>, and the third indicates to the dbstart utility whether the database should, or should not be brough up at the system boot time with \u201cY\u201d or \u201cN\u201d parameters respectively
As a root user, we\u2019ll change last field of this line from \u201cN\u201d to \u201cY\u201d to let dbstart utility start this database when it runs<\/div>\n
2. This need to put one file dbora in \/etc\/init.d\/<\/strong> directory. In this script, we\u2019ll define two variables, ORA_OWNER<\/em>and ORACLE_HOME<\/em> and then, we\u2019ll start (or shutdown) our database by connecting with oracle user and running lsnrctl (Listener utility), dbstart (utility which starts the database) and dbshut (utility which shutdowns the database) utilities depending on our OS state.
This is the source of our dbora file:<\/div>\n
ORACLE_HOME=\/home\/oracle\/product\/10.2.0\/Db_1
ORA_OWNER=oracle<\/span><\/strong><\/div>\n
case \u201c$1\u2033 in
 \u2019start\u2019)  #If the system is starting, then \u2026
su \u2013 $ORA_OWNER -c \u201c$ORACLE_HOME\/bin\/lsnrctl start\u201d #Start the listener
su \u2013 $ORA_OWNER -c \u201c$ORACLE_HOME\/bin\/dbstart #Start the database
  ;;<\/span><\/strong><\/div>\n
\u2018stop\u2019)   #If the system is stops, that is we\u2019re shutting down our OS, then \u2026
  su -$ORA_OWNER -c $ORACLE_HOME\/bin\/dbshut
  su -$ORA_OWNER -c \u201c$ORACLE_HOME\/bin\/lsnrctl stop\u201d
  ;;
esac<\/span><\/strong><\/div>\n
3. Once you\u2019ve saved your file into this directory, make sure that it\u2019s executable by running:
chmod 750  dbora<\/span><\/div>\n
4. Then you need to add the appropriate symbolic links to cause the script to be executed when the system goes down, or comes up. Create it with ln -s command.<\/div>\n
# ln -s \/etc\/init.d\/dbora \/etc\/rc.d\/rc3.d\/K01dbora
# ln -s \/etc\/init.d\/<\/strong>dbora<\/strong> \/etc\/rc.d\/rc3.d\/S99<\/strong>dbora<\/strong>
# ln -s \/etc\/init.d\/<\/strong>dbora<\/strong> \/etc\/rc.d\/rc5.d\/K01<\/strong>dbora<\/strong>
# ln -s \/etc\/init.d\/<\/strong>dbora<\/strong> \/etc\/rc.d\/rc5.d\/S99<\/strong>dbora<\/strong><\/div>\n
Let\u2019s analyze these commands:
The first line creates symbolic link of our script in rc3.d directory. At startup, Linux runs \/etc\/rc.d\/rc script at the current level (normally 3 or 5). rc3.d indicates 3rd runlevel, \u201cK\u201d indicates OS\u2019s shutdown (on servers shutdown, Linux calls the scripts in \/etc\/rc.d\/rc3\/K* in order)
The second line creates another symbolic link of our script, to be run at startup of our OS, indicating \u201cS99\u2033 and the name of our script
Another two lines creates symoblic links for 5th runlevel.<\/div>\n
That\u2019s all. Your script and your service is ready for use. Just restart your OS and upon startup you\u2019ll see your newly created service running. Then open new terminal, enter you database and issue :
SQL>SELECT status FROM v$instance;<\/div>\n
You\u2019ll see your database\u2019s status is OPEN<\/div>\n
P.S
In some releases, even when we create a new service, it doesn\u2019t work. When we issue dbstart command manually from OS, we\u2019re getting an error:
cat: \/var\/opt\/oracle\/oratab: No such file or directory<\/div>\n
It has simple reason and solution
If the directory \/var\/opt\/oracle exists during the Oracle installation the dbhome script will have the parameter ORATAB set to \u201c\/var\/opt\/oracle\/oratab\u201d instead of \u201c\/etc\/oratab\u201d. The normal DBCA process during a default installation will still add the instance entry to \/etc\/oratab.<\/div>\n
It has two solutions:
1. You can either copy the original oratab file to this directory :
cp \/etc\/oratab \/var\/opt\/oracle\/<\/div>\n
2. Or you can edit dbstart and dbshut scripts, find the variable ORATAB, and you\u2019ll find that it\u2019s addressing to  \/var\/opt\/oracle\/oratab file. Jus
\nt change it to \/etc\/oratab<\/div>\n","protected":false},"excerpt":{"rendered":"

To make a startup of Oracle database automatically please follow these steps. 1. First of all we\u2019ve to change our \/etc\/oratab file. This file have some hints like, database name, Oracle home, and start or not – N\/Y orcl:\/home\/oracle\/product\/10.2.0\/Db_1:N The first field … Continue lendo →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-81","post","type-post","status-publish","format-standard","hentry","category-sem-categoria"],"_links":{"self":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/81","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=81"}],"version-history":[{"count":0,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/81\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=81"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=81"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=81"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}