日期:2014-05-16  浏览次数:20406 次

关闭开启数据库

###########windows###########
F:\iSAP\bin>SQLPLUS /NOLOG

SQL*Plus: Release 9.2.0.1.0 - Production on 星期四 12月 10 10:49:56 2009

Copyright (c) 1982, 2002, Oracle Corporation.? All rights reserved.

SQL> CONN SYS/ADMIN@ORA9I_TANGYQ.CHINA.HUAWEI.COM
ERROR:
ORA-28009: connection to sys should be as sysdba or sysoper


SQL> CONN SYS/ADMIN@ORA9I_TANGYQ.CHINA.HUAWEI.COM AS SYSDBA
已连接。
SQL> SHUTDOWN IMMEDIATE
数据库已经关闭。
已经卸载数据库。

SQL> startup
ORACLE 例程已经启动。

?


###########linux###########

login as: oracle
Using keyboard-interactive authentication.
Password:
Last login: Sat Dec 12 09:12:12 2009 from 127.0.0.1
oracle@rac4:/home/oracle> sqlplus / as sysdba;

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Dec 14 09:14:34 2009

Copyright (c) 1982, 2007, Oracle.? All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning option

SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

1 楼 aiyalhw 2009-12-24  
     Oracle可以直接在sqlplus环境中运行SQL语句:
          启动sqlplus
          $sqlplus /nolog或sqlplus username/password@servicename