急急急 如何在SQL*Plus中，用命令行关闭和开启Oracle数据库服务器？

来源：百度知道 编辑：UC知道 时间：2024/06/05 08:27:54
高人帮忙啊

1. Set up your Oracle environment.

If you are using Windows operating system, do the followings:

set ORACLE_HOME=C:\oracle\product\10.2.0.1.0
set ORACLE_SID=xxxxxxx

(Change C:\oracle\product\10.2.0.1.0 to your own Oracle Home)
(Change xxxxxxx to your database name)

If you are using UNIX (e.g. HP-UX) operating system, do the followings:

export ORACLE_SID=xxxxxxx
export ORACLE_HOME=/u01/app/oracle/product/10.2.0.1.0

(Change /u01/app/oracle/product/10.2.0.1.0 to your own Oracle Home)
(Change xxxxxxx to your database name)

2. connect as sysdba

Start SQL*Plus, and connect to the database as sysdba. Use the following command:

connect sys/aaaaaaa@bbbbbbb as sysdba

(aaaaaaa is your password for sys)
(bbbbbbb is the connection string defined in tnsnames.ora)

3. Shut down or start up database.

To shut down, us