alter database close总结
[@more@]1、alter database close;在另外一个窗口打开则提示 C:Documents and SettingsAdministrator>sqlplus test/test SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 9月 17 08:32:54 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-00604: 递归 SQL 级别 1 出现错误 ORA-01219: 数据库未打开: 仅允许在固定表/视图中查询 请输入用户名: 请输入用户名: sys 输入口令: ERROR: ORA-28009: 应当以 SYSDBA 身份或 SYSOPER 身份建立 SYS 连接...我使用sys/system as sysdba可以建立链接了... 能够链接,但是动态性能视图等无法打开... ¨¦crit dans le message de news: 1137553779.476727.287770@o13g2000cwo.googlegroups. com... | in Oracle 9.2.0 | after start database , I used "alter databsse cloes", Don't use it, it's an internal statement. | it shows "ORA-01094 ALTER DATABASE CLOSE in progress. Connections not | permitted" | but it hasn't any session except backgroud process. | if I want to change status to nomount ,must I shutdown database first? Yes SQL> select status from v$instance; STATUS ------------------------ MOUNTED --数据库关闭以后处于mounted状态,但是不能直接open ,需要关闭以后重新启动
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-16196: 以前曾打开和关闭过数据库
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/450962/viewspace-1027043/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/450962/viewspace-1027043/