Oracle 10G R2一次奇怪的START/SHUTDOWN经历

一次奇怪的数据库启动和关闭经历。

 

SQL> conn / as sysdba
Connected to an idle instance.

SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown abort  
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 2499805184 bytes
Fixed Size                  1262368 bytes
Variable Size            1073745120 bytes
Database Buffers         1409286144 bytes
Redo Buffers               15511552 bytes
staDatabase mounted.
 
Database opened.
SQL> SQL> 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>