Forums | Admin Discussion Forums: open-discussion Start New Thread Nested Flat Threaded Ultimate Show 25 Show 50 Show 75 Show 100   By: Kubo Takehiro RE: Which method we should use? [ reply ]   2006-11-04 05:27 ruby-oci8 and any other language's bindings will not have the ability to startup and shutdown the Oracle. You must use sqlplus or scripts which use sqlplus as Lori Olson has posted. It may be availale in future. One of the new features in Oracle Call Interface Release 10.2 is "Database startup and shutdown can now be done from OCI". We can do it in ruby if ruby-oci8 supports it. But I have no plan to do it now, because it is available only when using Oracle 10.2 or later. By: Kubo Takehiro RE: Which method we should use? [ reply ]   2006-11-04 05:26 ruby-oci8 and any other language's bindings will not have the ability to startup and shutdown the Oracle. You must use sqlplus or scripts which use sqlplus as Lon Olson has posted. It may be availale in future. One of the new features in Oracle Call Interface Release 10.2 is "Database startup and shutdown can now be done from OCI". We can do it in ruby if ruby-oci8 supports it. But I have no plan to do it now, because it is available only when using Oracle 10.2 or later. By: Lori Olson RE: Which method we should use? [ reply ]   2006-11-03 15:51 Depends on where Oracle is installed. On a Linux machine, you use the init script in /etc/init.d that is installed with Oracle - [root@zooie init.d]# ./oracle-xe Usage: ./oracle-xe {start|stop|restart|force-reload|configure|status|enable|disable} By: Marble Zhong Which method we should use? [ reply ]   2006-11-03 09:52 Which method we should use the admin the Oracle, such as the shutdown, shutdown immediate, startup and so on. Thanks.