Anonymous
public text v1 · immutable#!/bin/sh
. /lib/lsb/init-functions
SU=/bin/su
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
ORACLE_OWNER=oraclexe
ORACLE_SID=XE
export ORACLE_HOME
export ORACLE_OWNER
export ORACLE_SID
export PATH=$ORACLE_HOME/bin:$PATH
export LC_ALL=C
case "$1" in
start) echo "Starting Oracle Net Listener"
$SU $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start" > /dev/null 2>&1
echo "Starting Oracle 10g Database Instance"
$SU $ORACLE_OWNER -c "$ORACLE_HOME/bin/sqlplus -s /nolog @$ORACLE_HOME/config/scripts/startdb.sql" > /dev/null 2>&1
echo "."
;;
stop) echo "Shutting down Oracle 10g Database Instance"
$SU $ORACLE_OWNER -c "$ORACLE_HOME/bin/sqlplus -s /nolog @$ORACLE_HOME/config/scripts/stopdb.sql" > /dev/null 2>&1
echo "Stopping Oracle Net Listener"
$SU $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl stop" > /dev/null 2>&1
echo "."
;;
*) echo "Usage: /etc/init.d/oracle start|stop"
exit 1
;;
esac
exit 0