若手动启动数据库的同时监听器没有启动(即启动数据库时自动启动监听器,停止数据库时停止监听器),则需要修改dbstart脚本文件:
[oracle@localhost ~]$ cd /usr/oracle/app/product/11.2.0/dbhome_1/bin
[oracle@localhost ~]$ vi dbstart
找到下面的代码段
# First argument is used to bring up Oracle Net Listener ORACLE_HOME_LISTNER=$1 ### 需要将此处的 ORACLE_HOME_LISTNER=$1 修改为 ORACLE_HOME_LISTNER=$ORACLE_HOME if [ ! $ORACLE_HOME_LISTNER ] ; then echo "ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener" echo "Usage: $0 ORACLE_HOME"
同样,修改dbshut:
完成后配置创建Linux启动脚本oracle,进行如下命令:[oracle@localhost ~]$ vi dbshut # The this to bring down Oracle Net Listener ORACLE_HOME_LISTNER=$1 ### 需要将此处的 ORACLE_HOME_LISTNER=$1 修改为 ORACLE_HOME_LISTNER=$ORACLE_HOME if [ ! $ORACLE_HOME_LISTNER ] ; then echo "ORACLE_HOME_LISTNER is not SET, unable to auto-stop Oracle Net Listener" echo "Usage: $0 ORACLE_HOME"
[oracle@localhost bin]$ cd /etc/init.d/ [oracle@localhost init.d]$ vi oracle
将下面的内容复制到里面:
#!/bin/sh # chkconfig: 345 61 61 # description: Oracle 11g AutoRun Services # /etc/init.d/oracle # # Run-level Startup script for the Oracle Instance, Listener, and # Web Interface export ORACLE_HOME=/usr/oracle/app/product/11.2.0/dbhome_1 export ORACLE_SID=KDB export PATH=$PATH:$ORACLE_HOME/bin ORA_OWNR="oracle" # if the executables do not exist -- display error if [ ! -f $ORACLE_HOME/bin/dbstart -o ! -d $ORACLE_HOME ] then echo "Oracle startup: cannot start" exit 1 fi # depending on parameter -- startup, shutdown, restart # of the instance and listener or usage display case "$1" in start) # Oracle listener and instance startup su $ORA_OWNR -lc $ORACLE_HOME/bin/dbstart echo "Oracle Start Succesful!OK." ;; stop) # Oracle listener and instance shutdown su $ORA_OWNR -lc $ORACLE_HOME/bin/dbshut echo "Oracle Stop Succesful!OK." ;; reload|restart) $0 stop $0 start ;; *) echo $"Usage: `basename $0` {start|stop|reload|reload}" exit 1 esac exit 0
赋予脚本可执行权限:
oracle@localhost init.d]$ chmod 750 /etc/init.d/oracle
启用脚本并添加到服务:
[oracle@localhost init.d]$ chkconfig --level 345 oracle on [oracle@localhost init.d]$ chkconfig --add oracle
注意:
这样的脚本一般不会启动实例,如果想让实例也随脚本一起启动的话,就需要修改文件/etc/oratab
如果这个文件不存在,就要运行脚本文件产生它。
[root@localhost init.d]vi /etc/oratab
# This file is used by ORACLE utilities. It is created by root.sh # and updated by the Database Configuration Assistant when creating # a database. # A colon, ':', is used as the field terminator. A new line terminates # the entry. Lines beginning with a pound sign, '#', are comments. # # Entries are of the form: # $ORACLE_SID:$ORACLE_HOME:<N|Y>: # # The first and second fields are the system identifier and home # directory of the database respectively. The third filed indicates # to the dbstart utility that the database should , "Y", or should not, # "N", be brought up at system boot time. # # Multiple entries with the same $ORACLE_SID are not allowed. # # KDB:/usr/oracle/app/product/11.2.0/dbhome_1:Y
这样将oracle 实例KDB改为自启动:Y 就可以实现ORACLE 开机时自启动了..