Installgen
Features and Benefits
Installgen
Demo Available for download...
#!/bin/sh
# script: /etc/init.d/dbora
# Features: This shell script starts up the Oracle database(s) upon system startup.
# Symbolic links are created to /etc/rc3.d/S88dbora and /etc/rc0.d/K88dbora
# from this file.
#
# WARNING: This startup script will not work correctly if the oracle account
# is set up to use the bash shell. The /bin/sh must be used or the
# Listener services will not start up.
#
# Script Sequence#: 11
# Used By: run automatically via rc3.d startup as root UNIX user
# Copyright 2002 by .com Solutions Inc.
#
# ---------------------- Revision History ---------------
# Date By Changes
# 9-27-2001 dsimpson Initial Release
# 9-30-2001 dsimpson Added use of environment variables for paths
# 11-01-2001 dsimpson OEM username/password now uses the 1st database
# administrator account.
# This output file was created by Installgen version 1.38 on Sun Nov 10 14:51:56 2002. By .com Solutions Inc. www.dotcomsolutionsinc.net
# define globally used paths/variables
ORACLE_OWNER=oracle
ORACLE_OWNER_PATH=/export/oracle
ORACLE_GROUP=dba
ORACLE_HOME=/u01/v901
ORACLE_SID=prod1
OEM_ADMIN=admin
OEM_ADMIN_PASSWORD=zx-vnm
ORA_BDUMP_DIR=/u01/bdump
if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ]
then
echo 'Oracle startup: cannot start'
echo ' (cannot find one or both of dbstart or $ORACLE_HOME)'
exit
fi
case "$1" in
'start')
# Rotate the Oracle alert error log before database starts
LOG=alert_$ORACLE_SID.log
cd $ORA_BDUMP_DIR
test -f $LOG.5 && mv $LOG.5 $LOG.6
test -f $LOG.4 && mv $LOG.4 $LOG.5
test -f $LOG.3 && mv $LOG.3 $LOG.4
test -f $LOG.2 && mv $LOG.2 $LOG.3
test -f $LOG.1 && mv $LOG.1 $LOG.2
test -f $LOG.0 && mv $LOG.0 $LOG.1
mv $LOG $LOG.0
echo 'Starting Oracle databases...'
su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbstart
echo 'Started Oracle database.'
echo 'Starting Oracle Intelligent Agent...'
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/agentctl start"
echo 'Started Intelligent Agent.'
echo 'Starting Oracle listener...'
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start"
echo 'Started Listener.'
# echo 'Starting Oracle Enterprise Management Server'
# su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/oemctl start oms &"
# echo 'Started OMS.'
;;
'stop')
# stop in reverse order from startup process
# echo 'Stopping Oracle Enterprise Management Server'
# su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/oemctl stop oms $OEM_ADMIN/$OEM_ADMIN_PASSWORD &"
# echo 'Stopped OMS.'
echo 'Stopping Oracle Intelligent Agent'
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/agentctl stop"
echo 'Stopped Intelligent Agent.'
echo 'Stopping Oracle listener...'
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl stop"
echo 'Stopped Listener.'
echo 'Stopping Oracle databases...'
su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbshut
echo 'Stopped Oracle database.'
;;
*)
echo usage: $0 start | stop
;;
esac
