ORACLE随Linux开机启动
第一种方法:
1.修改/etc/rc.local文件加上下的红色内容
####################################
location :/etc/rc.local
####################################
#!/bin/sh
#
# This script. will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don't
# want to do the full Sys V style. init stuff.
touch /var/lock/subsys/local
su - oracle -c "/bin/sh /home/oracle/dbstart.sh"
2. dbstart.sh的内容
export ORACLE_BASE=/u02/oracle
export ORACLE_HOME=/u02/oracle/ora
export ORACLE_SID=test
sqlplus '/as sysdba'<
startup;
exit
eof
/u02/oracle/ora/bin/lsnrctl start
3. 修改/etc/oratab内容
ORACLE_SID:/u01/app/oracle/product/10.2.0/db_1:N改为如下内容
ORACLE_SID:/u01/app/oracle/product/10.2.0/db_1:Y
#
# chkconfig: 35 95 1
# description: init script. to start/stop oracle database 10g, TNS listener, EMS
# match these values to your environment:
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/10.2.0/db_1
export ORACLE_TERM=xterm
export PATH=/home/oracle/bin:$ORACLE_HOME/bin:$PATH:.
export NLS_LANG='croatian_croatia.ee8iso8859p2'
export ORACLE_SID=rpcbdb02
export DISPLAY=localhost:0
export ORACLE_USER=oracle
case $1 in
start)
su - "$ORACLE_USER"< lsnrctl start
sqlplus /nolog< connect / as sysdba
startup
EOS
EOO
;;
su - "$ORACLE_USER"< lsnrctl stop
sqlplus /nolog< connect / as sysdba
shutdown immediate
EOS
EOO
;;
status)
su - "$ORACLE_USER"< lsnrctl status
emctl status dbconsole
EOO
;;
echo "Usage: $0 {start|stop}"
;;
esac
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7419833/viewspace-201669/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7419833/viewspace-201669/