STEP1: Script

[oracle@okairdb scripts]$ cat startup.sh

if [ -f ~/.bashrc ];then

      . ~/.bashrc

fi

export SYSDATE=`date +%Y%m%d`

echo $SYSDATE

export ORACLE_SID=OKAIRDB

sqlplus sys/oracle as sysdba 1>/dbbak/scripts/logs/dbstart_$SYSDATE.log 2>&1 <

!/app/okair/oracle/product/11.2.0.4/db_1/bin/lsnrctl start

startup;

!/app/okair/oracle/product/11.2.0.4/db_1/bin/lsnrctl status

exit;

EOF

#cat /dbbak/scripts/logs/dbstart_$SYSDATE.log

exit

STEP2: /etc/oratab

[oracle@okairdb scripts]$ cat /etc/oratab

# This file is used by ORACLE utilities.  It is created by root.sh

# and updated by either Database Configuration Assistant while creating

# a database or ASM Configuration Assistant while creating ASM instance.

# A colon, ':', is used as the field terminator.  A new line terminates

# the entry.  Lines beginning with a pound sign, '#', are comments.

#

# Entries are of the form:

#   $ORACLE_SID:$ORACLE_HOME::

#

# The first and second fields are the system identifier and home

# directory of the database respectively.  The third filed indicates

# to the dbstart utility that the database should , "Y", or should not,

# "N", be brought up at system boot time.

#

# Multiple entries with the same $ORACLE_SID are not allowed.

#

#

OKAIRDB:/app/okair/oracle/product/11.2.0.4/db_1:Y

STEP3: /etc/rc.d/rc.local

[oracle@okairdb scripts]$ cat /etc/rc.d/rc.local

#!/bin/sh

#

# This script will be executed *after* all the other init scripts.

# You can put your own initialization stuff in here if you don't

# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local

su oracle -lc  /dbbak/scripts/startup.sh