From owner-freebsd-database@FreeBSD.ORG  Thu Oct 23 15:34:13 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 E838616A4B3
	for <freebsd-database@freebsd.org>;
	Thu, 23 Oct 2003 15:34:13 -0700 (PDT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.186])
	by mx1.FreeBSD.org (Postfix) with ESMTP id AC02343F85
	for <freebsd-database@freebsd.org>;
	Thu, 23 Oct 2003 15:34:12 -0700 (PDT)
	(envelope-from gwk@rahn-koltermann.de)
Received: from [212.227.126.205] (helo=mrelayng.kundenserver.de)
	by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
	id 1ACo1l-0006Vy-00; Fri, 24 Oct 2003 00:33:57 +0200
Received: from [217.232.129.25] (helo=rahn-koltermann.de)
	by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1)
	id 1ACo1l-0000s1-00; Fri, 24 Oct 2003 00:33:57 +0200
Message-ID: <3F985743.1070107@rahn-koltermann.de>
Date: Fri, 24 Oct 2003 00:33:39 +0200
From: "Georg-W. Koltermann" <gwk@rahn-koltermann.de>
User-Agent: Netscape/6.2 but in reality Mozilla five.0 (X11; U; FreeBSD i386;
	en-US; rv:1.5) Gecko/20031021
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Odhiambo Washington <wash@wananchi.com>
References: <20031023190445.GA88351@ns2.wananchi.com>
In-Reply-To: <20031023190445.GA88351@ns2.wananchi.com>
X-Enigmail-Version: 0.76.7.0
X-Enigmail-Supports: pgp-inline, pgp-mime
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
cc: freebsd-database@freebsd.org
Subject: Re: 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 22:34:14 -0000

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.