red hat el 3上装了oracle 9204,如何在系统启动时启动oracle？

Question

red hat el 3上面装了oracle 9204,怎样能在系统启动时让oracle实例自动启动？

Answer 1

修改/etc/oratab将
*:/opt/ora9/product/9.2:N
orcl:/opt/ora9/product/9.2:N
修改为Y

#chgrp dba /etc/init.d/dbora
#chmod 750 /etc/init.d/dbora
#chkconfig --add dbora

root身份
#vi /etc/rc.local 加入
su - oracle -c 'lsnrctl start'
su - oracle -c 'dbstart'

Answer 2

#chgrp dba /etc/init.d/dbora
#chmod 750 /etc/init.d/dbora
#chkconfig --add dbora
干吗用的？

Answer 3

我是根据如下设置的，不好用！没有任何反应！
$ORACLE_HOME/bin/dbstart and $ORACLE_HOME/bin/dbshut

You can also use $ORACLE_HOME/bin/dbstart to startup the database, and $ORACLE_HOME/bin/dbshut to shutdown the database. You can place $ORACLE_HOME/bin/dbstart into the /etc/rc.d/rc.local boot script to automatically bring up the database at system boot time. To get $ORACLE_HOME/bin/dbstart and $ORACLE_HOME/bin/dbshut working, you need to change the third field for your Oracle SID in /etc/oratab from "N" to "Y".

For example, for the Oracle SID "test" I changed the line in /etc/oratab from:

test:/opt/oracle/product/9.2.0:N
to read:
test:/opt/oracle/product/9.2.0:Y

In some cases for 9.2.0 I also had to copy the init file for my SID "test" from /opt/oracle/admin/test/pfile to $ORACLE_HOME/dbs to get dbstart and dbshut working:
cp /opt/oracle/admin/test/pfile/inittest.ora.642002224936 $ORACLE_HOME/dbs/inittest.ora
But first make sure if your init file already exists in $ORACLE_HOME/dbs!

你的好像比我的强力一些，但是也不好用，不过我没有执行这些操作：
#chgrp dba /etc/init.d/dbora
#chmod 750 /etc/init.d/dbora
#chkconfig --add

Answer 4

发表于: 2004-10-13 13:10    发表主题:   

--------------------------------------------------------------------------------

修改/etc/oratab将
*:/opt/ora9/product/9.2:N
orcl:/opt/ora9/product/9.2:N
修改为Y

root身份
#vi /etc/rc.local 加入
su - oracle -c 'lsnrctl start'
su - oracle -c 'dbstart'

以上脚本就可以了，谢谢，不过我如果想在关机的时候把实例停掉，应该写在哪里？