1.用root用户修改/etc/oratab 文件
改为:
ora10:/DBSoft/app/oracle/product/10.2.0/db_1:Y
2.用Oracle用户修改$ORACLE_HOME/bin/dbstart文件
vi dbstart
/ORACLE_HOME_LISTNER # 找到ORACLE_HOME_LISTNER
修改成
ORACLE_HOME_LISTNER=/DBSoft/app/oracle/product/10.2.0/db_1
或者直接修改成:
ORACLE_HOME_LISTNER=$ORACLE_HOME
3. 编写开机自启动服务脚本:
vi /etc/init.d/oracle 或 /etc/rc.d/init.d/oracle
#!/bin/bash
# chkconfig: 345 99 10
# description: Startup Script for Oracle Databases
# /etc/rc.d/init.d/oracle
export ORACLE_BASE=/DBSoft/app/oracle/
export ORACLE_HOME=/DBSoft/app/oracle/product/10.2.0/db_1
export ORACLE_SID=ora10
export PATH=$PATH:$ORACLE_HOME/bin
case "$1" in
start)
su oracle -c $ORACLE_HOME/bin/dbstart
touch /var/lock/oracle
echo "OK"
;;
stop)
rm -f /var/lock/Oracle
echo "OK"
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo "Usage: 'basename $0' start|stop|restart|reload"
exit 1
esac
exit 0
改变文件属性:chmod 755 /etc/init.d/oracle
4. 建立启动服务连接
ln -s ../init.d/oracle /etc/rc.d/rc2.d/S99oracle
ln -s ../init.d/oracle /etc/rc.d/rc3.d/S99oracle
ln -s ../init.d/oracle /etc/rc.d/rc5.d/S99oracle
5.重新启动或停止
--------------------------------------------------------------------------------
ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle # 停止
vi /etc/oratab
ora10:/DBSoft/app/oracle/product/10.2.0/db_1:N改为:
ora10:/DBSoft/app/oracle/product/10.2.0/db_1:Y
2.用Oracle用户修改$ORACLE_HOME/bin/dbstart文件
vi dbstart
/ORACLE_HOME_LISTNER # 找到ORACLE_HOME_LISTNER
修改成
ORACLE_HOME_LISTNER=/DBSoft/app/oracle/product/10.2.0/db_1
或者直接修改成:
ORACLE_HOME_LISTNER=$ORACLE_HOME
3. 编写开机自启动服务脚本:
vi /etc/init.d/oracle 或 /etc/rc.d/init.d/oracle
#!/bin/bash
# chkconfig: 345 99 10
# description: Startup Script for Oracle Databases
# /etc/rc.d/init.d/oracle
export ORACLE_BASE=/DBSoft/app/oracle/
export ORACLE_HOME=/DBSoft/app/oracle/product/10.2.0/db_1
export ORACLE_SID=ora10
export PATH=$PATH:$ORACLE_HOME/bin
case "$1" in
start)
su oracle -c $ORACLE_HOME/bin/dbstart
touch /var/lock/oracle
echo "OK"
;;
stop)
echo -n "Shutdown Oracle: "
su oracle -c '$ORACLE_HOME/bin/lsnrctl stop'
su oracle -c $ORACLE_HOME/bin/dbshutrm -f /var/lock/Oracle
echo "OK"
;;
reload|restart)
$0 stop
$0 start
;;
*)
echo "Usage: 'basename $0' start|stop|restart|reload"
exit 1
esac
exit 0
改变文件属性:chmod 755 /etc/init.d/oracle
4. 建立启动服务连接
ln -s ../init.d/oracle /etc/rc.d/rc2.d/S99oracle
ln -s ../init.d/oracle /etc/rc.d/rc3.d/S99oracle
ln -s ../init.d/oracle /etc/rc.d/rc5.d/S99oracle
或
chkconfig --add oracle #自动做上述步骤
5.重新启动或停止
--------------------------------------------------------------------------------
ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle # 停止
ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle # 重新启动
6.检测
service oracle stop
service oracle start
service oracle restart
用ps -ef 查看后台oracle进程
最后 用 reboot 和 halt 检查