1、实验环境
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
2、在会话1中delete tab$表
SQL> select count(*) from tab$;
COUNT(*)
----------
4496
SQL> delete from tab$;
4496 rows deleted.
SQL> commit;
Commit complete.
SQL> select count(*) from tab$;
COUNT(*)
----------
0
3、在会话2中尝试登陆数据库报错如下
[oracle@sourcedb ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 7 15:24:16 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn / as sysdba
ERROR:
ORA-01075: you are currently logged on
SQL> conn / as sysdba
ERROR:
ORA-01075: you are currently logged on
此时alert报错:
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2153.trc (incident=19211):
ORA-00600: internal error code, arguments: [18061], [1403], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_19211/orcl_ora_2153_i19211.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sun May 07 15:25:34 2017
Dumping diagnostic data in directory=[cdmp_20170507152534], requested by (instance=1, osid=2153), summary=[incident=19210].
Sun May 07 15:25:41 2017
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_2159.trc (incident=18228):
ORA-00600: internal error code, arguments: [16201], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_18228/orcl_m000_2159_i18228.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_2159.trc:
ORA-00600: internal error code, arguments: [16201], [], [], [], [], [], [], [], [], [], [], []
Dumping diagnostic data in directory=[cdmp_20170507152543], requested by (instance=1, osid=2159 (M000)), summary=[incident=18228].
4、在会话1中重启数据库
SQL> shutd
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
2、在会话1中delete tab$表
SQL> select count(*) from tab$;
COUNT(*)
----------
4496
SQL> delete from tab$;
4496 rows deleted.
SQL> commit;
Commit complete.
SQL> select count(*) from tab$;
COUNT(*)
----------
0
3、在会话2中尝试登陆数据库报错如下
[oracle@sourcedb ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 7 15:24:16 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn / as sysdba
ERROR:
ORA-01075: you are currently logged on
SQL> conn / as sysdba
ERROR:
ORA-01075: you are currently logged on
此时alert报错:
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_2153.trc (incident=19211):
ORA-00600: internal error code, arguments: [18061], [1403], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_19211/orcl_ora_2153_i19211.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sun May 07 15:25:34 2017
Dumping diagnostic data in directory=[cdmp_20170507152534], requested by (instance=1, osid=2153), summary=[incident=19210].
Sun May 07 15:25:41 2017
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_2159.trc (incident=18228):
ORA-00600: internal error code, arguments: [16201], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_18228/orcl_m000_2159_i18228.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_m000_2159.trc:
ORA-00600: internal error code, arguments: [16201], [], [], [], [], [], [], [], [], [], [], []
Dumping diagnostic data in directory=[cdmp_20170507152543], requested by (instance=1, osid=2159 (M000)), summary=[incident=18228].
4、在会话1中重启数据库
SQL> shutd