Oracle 9 on FreeBSD 5.1

[Georg-W. Koltermann]

Odhiambo Washington wrote:

>Hello Good people,
>
>I have installed Oracle 9i on FreeBSD 5.1-RELEASE using the notes at
>http://www.shadowcom.net/freebsd-oracle9i/. I must say I was very
>successful except one change is very necessary on that HOWTO.
>Remove the option for SHMMAX and you will not get the "Out of memory"
>problem.
>
>Now just one thing remaining, does anyone have a script I can throw
>into /usr/local/etc/rc.d/ as oracle.sh so that Oracle can be controlled
>like the other servers? I have googled but no such script for FreeBSD.
>
>
>  
>
Hi Odhiambo,

this one works for me:

#!/bin/sh
ORACLE_HOME=/opt/oracle/product/9.0.1 ; export ORACLE_HOME
case "$1" in
start)
        if [ -x $ORACLE_HOME/bin/dbstart ] ; then
            su - oracle -c $ORACLE_HOME/bin/dbstart && echo -n " ORACLE"
            su - oracle -c "$ORACLE_HOME/bin/lsnrctl start" && \
                    echo -n "Listener "
        fi
        ;;
stop)
        if [ -x $ORACLE_HOME/bin/dbshut ] ; then
            su - oracle -c "$ORACLE_HOME/bin/lsnrctl stop" && \
                    echo -n "Listener "
            su - oracle -c $ORACLE_HOME/bin/dbshut && echo -n "ORACLE "
        fi
        ;;
*)
        echo "Usage: `basename $0` {start|stop}" >&2
        ;;
esac
 

  

--
Regards,
Georg.