Oracle Database Discussions

hello,

I have installed oracle 11.2 and after a reboot i have to run

lsnrctl start
sqlplus sys/change_on_install as sysdba

SQL> startup
ORACLE instance started.

Total System Global Area  636100608 bytes
Fixed Size                  1338392 bytes
Variable Size             348128232 bytes
Database Buffers          281018368 bytes
Redo Buffers                5615616 bytes
Database mounted.
Database opened.
SQL> quit

after this i can access my databases and they are registered services in the listener.

i have some scripts that are supposed to do this automatically but there not working, could somebody please tell me what is wrong with them.

the database i am trying to load on startup is speak and this is running on redhat 5.4

/etc/oratab

orcl:/home/oracle/app/oracle/product/11.2.0/dbhome_1:N
speak:/home/oracle/app/oracle/product/11.2.0/dbhome_1:Y

/etc/profile.d/oracle.sh

export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin

/etc/init.d/dbora

#!/bin/sh
# chkconfig: 345 30 10
# description: Oracle auto start-stop script.
#
# Set ORA_HOME to be equivalent to the $ORACLE_HOME
# from which you wish to execute dbstart and dbshut;
#
# Set ORA_OWNER to the user id of the owner of the
# Oracle database in ORA_HOME.
#
# Copied from http://www.oracle-base.com/articles/linux/AutomatingDatabaseStartu
pAndShutdownOnLinux.php
# but added the ". /etc/profile.d/oracle.sh" line for ORACLE_HOME - Bampy


. /etc/profile.d/oracle.sh



ORA_HOME=$ORACLE_HOME
OR_OWNER=oracle


if [ ! -f $ORACLE_HOME/bin/dbstart ]
then
        echo "Oracle startup: cannot start"
        exit
fi

case "$1" in
    'start')
        # Start the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values

        su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME"
        touch /var/lock/subsys/dbora
        #su - $ORA_OWNER -c "$ORA_HOME/bin/emctl start dbconsole"
        #su - $ORA_OWNER -c "$ORA_HOME/bin/isqlplusctl start"
        ;;
    'stop')
        # Stop the Oracle databases:
        # The following command assumes that the oracle login
        # will not prompt the user for any values
        #su - $ORA_OWNER -c "$ORA_HOME/bin/emctl stop dbconsole"
        #su - $ORA_OWNER -c "$ORA_HOME/bin/isqlplusctl stop"
        su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME"
        rm -f /var/lock/subsys/dbora
        ;;
esac