Oracle 10g on Mandrake 10

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

 	1. Run "gunzip <filename>" 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 < <filename>"	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 matters!) 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"

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

 #! /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=${PATH}:$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 &
        ;;
 '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 &
        ;;
 *)
        echo "usage: $0 {start|stop}"
        exit
        ;;
 esac
 #
 exit

• Run chkconfig --add oracle

Oracle will now start on boot

Oracle Community Forums

http://www.orafaq.com/