環境: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 |