[root@ORACLE init.d]# pwd
/etc/init.d
-rwxr-xr-x 1 root root 1275 lis 10 12:22 dbora
-rwxr-xr-x 1 root root 1137 pro 2 2011 dboraem
[oracle@ORACLE ~]$ cat /etc/oratab
orcl12c:/opt/oracle/app/12101:Y
cat /etc/init.d/dbora
[root@ORACLE init.d]# cat dbora
#!/bin/bash
#
# dbora
# Oracle database startup script
#
# For Red Hat chkconfig
# chkconfig: 345 50 50
# description: Oracle 12c startup script
ORACLE_HOME=/opt/oracle/app/12101
ORACLE=oracle
ORACLE_SID=orcl12c
export ORACLE_HOME
export ORACLE
export ORACLE_SID
status=0
LOG=$ORACLE_HOME/startup.log
su $ORACLE -c „touch $LOG; chmod a+r $LOG“
case $1 in
‚start‘)
su $ORACLE -c „echo ‚***‘ `date` – Oracle database startup ‚***‘ >>$LOG“
echo „Starting Oracle Net Listener“
su $ORACLE -c „$ORACLE_HOME/bin/lsnrctl start >>$LOG 2>&1“
status=$(($status + $?))
echo „Starting Oracle databases“
su $ORACLE -c „$ORACLE_HOME/bin/dbstart >>$LOG 2>&1“
status=$(($status + $?))
;;
‚stop‘)
su $ORACLE -c „echo ‚***‘ `date` – Oracle database shutdown ‚***‘ >>$LOG“
echo „Stopping Oracle Net Listener“
su $ORACLE -c „$ORACLE_HOME/bin/lsnrctl stop >>$LOG 2>&1“
status=$(($status + $?))
echo „Stopping Oracle databases“
su $ORACLE -c „$ORACLE_HOME/bin/dbshut >>$LOG 2>&1“
status=$(($status + $?))
;;
*)
printf „\nusage: $0 {start|stop}\n\n“
exit 1
;;
esac
if [ „$status“ -eq 0 ]; then
echo „Operation successful“
else
echo „Operation failed“
fi
exit $status
Kontrola spouštění scriptů
[root@ORACLE init.d]# /sbin/chkconfig –list | grep ora
dbora 0:off 1:off 2:off 3:on 4:on 5:on 6:off
dboraem 0:off 1:off 2:off 3:on 4:on 5:on 6:off
Vypnutí automatického spouštění
[root@ORACLE init.d]# /sbin/chkconfig –del dboraem
[root@ORACLE init.d]# /sbin/chkconfig –list | grep ora
dbora 0:off 1:off 2:off 3:on 4:on 5:on 6:off
[root@ORACLE init.d]# mv dboraem dboraem.11g
Případně zapnutí
[root@Oracle ~]# /sbin/chkconfig –list | grep ora
dbora 0:off 1:off 2:off 3:off 4:off 5:off 6:off
[root@Oracle ~]# /sbin/chkconfig –add dbora
[root@Oracle ~]# /sbin/chkconfig –list | grep ora
dbora 0:off 1:off 2:off 3:off 4:off 5:off 6:off
[root@Oracle ~]# /sbin/chkconfig –level 345 dbora on
[root@Oracle ~]# /sbin/chkconfig –list | grep ora
dbora 0:off 1:off 2:off 3:on 4:on 5:on 6:off