Oracle 9 on FreeBSD 5.1

[Odhiambo Washington]

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.


I was attempting to write one, but it does not work. Perhaps someone can
help me out, pls??


Here is what I was trying, but it is not working and is incomplete.


#!/bin/sh

ORACLE_HOME="/shared/oracle9/u01/app/oracle/product/9.2.0.1.0"
ORACLE_OWNER="oracle"
STARTLISTENER="start"

case "$1" in
start)
        echo "Starting Oracle instances"
        su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbstart > /dev/null 2>&1 &
        echo -n " oradb"

        echo "Starting the listener"
        su - $ORACLE_OWNER -c $ORACLE_HOME/bin/lsnrctl $STARTLISTENER > /dev/null 2>&1 &
        echo -n " listener"
        ;;
        
stop)
        ????????????????????????
        ;;
*)
        echo "Usage: `basename $0` {start|stop}" >&2
        exit 64
        ;;
esac

exit 0





-Wash

http://www.netmeister.org/news/learn2quote.html

--
    |\      _,,,---,,_     | Odhiambo Washington    <wash at wananchi.com>
Zzz /,`.-'`'    -.  ;-;;,_ | Wananchi Online Ltd.   www.wananchi.com
   |,4-  ) )-,_. ,\ (  `'-'| Tel: +254 20 313985-9  +254 20 313922
  '---''(_/--'  `-'\_)     | GSM: +254 722 743223   +254 733 744121
+
She liked him; he was a man of many qualities, even if most of them
were bad.