SQL> startup ;

ORACLE 例程已经启动。

Total System Global Area 1.4531E+10 bytes

Fixed Size                  2295256 bytes

Variable Size            2181040680 bytes

Database Buffers         1.2314E+10 bytes

Redo Buffers               33193984 bytes

数据库装载完毕。

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00600: internal error code, arguments: [kokiasg1], [], [], [], [], [], [],

[], [], [], [], []

进程 ID: 5628

会话 ID: 122 序列号: 3

Thu Jul 03 16:35:25 2025

Shutting down instance (immediate)

Stopping background process SMCO

Shutting down instance: further logons disabled

Thu Jul 03 16:35:26 2025

Stopping background process CJQ0

Stopping background process QMNC

Stopping background process MMNL

Stopping background process MMON

License high water mark = 272

All dispatchers and shared servers shutdown

Thu Jul 03 16:35:54 2025

alter database close normal

Thu Jul 03 16:35:54 2025

SMON: disabling tx recovery

SMON: disabling cache recovery

Thu Jul 03 16:35:54 2025

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Thread 1 closed at log sequence 296590

Successful close of redo thread 1

Completed: alter database close normal

alter database dismount

Shutting down archive processes

Archiving is disabled

Completed: alter database dismount

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Thu Jul 03 16:36:02 2025

Stopping background process VKTM

Thu Jul 03 16:36:07 2025

Instance shutdown complete

Thu Jul 03 16:36:19 2025

Adjusting the default value of parameter parallel_max_servers

from 640 to 270 due to the value of parameter processes (300)

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Initial number of CPU is 16

Number of processor cores in the system is 8

Number of processor sockets in the system is 1

Picked latch-free SCN scheme 3

Using LOG_ARCHIVE_DEST_1 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on.

IMODE=BR

ILAT =52

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options.

Windows NT Version V6.2 

CPU                 : 16 - type 8664, 8 Physical Cores

Process Affinity    : 0x0x0000000000000000

Memory (Avail/Total): Ph:24712M/32767M, Ph+PgF:14089M/39123M

System parameters with non-default values:

  processes                = 300

  sessions                 = 480

  nls_language             = "SIMPLIFIED CHINESE"

  nls_territory            = "CHINA"

  sga_target               = 13920M

  control_files            = "D:\APP\ADMINISTRATOR\ORADATA\orcl\CONTROL01.CTL"

  control_files            = "D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\orcl\CONTROL02.CTL"

  db_block_size            = 8192

  compatible               = "11.2.0.4.0"

  db_recovery_file_dest    = "D:\app\Administrator\fast_recovery_area"

  db_recovery_file_dest_size= 10G

  undo_tablespace          = "UNDOTBS1"

  remote_login_passwordfile= "EXCLUSIVE"

  db_domain                = ""

  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"

  job_queue_processes      = 10

  audit_file_dest          = "D:\APP\ADMINISTRATOR\ADMIN\orcl\ADUMP"

  audit_trail              = "DB"

  db_name                  = "orcl"

  open_cursors             = 300

  pga_aggregate_target     = 4639M

  diagnostic_dest          = "D:\APP\ADMINISTRATOR"

Thu Jul 03 16:36:20 2025

PMON started with pid=2, OS id=13088

Thu Jul 03 16:36:20 2025

PSP0 started with pid=3, OS id=16168

Thu Jul 03 16:36:21 2025

VKTM started with pid=4, OS id=7948 at elevated priority

VKTM running at (10)millisec precision with DBRM quantum (100)ms

Thu Jul 03 16:36:21 2025

GEN0 started with pid=5, OS id=4192

Thu Jul 03 16:36:21 2025

DIAG started with pid=6, OS id=8232

Thu Jul 03 16:36:21 2025

DBRM started with pid=7, OS id=16436

Thu Jul 03 16:36:21 2025

DIA0 started with pid=8, OS id=11400

Thu Jul 03 16:36:21 2025

MMAN started with pid=9, OS id=11108

Thu Jul 03 16:36:21 2025

DBW0 started with pid=10, OS id=12232

Thu Jul 03 16:36:21 2025

DBW1 started with pid=11, OS id=7368

Thu Jul 03 16:36:21 2025

LGWR started with pid=12, OS id=13520

Thu Jul 03 16:36:21 2025

CKPT started with pid=13, OS id=11952

Thu Jul 03 16:36:21 2025

SMON started with pid=14, OS id=9304

Thu Jul 03 16:36:21 2025

RECO started with pid=15, OS id=17136

