== Oracle 8 ==
<code>
# vim: set syntax=sh:                                                                                         
                                                                                                              
# Oracle control script                                                                                       
# Authors: Jean-Baptiste Onofré                                                                               
#        : Bruno Bonfils                                                                                      
#                                                                                                             
# This script is for Oracle 8 _only_                                                                          
# Enable this script via :                                                                                    
#                                                                                                             
# Debian: update-rc.d oracle start 19 2 . stop 80                                                             
#                                                                                                             
# This script _must_ be run before to start snmpd (which is run a S20)                                        
                                                                                                              
set -e                                                                                                        
                                                                                                              
ORACLE_OWNER=oracle                                                                                           
                                                                                                              
export ORACLE_BASE="/opt/oracle"                                                                              
export ORACLE_HOME="$ORACLE_BASE/OraHome"                                                                     
                                                                                                              
case "$1" in                                                                                                  
        start)                                                                                                
                echo -n "Starting Oracle TNS listener"                                                        
                su - $ORACLE_OWNER -c $ORACLE_HOME/bin/lsnrctl start                                          
                su - $ORACLE_OWNER -c $ORACLE_HOME/bin/lsnrctl dbsnmp_start                                   
                echo ""                                                                                       
                echo -n "Starting Oracle database"                                                            
                su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbstart                                                
                echo  ""                                                                                      
        ;;                                                                                                    
        stop)                                                                                                 
                echo -n "Stopping Oracle database"                                                            
                su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbshut                                                 
                echo ""                                                                                       
                echo -n "Stopping Oracle TNS listener"                                                        
                su - $ORACLE_OWNER -c $ORACLE_HOME/bin/lsnrctl stop                                           
                su - $ORACLE_OWNER -c $ORACLE_HOME/bin/lsnrctl dbsnmp_stop                                    
                echo ""                                                                                       
        ;;                                                                                                    
        restart)                                                                                              
                echo -n "Restarting Oracle instances"                                                         
                $0 stop                                                                                       
                sleep 5                                                                                       
                $0 start                                                                                      
                echo ""                                                                                       
        ;;                                                                                                    
        *)                                                                                                    
                echo "Usage: /etc/init.d/oracle {start|stop|restart}"                                         
                exit 1                                                                                        
        ;;                                                                                                    
esac                                                                                                          
                                                                                                              
exit 0                                                                                                        

</code>
== Oracle 9 ==