Sunday, December 30, 2007

Oracle 10g Installation on Ubuntu

The link problem
The installation process stops midway, complaining about a certain make target having some error message.

Read this post for fixing that :
Here


Thought the post points to an older version of Ubuntu, it works on Gutsy just as good.

Things to do to make it work automatically on each reboot :

1. create a script in init.d, Sample Here

2. Create further links for that script in diff rc.d directories. Remember, the suggested commands in the page referred above are not correct completely. The path needs to be changed. So, check ur box, and then update the path.

3. In the script, there is no reference to the listener start/stop thing, u got to do that urself. So, add ${ORACLE_HOME}/bin/lsnrctl {start|stop} before the dbstart and dbshut respectively.

Here's my copy for reference...

----------------------------
#! /bin/sh -x
#
# Change the value of ORACLE_HOME to specify the correct Oracle home
# directory for your installation.

#ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
ORACLE_HOME=/media/sda8/oracle/product/10.1.0.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

case $1 in
'start')
${ORACLE_HOME}/bin/lsnrctl start
$ORACLE_HOME/bin/dbstart $ORACLE_HOME &
;;
'stop')
${ORACLE_HOME}/bin/lsnrctl stop
$ORACLE_HOME/bin/dbshut &
#$ORACLE_HOME &
;;
*)
echo "usage: $0 {start|stop}"
exit
;;
esac
#
exit

----------------------------

4. The files at $ORACLE_HOME/network/logs behave strangely when root tries to start a listener. So, mark them 777 and then the listener control from root works fine.

When i know more, I would post...