linux下oracle设置开机自启动实现方法.docxVIP

在CentOS 6.3下安装完Oracle 10g R2，重开机之后，你会发现Oracle没有自行启动，这是正常的，因为在Linux下安装Oracle的确不会自行启动，必须要自行设定相关参数，首先先介绍一般而言如何启动oracle。以下分为 手动启动oracle 和 开机自动启动 oracle 手动启动Oracle数据库一、在Linux下启动Oracle登录到CentOS，切换到oracle用户权限# su – oracle接着输入：$ sqlplus /as sysdba原本的画面会变为SQL接着请输入SQL startup就可以正常的启动数据库了。另外停止数据库的指令如下：SQL shutdown immediate二、检查Oracle DB监听器是否正常回到终端机模式，输入：$ lsnrctl status检查看看监听器是否有启动如果没有启动，可以输入：$ lsnrctl start启动监听器SQL conn sys@orcl as sysdba然后输入密码，sys以sysdba身份登入数据库。三、启动emctl另外也可以发现http://localhost.localdomain:1158/em 目前是没有反应的，这边要另外启动，启动的指令如下：$ emctl start dbconsole这个指令运行时间较长，执行完的画面如下：手动启动Oracle数据库完毕，系统自行启动Oracle数据库四、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: 35 80 10?# 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/102?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:?echo Starting Oracle Databases ... ?echo /var/log/oracle?date + %T %a %D : Starting Oracle Databases as part of system up. /var/log/oracle?echo /var/log/oracle?su - $ORA_OWNER -c $ORA_HOME/bin/dbstart /var/log/oracle?echo Done?# Start the Listener:?echo Starting Oracle Listeners ... ?echo /var/log/oracle?date + %T %a %D : Starting Oracle Listeners as part of system up. /var/log/oracle?echo /var/log/oracle?su - $ORA_OWNER -c $ORA_HOME/bin/lsnrctl start /var/log/oracle?echo Done.?echo /var/log/oracle?date + %T %a %D : Finished. /var/log/oracle?echo /var/log/oracle?touch /var/lock/subsys/oracle?stop)?# Stop the Oracle Listener:?echo Stoping Oracle Listeners ... ?echo /var/log/oracle?date + %T %a %D : Stopi