数据库可以正常操作,比如创建用户,执行DML语句等,就是删除用户时会报这个异常,此时用户下的对象都已经被删掉了。
SQL> conn / as sysdba
Connected.
SQL> select du.username,du.account_status,du.created,du.default_tablespace from dba_users du;USERNAME ACCOUNT_STATUS CREATED DEFAU
------------------------------ -------------------------------- ---------- -----
TEST_1228 LOCKED 02-12月-09 DTV_U
TEST_0104 LOCKED 06-7月 -10 DTV_U37 rows selected.SQL> drop user TEST_1228 cascade;
drop user TEST_1228 cascade
*
ERROR at line 1:
ORA-03113: end-of-file on communication channelORA-03113 end-of-file on communication channelCause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.In addition, this message could occur when any of the following statements/commands have been issued:ALTER SYSTEM KILL SESSION ... IMMEDIATE
ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE
SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL
Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of Oracle Support Services.不知道是什么引起的连接中断。有谁遇到这个问题吗?
SQL> conn / as sysdba
Connected.
SQL> select du.username,du.account_status,du.created,du.default_tablespace from dba_users du;USERNAME ACCOUNT_STATUS CREATED DEFAU
------------------------------ -------------------------------- ---------- -----
TEST_1228 LOCKED 02-12月-09 DTV_U
TEST_0104 LOCKED 06-7月 -10 DTV_U37 rows selected.SQL> drop user TEST_1228 cascade;
drop user TEST_1228 cascade
*
ERROR at line 1:
ORA-03113: end-of-file on communication channelORA-03113 end-of-file on communication channelCause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8 two-task software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.In addition, this message could occur when any of the following statements/commands have been issued:ALTER SYSTEM KILL SESSION ... IMMEDIATE
ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE
SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL
Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of Oracle Support Services.不知道是什么引起的连接中断。有谁遇到这个问题吗?
你什么版本ORACLE,BUG的可能性比较大。
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Solaris: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production^_^
在oem看不到这两个被我drop的用户了。
http://blog.csdn.net/mustbelove/archive/2007/07/20/1700289.aspx
Errors in file /oracle/admin/dtv/udump/dtv_ora_12509.trc:
ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []
Fri May 1 02:41:02 2009
Errors in file /oracle/admin/dtv/udump/dtv_ora_12509.trc:
ORA-07445: exception encountered: core dump [0000000100235524] [SIGBUS] [Invalid address alignment] [0x000102E63] [] []
ORA-00600: internal error code, arguments: [qmxiUnpPacked2], [121], [], [], [], [], [], []
嗯,我去metalink看看