Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Solaris 2.6 startup/shutdown scripts

Re: Solaris 2.6 startup/shutdown scripts

From: John Stoffel <jfs_at_fluent.com>
Date: 14 Apr 1998 18:02:29 -0400
Message-ID: <rmu37wt62y.fsf@fluent.com>


"Pedro Pimentel de Figueiredo" <ppf_at_novabase.pt> writes:

> I'm looking for some information on how to set up the shutdown
> and startup scripts for the Oracle 7.3 server on a Solaris 2.6 system.
> In what rc* should I create them? Any sample scripts would be great.

Pedro,

I'm using Solaris 2.5.1 to run Oracle 7.3 and here's what I did. I created a script in /etc/init.d called 'dbora' with the following lines:

    #!/bin/sh
    # Oracle start/stop script for Lawson

    ORA_HOME=/accounting/oracle/app/oracle/product/7.3.3     ORA_OWNER=oracle

    if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]     then
    echo "Oracle Startup: cannot start"     exit
    fi
    case "$1" in
    'start')
    su - $ORA_OWNER -c $ORA_HOME/bin/dbstart     ;;
    'stop')
    su - $ORA_OWNER -c $ORA_HOME/bin/dbshut     ;;
    '')
    echo "Usage: dbora {start|stop}"
    ;;
    esac

Then I had to update the already setup dbstart and dbshut scripts to have the correct settings and do a bunch of tests. The trick here is that I have a user account called 'oracle' which does all the starting and stopping of oracle. It needs to be setup properly to have ORACLE_HOME and ORACLE_SID setup properly.

Let me know if you want more info.

John

     John Stoffel - Senior Unix Systems Administrator - Fluent, Inc.
        jfs@fluent.com - http://www.fluent.com - 603-643-2600 x341
             Geological time is not money.  - Mark Twain

Received on Tue Apr 14 1998 - 17:02:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US