Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06512: at "SYS.KUPC$QUE_INT", line 609

hemuMay 7 2014 — edited May 8 2014

hi

i am not a DBA

however i have to attend the problem that has surfaced suddenly

the captioned error is logged while importing schema

what causing this error

below is etract of the log file generated by oracle

;;;

Import: Release 11.1.0.7.0 - Production on Wednesday, 07 May, 2014 17:36:50

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

;;;

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production

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

FLASHBACK automatically enabled to preserve database integrity.

Starting "RECORD"."SYS_IMPORT_SCHEMA_32":  record/********@olddata parfile=restore.ctl

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 53.60 GB

Processing object type SCHEMA_EXPORT/USER

ORA-31684: Object type USER:"RECORD" already exists

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/DB_LINK

ORA-31684: Object type DB_LINK:"RECORD"."PRD2SHR" already exists

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

ORA-31684: Object type SEQUENCE:"RECORD"."ADD_ID" already exists

Processing object type SCHEMA_EXPORT/TABLE/TABLE

. . imported "RECORD"."D009040"                         63241047 rows

. . imported "RECORD"."D002008"                         56929899 rows

. . imported "RECORD"."D010014"                         33722678 rows

. . imported "RECORD"."D009044"                         15602315 rows

...

...

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

ORA-39065: unexpected master process exception in RECEIVE

ORA-39078: unable to dequeue message for agent MCP from queue "KUPC$C_1_20140507173659"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPC$QUE_INT", line 609

ORA-25253: listen failed, queue SYS.KUPC$C_1_20140507173659 is not enabled for dequeue

Job "RECORD"."SYS_IMPORT_SCHEMA_32" stopped due to fatal error at 18:48:57

can anyone help me here?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2014
Added on May 7 2014
8 comments
4,460 views