Oracle 10g on Mandrake 9.2

I recently decided to install Oracle on Mandrake 9.2.

So here are some notes in case anyone else wants to try

You can get it from http://otn.oracle.com. As a minor piece of comedy it appears the survey is running on Oracle 8i! Based on the URLs that fly past!

extract using

 	1. Run "gunzip <filename>" on all the files.

Eg.: gunzip ship.db.cpio.gz

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

Follow the quick install guide 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="9.2"/>
	<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-9.2

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

Oracle supply a scipt for this at http://download-uk.oracle.com/docs/html/B10812_01/chapter2.htm#sthref210 but it needs rsh.

I changed it to this and it works

 #! /bin/sh  -x
 #
 # 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

As mandrake does not have rsh anymore.

Oracle Community Forums

http://www.orafaq.com/