oracle开机启动监听,LINUX开机自动启动ORACLE数据库和监听脚本

[root@node1 ~]# 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::

#

# 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.

#

#

将N给为Y：

node1:/u01/app/oracle/product/10.2.0/db_1:Y

[root@node1 ~]# chmod 755 /etc/oratab

[root@node1 ~]# chown oracle:root /etc/oratab

[root@node1 ~]# vi /etc/rc.d/init.d/oracle

#!/bin/bash

##############################################################

# Script. Function: Auto start oracle instance and listener. #

# Script. Name:     oracle                                   #

##############################################################

case "$1" in

start)

echo "Starting Oracle Database..."

su - oracle -c "dbstart"

echo "Done."

echo "Starting Oracle Listener..."

su - oracle -c "lsnrctl start"

echo "Done."

touch /var/lock/subsys/oracle

;;

stop)

echo "Shutting down Oracle Listener..."

su - oracle -c "lsnrctl stop" >> /var/log/oracle

echo "Done."

rm -f /var/lock/subsys/oracle

echo "Shutting down Oracle Database..."

su - oracle -c "dbshut"

echo "Done."

echo ""

;;

restart)

$0 stop

$0 start

;;

*)

exit 1

esac

[root@node1 ~]# chmod 755 /etc/rc.d/init.d/oracle

[root@node1 ~]# ln -s ../init.d/oracle /etc/rc.d/rc2.d/S87oracle

[root@node1 ~]# ln -s ../init.d/oracle /etc/rc.d/rc3.d/S87oracle

[root@node1 ~]# ln -s ../init.d/oracle /etc/rc.d/rc5.d/S87oracle

不过启动系统的时候可能会有报错，但数据库和监听都能正常启动，应该没什么影响。