Thu Jul 03 16:36:21 2025

MMON started with pid=16, OS id=1984

Thu Jul 03 16:36:21 2025

MMNL started with pid=17, OS id=2568

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'

starting up 1 shared server(s) ...

ORACLE_BASE from environment = D:\app\Administrator

Thu Jul 03 16:36:22 2025

alter database mount exclusive

Successful mount of redo thread 1, with mount id 1287723014

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: alter database mount exclusive

alter database open

Thread 1 opened at log sequence 296590

  Current log# 1 seq# 296590 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\orcl\REDO01.LOG

Successful open of redo thread 1

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

SMON: enabling cache recovery

[15144] Successfully onlined Undo Tablespace 2.

Undo initialization finished serial:0 start:3680275922 end:3680276032 diff:110 (1 seconds)

Verifying file header compatibility for 11g tablespace encryption..

Verifying 11g file header compatibility for tablespace encryption completed

SMON: enabling tx recovery

Database Characterset is ZHS16GBK

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_15144.trc  (incident=7579):

ORA-00600: 内部错误代码, 参数: [kokiasg1], [], [], [], [], [], [], [], [], [], [], []

Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\incident\incdir_7579\orcl_ora_15144_i7579.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 D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_15144.trc:

ORA-00600: 内部错误代码, 参数: [kokiasg1], [], [], [], [], [], [], [], [], [], [], []

Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_15144.trc:

ORA-00600: 内部错误代码, 参数: [kokiasg1], [], [], [], [], [], [], [], [], [], [], []

Error 600 happened during db open, shutting down database

USER (ospid: 15144): terminating the instance due to error 600

Instance terminated by USER, pid = 15144

ORA-1092 signalled during: alter database open...

PARSING IN CURSOR #615624160 len=30 dep=1 uid=0 oct=3 lid=0 tim=752975051401

   hv=3013659460 ad='7ffbd8f025d0' sqlid='6d8vr86tu1ku4'

select TOTAL from SYS.ID_GENS$

END OF STMT

PARSE #615624160:c=15625,e=2775,p=2,cr=14,cu=0,mis=1,r=0,dep=1,og=4,plh=1676180847,tim=752975051401

EXEC #615624160:c=0,e=6,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=1676180847,tim=752975051452

WAIT #615624160: nam='db file sequential read' ela= 126 file#=1 block#=3440 blocks=1 obj#=514 tim=752975051594

WAIT #615624160: nam='db file sequential read' ela= 48 file#=1 block#=3441 blocks=1 obj#=514 tim=752975051671

FETCH #615624160:c=0,e=224,p=2,cr=3,cu=0,mis=0,r=1,dep=1,og=4,plh=1676180847,tim=752975051687

STAT #615624160 id=1 cnt=1 pid=0 pos=1 obj=514 op='TABLE ACCESS FULL ID_GENS$ (cr=3 pr=2 pw=0 time=223 us)'

CLOSE #615624160:c=0,e=15,dep=1,type=0,tim=752975051716

BINDS #12720440:

 Bind#0

  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

  oacflg=00 fl2=0001 frm=00 csi=00 siz=80 off=0

  kxsbbbfp=24b1b128  bln=22  avl=01  flg=05

  value=0

 Bind#1

  oacdty=01 mxl=32(07) mxlc=00 mal=00 scl=00 pre=00

  oacflg=10 fl2=0001 frm=01 csi=852 siz=0 off=24

  kxsbbbfp=24b1b140  bln=32  avl=07  flg=01

  value="IDGEN1$"

 Bind#2

  oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

  oacflg=00 fl2=0001 frm=00 csi=00 siz=0 off=56

  kxsbbbfp=24b1b160  bln=22  avl=02  flg=01

  value=1

EXEC #12720440:c=0,e=107,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,plh=2853959010,tim=752975051842

FETCH #12720440:c=0,e=5,p=0,cr=3,cu=0,mis=0,r=0,dep=1,og=4,plh=2853959010,tim=752975051856

CLOSE #12720440:c=0,e=0,dep=1,type=3,tim=752975051870

Incident 161 created, dump file: C:\APP\XFF\diag\rdbms\orcl\orcl\incident\incdir_161\orcl_ora_1880_i161.trc

ORA-00600: 内部错误代码, 参数: [kokiasg1], [], [], [], [], [], [], [], [], [], [], []

ORA-00600: 内部错误代码, 参数: [kokiasg1], [], [], [], [], [], [], [], [], [], [], []

