oracle11g启动是，一个有趣的错误，只做记录，没有深究，不知道是否bug

windows8 + oracle11.2.0.1 64bit

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

首先说明下，数据库没有问题，正常 shutdown immediate；

实验如下：

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 3407261696 bytes
Fixed Size 2180504 bytes
Variable Size 1895828072 bytes
Database Buffers 1493172224 bytes
Redo Buffers 16080896 bytes

SQL> alter database mount;
Database altered.
SQL>
SQL>
SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'YY
-------------------
2013-01-31 11:31:34

SQL>
SQL>
SQL> select * from dual;

ADDR INDX INST_ID D
---------------- ---------- ---------- -
00000000077E5E18 0 1 X

SQL>
SQL>
SQL>
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00942: table or view does not exist
进程 ID: 3052
会话 ID: 125 序列号: 3
SQL>
SQL>
SQL>
SQL> startup nomount;
ORA-24324: 未初始化服务句柄
ORA-01041: 内部错误, hostdef 扩展名不存在
SQL> conn / as sysdba;
Connected to an idle instance.
SQL>
SQL>
SQL> startup nomount;
ORACLE instance started.

Total System Global Area 3407261696 bytes
Fixed Size 2180504 bytes
Variable Size 1895828072 bytes
Database Buffers 1493172224 bytes
Redo Buffers 16080896 bytes
SQL>
SQL>
SQL>
SQL>
SQL> alter database mount;
Database altered.
SQL>
SQL>
SQL> alter database open;
Database altered.
SQL>

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/60144/viewspace-1060180/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/60144/viewspace-1060180/