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
