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
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
Oracle will now start on boot