Re: Q: how to properly start up and shut down Oracle?

From: Stephan Witt <witt_at_beusen.de>
Date: 1996/12/17
Message-ID: <32B6E38D.41C67EA6@beusen.de>#1/1

Charles Chen wrote:
>
> Hi. I just finished installing Oracle 7.3.2.1.0 on Solaris 2.5.1 on a
> Sparc10. It is currently up and running since I can go into SQL*Plus
> and query the default EMP table. However, I would like to know how to
> properly shut down Oracle both manually and by some automatic method.
> In addition, I was wondering how to automatically start up Oracle when
> the Sparc10 is rebooted. Thanks for any help you can provide.
>
> Sincerely,
> Henry

Hi Henry,

maybe you're interested in my own startup script. I did it like the other SYSV-init-stuff.

==========================snip===============================

#!/sbin/sh -f
ORACLE_HOME=/opt/app/oracle ; export ORACLE_HOME OBIN=$ORACLE_HOME/bin
case $1 in
start)

LOGFILE=/var/adm/dbstart.log
if [ -x $ORACLE_HOME/bin/dbstart ] ; then

      logger -p auth.notice "Starting RDBMS Oracle"
      su - oracle -c "source .login ; $OBIN/lsnrctl start ;

$OBIN/dbstart" > $LOGFILE

   fi
   chown oracle /var/adm/dbstart.log
   chgrp dba /var/adm/dbstart.log
   ;;
stop)

LOGFILE=/var/adm/dbshut.log
if [ -x $ORACLE_HOME/bin/dbshutim ] ; then

      logger -p auth.notice "Shutting down RDBMS Oracle"
      su - oracle -c "source .login ; $OBIN/dbshutim ; $OBIN/lsnrctl

stop" > $LOGFILE

   fi
   chown oracle /var/adm/dbshut.log
   chgrp dba /var/adm/dbshut.log
   ;;
*)

echo "Usage: $0 { start | stop }"
;;
esac

==========================snip===============================

PS:
Maybe, Oracle should give an example, but this is exactly the work, what a SysAdmin gets paid for.

-- 
---------------------------------------------------------------
<stephan.witt_at_beusen.de>  | "beusen" Software+Systeme GmbH
fon: +49 30 549932-62     | Landsberger Allee 392
fax: +49 30 549932-21     | 12681 Berlin, Germany
---------------------------------------------------------------

Received on Tue Dec 17 1996 - 00:00:00 CST