Linux Oracle服务启动停止脚本与开机自启动.docxVIP

在Redhat 5 下安装完Oracle10g，每次重新开机后，都要手动的启动监听服务和Oracle数据库。Linux下安装Oracle是不会自动运行的，需要自行设定参数。手动启动Oracle相关服务的命令启动监听服务通过Oracle用户登录Oracle服务器cd $ORACLE_HOME/binls ls*找到lsnrctl 命令执行 lsnrctl start启动OracleOracle用户登录Sqlplus “/as sysdba”Startup就可以正常启动数据库了设置开机自动启动Oracle数据库1. 修改Oracle系统配置文件：/etc/oratab，只有这样，Oracle 自带的dbstart和dbshut才能够发挥作用。# vi /etc/orataborcl:/opt/oracle/102:Y# Entries are of the form:# $ORACLE_SID:$ORACLE_HOME:N|Y:2. 在 /etc/init.d/ 下创建文件oracle，内容如下：#!/bin/sh# chkconfig: 358010# description: Oracle auto start-stop script.## 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=/opt/oracle/102ORA_OWNER=oracleif [ ! -f $ORA_HOME/bin/dbstart ]thenechoOracle startup: cannot start exitficase$1instart)# Start the Oracle databases:echoStarting Oracle Databases ... echo------------------------------------------------- /var/log/oracledate + %T %a %D : Starting Oracle Databases as part of system up. /var/log/oracleecho------------------------------------------------- /var/log/oraclesu - $ORA_OWNER -c $ORA_HOME/bin/dbstart /var/log/oracleechoDone# Start the Listener:echoStarting Oracle Listeners ... echo------------------------------------------------- /var/log/oracledate + %T %a %D : Starting Oracle Listeners as part of system up. /var/log/oracleecho------------------------------------------------- /var/log/oraclesu - $ORA_OWNER -c $ORA_HOME/bin/lsnrctl start /var/log/oracleechoDone.echo------------------------------------------------- /var/log/oracledate + %T %a %D : Finished. /var/log/oracleecho------------------------------------------------- /var/log/oracletouch /var/lock/subsys/oracle;;stop)# Stop the Oracle Listener:echoStoping Oracle Listeners ... echo------------------------------------------------- /var/log/oracledate + %T %a %D : Stoping Oracle Listener as part of system down. /var/log/oracleecho-----------------------