#!/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