Oracle 11g中SYS连接阻止关闭数据库（三）
2008-8-28 选择字号：
大 |
中 |
小
而920版本的数据库是没有这个问题的：
[oracle@bjtest ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on 星期六 8月 23 04:14:36 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
已连接到空闲例程。
SQL> host
[oracle@bjtest ~]$ ps -ef|grep ora
root 3804 3792 0 Jul18 ? 00:00:29 hald-addon-storage: polling /dev/hda
root 26417 26385 0 04:14 pts/1 00:00:00 su - oracle
oracle 26418 26417 0 04:14 pts/1 00:00:00 -bash
oracle 26451 26418 0 04:14 pts/1 00:00:00 sqlplus
oracle 26452 26451 0 04:14 ? 00:00:00 oraclebjtest (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 26453 26451 0 04:14 pts/1 00:00:00 /bin/bash
oracle 26481 26453 0 04:14 pts/1 00:00:00 ps -ef
oracle 26482 26453 0 04:14 pts/1 00:00:00 grep ora
[oracle@bjtest ~]$ exit
exit
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 9415145752 bytes
Fixed Size 755992 bytes
Variable Size 822083584 bytes
Database Buffers 8589934592 bytes
Redo Buffers 2371584 bytes数据库装载完毕。数据库已经打开。
SQL> host
[oracle@bjtest ~]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on 星期六 8月 23 04:15:08 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> shutdown immediate数据库已经关闭。已经卸载数据库。
ORACLE 例程已经关闭。
SQL> exit从Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production中断开
[oracle@bjtest ~]$ exit
exit
SQL> exit
ERROR: |
Oracle 11g中SYS连接阻止关闭数据库
Oracle 11g中SYS连接阻止关闭数据库（一）
Oracle 11g中SYS连接阻止关闭数据库（二）
Oracle 11g中SYS连接阻止关闭数据库（三）
原文出处：http://space.itpub.net/batch.viewlink.php?itemid=369993