ORACLE隨Linux開機啟動
環境:VM+redhat9+oracle9.2
1.修改/etc/oratab內容 ORACLE_SID:/u01/app/oracle/product/10.2.0/db_1:N改為如下內容
# add below content
#$ORACLE_SID:$ORACLE_HOME:Y
demo:/u01/app/oracle/product/9.2.0:Y
2.修改/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
add below content
su - oracle -c "/bin/sh /home/oracle/dbstart.sh"
3 new file dbstart.sh vi /home/oracle/dbstart.sh的內容 export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/9.2.0
export ORACLE_SID=demo
start the listener
/u02/oracle/ora/bin/lsnrctl start
#start the db
sqlplus "/as sysdba" <<eof
startup
exit
eof
問題:
當開閉linux時,oracle也會關閉,對事務有哪些影響