[ORACLE 11G] Automatic Oracle startup on AIX

1/ Make a script to stop/start Oracle DB and grant execution:

#vi /etc/oracleservice.sh:

####################################

#!/bin/ksh
#
# Description: Starts and stops the Oracle database and listeners
case "$1" in
  start)
        echo "Starting Oracle Databases: "
        su - oracle -c dbstart
        echo "Done."
        echo "Starting Oracle Listeners: "
        su - oracle -c "lsnrctl start"
        echo "Done."
        ;;
  stop)
        echo "Shutting Down Oracle Listeners: "
        su - oracle -c "lsnrctl stop"
        echo "Done."
        echo "Shutting Down Oracle Databases: "
        su - oracle -c dbshut
        echo "Done."
        ;;
  restart)
        echo "Restarting Oracle Databases: "
        su - oracle -c dbstop
        su - oracle -c dbstart
        echo "Done."
        echo "Restarting Oracle Listeners: "
        su - oracle -c "lsnrctl stop"
        su - oracle -c "lsnrctl start"
        echo "Done."
        ;;
  *)
        echo "Usage: oracle {start|stop|restart}"
        exit 1
esac

####################################


#chmod a+x /etc/oracleservice.sh

2/ Define new service start with IBM AIX OS startup:


vi /etc/rc.oracle

####################################

#!/bin/ksh
/etc/oracleservice.sh start

####################################

chmod a+x /etc/rc.oracle


3/ Create inittab entry:

#mkitab oracleservice:2:wait:/etc/rc.oracle 2>&1 | alog -tboot > /dev/console

4/ config oratab point to database need start:


#vi /etc/oratab

HELPDESK:/u01/app/oracle/product/11.2.0/dbhome_1:Y