ORA-00600: 内部错误代码, 参数: [kokiasg1], [], [], [], [], [], [], [], [], [], [], []

E:\dump>imp test/oracle file=SYS_OBJ$.dmp full=y

Import: Release 11.2.0.4.0 - Production on 星期六 7月 5 09:34:42 2025

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

经由常规路径由 EXPORT:V08.01.07 创建的导出文件

警告: 这些对象由 SYS 导出, 而不是当前用户

已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入

导出服务器使用 UTF8 NCHAR 字符集 (可能的 ncharset 转换)

. 正在将 SYS 的对象导入到 TEST

. 正在将 SYS 的对象导入到 TEST

. . 正在导入表                          "OBJ$"导入了      103764 行

成功终止导入, 没有出现警告。

SQL> select * from test.obj$ where name='IDGEN1$';

未选定行

SQL>

SQL> select owner#, obj#,type# from obj$ where name='IDGEN1$';

    OWNER#       OBJ#      TYPE#

---------- ---------- ----------

         0       1229          6

SQL> select owner#, obj#,type#,name from test.obj$ where obj# in(1228,1229,1230);

    OWNER#       OBJ#      TYPE# NAME

---------- ---------- ---------- ------------------------------

         0       1228          2 DST$TRIGGER_TABLE

         0       1230         13 BFILE

SQL> select owner#, obj#,type#,name from obj$ where obj# in(1228,1229,1230);

    OWNER#       OBJ#      TYPE# NAME

---------- ---------- ---------- ------------------------------

         0       1228          2 DST$TRIGGER_TABLE

         0       1229          6 IDGEN1$

         0       1230         13 BFILE

Fri Jul 04 15:57:13 2025

Errors in file C:\APP\XFF\diag\rdbms\orcl\orcl\trace\orcl_ora_27788.trc  (incident=12239):

ORA-00600: 内部错误代码, 参数: [12803], [], [], [], [], [], [], [], [], [], [], []

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Fri Jul 04 15:58:04 2025

Errors in file C:\APP\XFF\diag\rdbms\orcl\orcl\trace\orcl_mmon_1976.trc  (incident=12184):

ORA-00600: 内部错误代码, 参数: [15264], [], [], [], [], [], [], [], [], [], [], []

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

E:\dump>imp test/oracle file=SYS_seq$.dmp full=y

Import: Release 11.2.0.4.0 - Production on 星期六 7月 5 10:10:17 2025

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

经由常规路径由 EXPORT:V08.01.07 创建的导出文件

警告: 这些对象由 SYS 导出, 而不是当前用户

已经完成 ZHS16GBK 字符集和 AL16UTF16 NCHAR 字符集中的导入

导出服务器使用 UTF8 NCHAR 字符集 (可能的 ncharset 转换)

. 正在将 SYS 的对象导入到 TEST

. 正在将 SYS 的对象导入到 TEST

. . 正在导入表                          "SEQ$"导入了         359 行

成功终止导入, 没有出现警告。

SQL> select * from test.seq$ where obj#=1229;

      OBJ# INCREMENT$   MINVALUE   MAXVALUE     CYCLE#     ORDER$      CACHE

---------- ---------- ---------- ---------- ---------- ---------- ----------

 HIGHWATER AUDIT$                                      FLAGS

---------- -------------------------------------- ----------

      1229         50          1 1.0000E+28          0          0       1000

  60267151 --------------------------------                0

SQL> create sequence xxxx;

序列已创建。

SQL> select obj#,type# from obj$ where name='XXXX';

      OBJ#      TYPE#

---------- ----------

     87383          6

SQL> SELECT * FROM SEQ$ WHERE OBJ#=87383;

      OBJ# INCREMENT$   MINVALUE   MAXVALUE     CYCLE#     ORDER$      CACHE

---------- ---------- ---------- ---------- ---------- ---------- ----------

 HIGHWATER AUDIT$                                      FLAGS

---------- -------------------------------------- ----------

     87383          1          1 1.0000E+28          0          0         20

         1 --------------------------------                0

SQL> DROP SEQUENCE XXXX;

序列已删除。

SQL> SELECT * FROM SEQ$ WHERE OBJ#=87383;

未选定行

SQL> select obj#,type# from obj$ where name='XXXX';

未选定行

SQL> select name,obj#,type# from test.obj$ where obj# in(

  2  select obj# from sys.obj$ where owner#=0 and type#=6)

  3  and type#=6;

未选定行

SQL> select name,ctime from test.obj$ where type#=6 and owner#=0;

未选定行