[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
不过启动系统的时候可能会有报错,但数据库和监听都能正常启动,应该没什么影响。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29618264/viewspace-2089058/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29618264/viewspace-2089058/