From owner-freebsd-database@FreeBSD.ORG  Thu Oct 23 12:04:51 2003
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 4AAB116A4B3
	for <freebsd-database@freebsd.org>;
	Thu, 23 Oct 2003 12:04:51 -0700 (PDT)
Received: from ns2.wananchi.com (ns2.wananchi.com [62.8.64.4])
	by mx1.FreeBSD.org (Postfix) with ESMTP id ED26843F75
	for <freebsd-database@freebsd.org>;
	Thu, 23 Oct 2003 12:04:49 -0700 (PDT)
	(envelope-from wash@wananchi.com)
Received: from wash by ns2.wananchi.com with local (Exim 4.24 #3 (FreeBSD))
	id 1ACklJ-000OS1-2q
	for <freebsd-database@freebsd.org>; Thu, 23 Oct 2003 22:04:45 +0300
Date: Thu, 23 Oct 2003 22:04:45 +0300
From: Odhiambo Washington <wash@wananchi.com>
To: freebsd-database@freebsd.org
Message-ID: <20031023190445.GA88351@ns2.wananchi.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
X-Disclaimer: Any views expressed in this message,where not explicitly
	attributed otherwise, are mine alone!.
X-Mailer: Mutt 1.5.4i (2003-03-19)
X-Designation: Systems Administrator, Wananchi Online Ltd.
X-Location: Nairobi, KE, East Africa.
X-Uptime: 9:58PM  up 5 days, 13:27, 4 users, load averages: 0.15, 0.27, 0.41
User-Agent: Mutt/1.5.4i
Subject: Oracle 9 on FreeBSD 5.1
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>,
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 23 Oct 2003 19:04:51 -0000



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=3D"/shared/oracle9/u01/app/oracle/product/9.2.0.1.0"
ORACLE_OWNER=3D"oracle"
STARTLISTENER=3D"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 > /de=
v/null 2>&1 &
        echo -n " listener"
        ;;
       =20
stop)
        ????????????????????????
        ;;
*)
        echo "Usage: `basename $0` {start|stop}" >&2
        exit 64
        ;;
esac

exit 0





-Wash

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

--
    |\      _,,,---,,_     | Odhiambo Washington    <wash@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.