Oracle 的自动启动及停止设定
1.修改设定启动自动启动执行功能
# Vi /var/opt/oracle/oratab 修改设定启动自动启动执行功能
vghtpe:/oracle/v817:Y vghtpe - SID 是资料库名称
修改 oratab 后可以 oracle user 以dbstart指令启动oracle 资料库
,dbshut 指令关闭 oracle 资料库
2.在/etc/init.d 目录中建立dbora script
(1)dbora 档案内容
#!/bin/sh
# 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.
ORA_HOME=/oracle/v817
ORA_OWNER=oracle
if [! -f $ORA_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 &
;;
'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/dbshut &
;;
esac
(2)在$ORACLE_HOME\bin\dbstart 加入作业系统启动后,启动Oracle 监 听器程序
# Start lsnrctl TNSLSNR
$ORACLE_HOME/bin/lsnrctl start &
(3)在$ORACLE_HOME\bin\dbshut 加入作业系统关闭先关闭Oracle 监听器程序
# Stop lsnrctl TNSLSNR
$ORACLE_HOME/bin/lsnrctl stop &
3.检查 dbora user:group 是否为 root:sys 及是否是执行档
(1)# /etc/init.d
# ls –al dbora
-rw-r--r-- 1 root other 699 Jul 22 10:19 dbora
(2)修改方法
#su – root
#/etc/init.d
#chown –fhR root:sys dbora 更改 dbora user:group
#chmod 707 dbora 更改 dbora 为执行档
-rwx---rwx 1 root sys 699 Jul 22 10:19 dbora
4. 对执行等级目录( run-level script ) 建立符号连结(symbolic links )
至 /etc/init.d/执行等级 ( run-level script ) 能正确执行 script
(1)# ln -s /etc/init.d/dbora /etc/rc0.d/K10dbora
(2)# ls /etc/rc0.d/K10dbora
lrwxrwxrwx 1 root sys 17 Jul 22 10:43 K10dbora -> /etc/init.d/dbora
(3)# ln -s /etc/init.d/dbora /etc/rc3.d/S99dbora
(4)# ls –s /etc/rc3.d/S99dbora
lrwxrwxrwx 1 root sys 17 Jul 22 10:43 S99dbora -> /etc/init.d/dbora
5. Oracle 启动停止测试
(1)# /etc/init.d/dbora start – oracle 启动
(2)# ps -ef | grep oracle 检查oracle 启动
(3)# /etc/init.d/dbora stop oracle 停止
(4)# ps -ef | grep oracle 检查oracle 停止
6.以 root 登入重新开机,测试主机重开oracle 自动启动机制是否启动
# su – root
# sync;sync
# init 6
重新开机登入后
# ps -ef | grep oracle