1- Edit /etc/oratab

$ vi /etc/oratab

"/etc/oratab" 24 lines, 765 characters
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME::
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
ORABCKP:/oracle/app/oracle/product/10.2.0:N <-------- will be Y

(ORABCKP:/oracle/app/oracle/product/10.2.0:Y)
~

2- Create a script under /sbin/init.d

$vi /sbin/init.d/oracle

#!/sbin/sh
#
# @(#)
#
# NOTE: This script is not configurable! Any changes made to this
# scipt will be overwritten when you upgrade to the next
# release of HP-UX.
#
# WARNING: Changing this script in any way may lead to a system that
# is unbootable. Do not modify this script.
#
# NOTE:
# For ORACLE:
#
PATH=/usr/sbin:/usr/bin:/sbin
export PATH
ORA_HOME="/oracle/app/oracle/product/10.2.0"
ORA_OWNR="oracle"
rval=0
set_return() {
x=$?
if [ $x -ne 0 ]; then
echo "EXIT CODE: $x"
rval=1
fi
}

case $1 in
start)
# Oracle listener and instance startup
echo -n "Starting Oracle: "
su - $ORA_OWNR -c "$ORA_HOME/bin/dbstart /oracle/app/oracle/product/10.2.0"
echo "OK DB started"
;;
stop)
# Oracle listener and instance shutdown
echo -n "Shutdown Oracle: "
su - $ORA_OWNR -c "$ORA_HOME/bin/dbshut /oracle/app/oracle/product/10.2.0"
echo "OK DB shutdown"
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo "usage: $0 {start|stop}"
;;
esac

exit $rval


3- Decide the runlevel and create soft links for the script we created.

Under /sbin/rc3.d
ln -s /sbin/init.d/oracle S999oracle

Under /sbin/rc1.d and /sbin/rc2.d
ln -s /sbin/init.d/oracle K9oracle

11 Responses so far.

  1. Thank you for sharing such a nice and interesting blog.

    oracle fusion scm online training

  2. Thank you for sharing such a nice and interesting blog and really very helpful article

    Oracle Fusion Financials Online Training

  3. Very interesting blog Thank you for sharing such a nice and interesting blog and really very helpful article

    Oracle Fusion HCM Online Training

  4. Very interesting blog Thank you for sharing such a nice and interesting blog and really very helpful article

    Oracle Fusion SCM Online Training

  5. Awesome blog. I enjoyed reading your articles. This is truly a great read for me. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work.

  6. shivani says:

    Thanks for sharing useful information.. we have learned so much information from your blog..... keep sharing
    Oracle Fusion Financials Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training

  7. Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Big Data and Hadoop Online Training
    Big Data Hadoop Training

  8. It's Incredibly grand. Really very helpful article, Thank you for sharing

    Spark Scala Training
    Spark and Scala Online Training
    Hyderabad

  9. Thank you for sharing this information. Informative article.
    If you are looking for data science courses in Bangalore, visit Learnbay. co
    website to check details related to the data science online courses.

  10. Thanks for Sharing This Article. It is so much valuable content. If you are looking for machine learning course-related articles,
    visit Learnbay. co website, best machine learning institute.
    Upgrade your knowledge by learning the best machine learning course from the best machine learning institute in Bangalore (Learnbay).

Powered by Blogger.

Page Views

- Copyright © 2024 Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -