第3步,OPEN数据库:
SQL> alter database open;
约等一会儿,在alert日志里面可以看到:
Mon Sep 6 15:44:41 2010
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Sep 6 15:44:41 2010
Database Characterset is ZHS16GBK
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Sep 6 15:44:41 2010
Database Characterset is ZHS16GBK
在gdb的输出可以看到:
Breakpoint 1, 0x0a3d404d in kokiasg ()
第4步,在gdb那里中止OPEN:
(gdb) kill
Kill the program being debugged? (y or n) y
(gdb) quit
Kill the program being debugged? (y or n) y
(gdb) quit
sqlplus会提示:
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
这一次,Instance并没有terminated。只是Server process被KILL了。