{"id":1020,"date":"2012-08-15T15:44:00","date_gmt":"2012-08-15T07:44:00","guid":{"rendered":"http:\/\/rmohan.com\/?p=1020"},"modified":"2012-08-15T15:44:00","modified_gmt":"2012-08-15T07:44:00","slug":"oracle-startpup-script","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=1020","title":{"rendered":"Oracle Startpup script"},"content":{"rendered":"
Oracle Startup script used for Automatic start up of oracle db after rebooting the machine. I have already explained how to install oracle 11g in previous posts and just note how to add a startup script with respect to that settings<\/p>\n

For automatically restart the oracle after system reboot\u00a0 create a file called oracle ( any name ) in \/etc\/init.d\/ and give executable permission and paste the code into it. And make a link to \/etc\/rc5.d\/\u00a0 for that<\/p>\n

# cd \/etc\/rc5.d
\n# ll
\n# ln -s ..\/init.d\/oracle S86oracle<\/p>\n

# vim \/etc\/init.d\/oracle —– and paste the below script into it. and then make the above link into it.<\/div>\n<\/div>\n
# Oracle Startpup script<\/div>\n
ORACLE_HOME=\/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_1
\nORA_OWNER=oracle
\ncase “$1” in
\n‘start’) #If the system is starting, then…
\necho -e “\\e[34mStarting ORACLE…\\e[0m”<\/div>\n
#Start the listener
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/lsnrctl start 2>&1> \/dev\/null”<\/div>\n
\n
#Start the database<\/div>\n
\u00a0\u00a0\u00a0\u00a0 su – $ORA_OWNER -c “$ORACLE_HOME\/bin\/dbstart 2>&1 > \/dev\/null”
\n#\u00a0 su – $ORA_OWNER -c “$ORACLE_HOME\/bin\/emctl start dbconsole 2>&1 > \/dev\/null” #Start OEM
\n;;
\n‘stop’)\u00a0\u00a0 #If the system stops, that is we’re shutting down our OS, then…
\necho -e “\\e[34mStopping ORACLE…\\e[0m”
\n#\u00a0 su – $ORA_OWNER -c “$ORACLE_HOME\/bin\/emctl stop dbconsole 2>&1 > \/dev\/null”
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/dbshut 2>&1 > \/dev\/null”
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/lsnrctl stop 2>&1 > \/dev\/null”
\n;;
\nesac<\/div>\n
OR<\/strong><\/p>\n

\u00a0<\/strong># Oracle Startpup script<\/div>\n

<\/div>\n
ORACLE_HOME=\/home\/oracle\/oracle\/product\/10.2.0\/db_1
\nORA_OWNER=oracle
\ncase “$1” in
\n‘start’) #If the system is starting, then…
\necho -e “e[34mStarting ORACLE…e[0m”
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/lsnrctl start 2>&1> \/dev\/null”
\n#Start the listener
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/dbstart 2>&1 > \/dev\/null”
\n#Start the database
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/emctl start dbconsole 2>&1 >
\n\/dev\/null” #Start
\nOEM
\n;;
\n‘stop’) #If the system is stops, that is we’re shutting down our OS,
\nthen…
\necho Oracle startup script
\nORACLE_HOME=\/home\/oracle\/oracle\/product\/10.2.0\/db_1
\nORA_OWNER=oracle
\ncase “$1” in
\n‘start’) #If the system is starting, then…
\necho -e “e[34mStarting ORACLE…e[0m”
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/lsnrctl start 2>&1> \/dev\/null”
\n#Start the listener
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/dbstart 2>&1 > \/dev\/null”
\n#Start the database
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/emctl start dbconsole 2>&1 >
\n\/dev\/null” #Start
\nOEM
\n;;
\n‘stop’) #If the system is stops, that is we’re shutting down our OS,
\nthen…
\necho -e “e[34mStopping ORACLE…e[0m”
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/emctl stop dbconsole 2>&1 >
\n\/dev\/null”
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/dbshut 2>&1 > \/dev\/null”
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/lsnrctl stop 2>&1 > \/dev\/null”
\n;;
\nesac
\n-e “e[34mStopping ORACLE…e[0m”
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/emctl stop dbconsole 2>&1 >
\n\/dev\/null”
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/dbshut 2>&1 > \/dev\/null”
\nsu – $ORA_OWNER -c “$ORACLE_HOME\/bin\/lsnrctl stop 2>&1 > \/dev\/null”
\n;;
\nesac<\/div>\n<\/div>\n
<\/div>\n

 <\/p>\n

Change the path according to your path<\/div>\n
<\/div>\n
Save the file as oracle in \/etc\/init.d directory and make it executable. This script starts the listener, database and enterprise manager.<\/div>\n

# vim \/etc\/init.d\/oracle
\n# chmod 755 \/etc\/init.d\/oracle<\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle Startup script used for Automatic start up of oracle db after rebooting the machine. I have already explained how to install oracle 11g in previous posts and just note how to add a startup script with respect to that settings<\/p>\n

For automatically restart the oracle after system reboot create a file called oracle ( […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1020"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1020"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1020\/revisions"}],"predecessor-version":[{"id":1021,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/1020\/revisions\/1021"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1020"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1020"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}