UDE-31623: operation generated ORACLE error 31623 解决

参考文章 http://dbsnake.com/2010/08/ora-600-objn-exists.html


[oracle@HTVDB001 backup]$ expdp \' / as sysdba \' dumpfile=deploy-201109200415.dmp schemas=DEPLOY exclude=table:\" like \'V_%\'\"

Export: Release 11.2.0.1.0 - Production on Tue Sep 20 04:22:49 2011

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options



UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488
ORA-06512: at line 1

[oracle@HTVDB001 backup]$
[oracle@HTVDB001 backup]$  tail -300f alert_gnnt.log


Tue Sep 20 04:22:50 2011
Errors in file /opt/ora11/diag/rdbms/gnnt/gnnt/trace/gnnt_ora_3601.trc  (incident=245547):
ORA-00600: internal error code, arguments: [kkdlcob-objn-exists], [77239], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/ora11/diag/rdbms/gnnt/gnnt/incident/incdir_245547/gnnt_ora_3601_i245547.trc
Tue Sep 20 04:23:29 2011
Thread 1 advanced to log sequence 7895 (LGWR switch)
  Current log# 3 seq# 7895 mem# 0: /opt/ora11/oradata/gnnt/redo03.log
Tue Sep 20 04:23:46 2011



[oracle@HTVDB001 trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 20 04:42:11 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select max(obj#) from obj$ ;

MAX(OBJ#)
----------
     78155

SQL> select dataobj# from obj$ where name = '_NEXT_OBJECT';

  DATAOBJ#
----------
     77244

SQL> update obj$ set dataobj#=78165  where name = '_NEXT_OBJECT';

1 row updated.

SQL> commit;

Commit complete.

SQL> exit


[oracle@HTVDB001 trace]$ sqlplus deploy/pass01

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 20 04:44:25 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create table test(id number,name varchar2(10));
create table test(id number,name varchar2(10))
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkdlcob-objn-exists], [77243], [],
[], [], [], [], [], [], [], [], []


SQL> exit


[oracle@HTVDB001 trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 20 04:49:10 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 2.6991E+10 bytes
Fixed Size                  2213976 bytes
Variable Size            1.9327E+10 bytes
Database Buffers         7516192768 bytes
Redo Buffers              145174528 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@HTVDB001 trace]$ sqlplus deploy/pass01

SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 20 04:50:43 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create table test(id number,name varchar2(10));

Table created.

SQL> drop table test;

Table dropped.

SQL> exit


修复完成