Running it as a service

Oracle 10g on Mandrake 10

I recently decided to install Oracle on Mandrake 10.

You can get it from http://otn.oracle.com. extract using

Run "gunzip " on all the files.

Eg.: gunzip ship.db.cpio.gz

NOTE OTN for a while has carried a ship.db.cpio.gz that is not gzipped. If gzip reports this is not a zip file simply run step 2 directly.

2. Extract the cpio archives with the command "cpio -idcmv < " Eg.: cpio -idcmv < ship.db.cpio

Follow the quick install guide http://download-west.oracle.com/docs/html/B10813_01/toc.htm to the letter (it matters1.1 ) except

Page 26 - Put the bash/c scripts in an exectable file in /etc/profile.d (see the others that and there and copy the naming).

Wherever you extracted Oracle to go to Disk1/stage/prereq and edit db_server_prereq.xml and change all instances of CertifiedVersions prereq to warning.

<PREREQUISITEREF NAME="CertifiedVersions" SEVERITY="Warning"/>

and in refhosts.xml add this

<OPERATING_SYSTEM>
        <VERSION VALUE="10"/>
        <ARCHITECTURE VALUE="x86"/>
        <NAME VALUE="Linux"/>
        <VENDOR VALUE="Mandrake"/>
        </OPERATING_SYSTEM>

In install/oraparam.ini change certified versions to

[Certified Versions]
        Linux=redhat-2.1,UnitedLinux-1.0,redhat-3,mandrake-10

Next run the installer as in the quickinstall instructions. It should be fooled into thinking Mandrake is a supported platform

Running it as a service

This is loosely based on an old Oracle supplied scipt for this at http://download-uk.oracle.com/docs/html/B10812_01/chapter2.htm#sthref210 but it needs rsh.

Copy $ORACLE_HOME/install/oratab to /etc Edit /etc/oracle and put a Y on the end of instances you want to autostart

put the script below in /etc/profile.d called oracle.sh run chmod a+x oracle.sh

export ORACLE_HOME=/u01/app/oracle/product/10.1.0/db_1
 export PATH="$PATH:$ORACLE_HOME/bin"
 export ORACLE_SID=YOUR_SID

Put the script below in /etc/init.d and called in oracle chmod u+x on it to make it runabble

#1.1  /bin/sh  -x
 #
 # chkconfig: 2345 90 20
 # description: starts and stops Oracle
 #
 # Change the value of ORACLE_HOME to specify the correct Oracle home
 # directory for you installation

 ORACLE_HOME=/u01/app/oracle/product/10.1.0/db_1
 #
 # change the value of ORACLE to the login name of the
 # oracle owner at your site
 #

 ORACLE=oracle

 PATH=$&#123;PATH&#125;:$ORACLE_HOME/bin
 HOST=`hostname`
 PLATFORM=`uname`
 export ORACLE_HOME PATH

 #
 LOG=$ORACLE_HOME/startup.log
 touch $LOG
 chmod a+r $LOG
 #

 case $1 in
 'start')
        echo "$0: starting up" >> $LOG
        date >> $LOG
        # Start Oracle Net
        if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
        then
             echo "starting Oracle Net Listener"
             sudo -u $ORACLE $ORACLE_HOME/bin/lsnrctl start >> $LOG 2>&1 &
        fi
        echo "Starting Oracle databases"
        sudo -u $ORACLE $ORACLE_HOME/bin/dbstart >> $LOG 2>&1 &

#UNCOMMENT THIS if you Oracle Enterprise Manager
        #echo "Starting Oracle Enterprise Manager"
        #sudo -u $ORACLE $ORACLE_HOME/bin/emctl start dbconsole >> $LOG 2>&1 &


        ;;
 'stop')
        echo "$0: shutting down" >> $LOG
        date >> $LOG
        # Stop Oracle Net
        if [ -f $ORACLE_HOME/bin/tnslsnr ] ;
        then
             echo "stopping Oracle Net Listener"
             sudo -u $ORACLE $ORACLE_HOME/bin/lsnrctl stop >> $LOG 2>&1 &
        fi
        echo "stopping Oracle databases"
        sudo -u $ORACLE $ORACLE_HOME/bin/dbshut >> $LOG 2>&1 &
#UNCOMMENT THIS if you Oracle Enterprise Manager
        # echo "Stopping Oracle Enterprise Manager"
        # sudo -u $ORACLE $ORACLE_HOME/bin/emctl stop dbconsole >> $LOG 2>&1 &
        ;;
 *)
        echo "usage: $0 &#123;start|stop&#125;"
        exit
        ;;
 esac
 #
 exit

Run chkconfig ––add oracle

Oracle will now start on boot

Oracle Community Forums

http://www.orafaq.com/

KB - Running it as a service
Version 1.10 last modified by bgidley on 20/06/2005 at 10:36

Knowledge Base

Lost account?
Join the community, be part of the Club: it's free!
Get the PWP Download Subscription!

Running it as a service

Oracle Community Forums

Document data

Knowledge Base