Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 24 Oct 2003 00:33:39 +0200
From:      "Georg-W. Koltermann" <gwk@rahn-koltermann.de>
To:        Odhiambo Washington <wash@wananchi.com>
Cc:        freebsd-database@freebsd.org
Subject:   Re: Oracle 9 on FreeBSD 5.1
Message-ID:  <3F985743.1070107@rahn-koltermann.de>
In-Reply-To: <20031023190445.GA88351@ns2.wananchi.com>
References:  <20031023190445.GA88351@ns2.wananchi.com>

next in thread | previous in thread | raw e-mail | index | archive | help
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.





Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3F985743.1070107>