Oracle Database Discussions

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!

help me to pls solve ORA-06512 error

703546May 26 2009 — edited May 27 2009

I create a full dump of database with following command:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
expdp %DB_USERNAME%/%DB_PASSWORD%@%TNS_ALIAS% full=Y CONTENT=ALL directory=%ORADMPDIRNAME% dumpfile=%DMP_BKP_FILENAME% logfile=%LOGFILE%
---------------------------------------------------------------------------------------------------------------------------------------------------------------------

But when i try to import created dump file, with command:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
impdp %DB_USERNAME%/%DB_PASSWORD%@%TNS_ALIAS% full=Y CONTENT=ALL TABLE_EXISTS_ACTION=REPLACE directory=%ORADMPDIRNAME% dumpfile=%DMP_BKP_FILENAME% logfile=%LOGFILE%
---------------------------------------------------------------------------------------------------------------------------------------------------------------------

i get next error message in my console:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
...
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-01843: not a valid month
Failing sql is:
BEGIN
if (system.wm$_check_install) then
return ;
end if ;
begin execute immediate 'insert into wmsys.wm$workspaces_table
values(''LIVE'',
'''',
''0'',
'''',
''-1'',
'''',
''SYS'
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-06550: line 2, column 93:
PLS-00302: component 'OPERATOR_NONE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
Failing sql is:
BEGIN
dbms_server_alert.set_threshold(2104,dbms_server_alert.operator_GT,'1200',dbms_server_alert.operator_NONE,'',1,3,'ias',dbms_server_alert.object_type_SYSTEM,'');COMMIT; END;
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PROCESS_TABLE_EXISTS_ACTION [TABLE:"IX"."AQ$_STREAMS_QUEUE_TABLE_T"]
ORA-24019: identifier for QUEUE_TABLE too long, should not be greater than 24 characters
ORA-00955: name is already used by an existing object

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6266

----- PL/SQL Call Stack -----
object line object
handle number name
3069F2A0 14916 package body SYS.KUPW$WORKER
3069F2A0 6293 package body SYS.KUPW$WORKER
3069F2A0 11663 package body SYS.KUPW$WORKER
3069F2A0 12429 package body SYS.KUPW$WORKER
3069F2A0 11969 package body SYS.KUPW$WORKER
3069F2A0 3278 package body SYS.KUPW$WORKER
3069F2A0 6882 package body SYS.KUPW$WORKER
3069F2A0 1259 package body SYS.KUPW$WORKER
2D7B6B4C 2 anonymous block
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
short message of failing:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
...
ORA-31684: Object type SEQUENCE:"GMT_META"."MD_ERRORSEQ" already exists
ORA-39083: Object type LIBRARY failed to create with error:
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PROCESS_TABLE_EXISTS_ACTION [TABLE:"IX"."AQ$_STREAMS_QUEUE_TABLE_T"]
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
in my D:\oracle\product\10.2.0\admin\ias\bdump\alert_ias.log:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
...
Warning: drop queue table :SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_T dictionary doesn't exist
Warning: drop queue table: will try to forcibly drop the queue table and other tables, iots, rules, rulesets associated with queue table
Warning: drop_queue_table: No evaluation for the queue table: SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_T
Warning: drop queue table :SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_H dictionary doesn't exist
Warning: drop queue table: will try to forcibly drop the queue table and other tables, iots, rules, rulesets associated with queue table
Warning: drop_queue_table: No evaluation for the queue table: SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_H
Warning: drop queue table :SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_G dictionary doesn't exist
Warning: drop queue table: will try to forcibly drop the queue table and other tables, iots, rules, rulesets associated with queue table
Warning: drop_queue_table: No evaluation for the queue table: SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_G
Warning: drop queue table :SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_I dictionary doesn't exist
Warning: drop queue table: will try to forcibly drop the queue table and other tables, iots, rules, rulesets associated with queue table
Warning: drop_queue_table: No evaluation for the queue table: SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_I
Warning: drop queue table :IX.AQ$_ORDERS_QUEUETABLE_T dictionary doesn't exist
Warning: drop queue table: will try to forcibly drop the queue table and other tables, iots, rules, rulesets associated with queue table
Warning: drop_queue_table: No evaluation for the queue table: IX.AQ$_ORDERS_QUEUETABLE_T
Warning: drop queue table :IX.AQ$_ORDERS_QUEUETABLE_H dictionary doesn't exist
Warning: drop queue table: will try to forcibly drop the queue table and other tables, iots, rules, rulesets associated with queue table
Warning: drop_queue_table: No evaluation for the queue table: IX.AQ$_ORDERS_QUEUETABLE_H
Warning: drop queue table :IX.AQ$_ORDERS_QUEUETABLE_G dictionary doesn't exist
Warning: drop queue table: will try to forcibly drop the queue table and other tables, iots, rules, rulesets associated with queue table
Warning: drop_queue_table: No evaluation for the queue table: IX.AQ$_ORDERS_QUEUETABLE_G
Warning: drop queue table :IX.AQ$_ORDERS_QUEUETABLE_I dictionary doesn't exist
Warning: drop queue table: will try to forcibly drop the queue table and other tables, iots, rules, rulesets associated with queue table
Warning: drop_queue_table: No evaluation for the queue table: IX.AQ$_ORDERS_QUEUETABLE_I
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
my settings:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL> show parameter recov;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string D:\oracle\product\10.2.0\flash_recovery_area
db_recovery_file_dest_size big integer 20G
recovery_parallelism integer 0
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 57
Next log sequence to archive 59
Current log sequence 59
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
D:\oracle\product\10.2.0\flash_recovery_area\IAS\ARCHIVELOG\2009_05_26>dir
...
26.05.2009 18:12 <DIR> .
26.05.2009 18:12 <DIR> ..
26.05.2009 16:19 2 898 944 O1_MF_1_57_51QV2KC7_.ARC
26.05.2009 17:15 48 465 408 O1_MF_1_58_51QYD4PG_.ARC
26.05.2009 18:12 47 736 832 O1_MF_1_59_51R1QR5C_.ARC
3 File(s) 99 101 184 bytes
2 Dir(s) 473 158 713 344 bytes free

D:\oracle\product\10.2.0\flash_recovery_area\IAS\ARCHIVELOG\2009_05_26>
---------------------------------------------------------------------------------------------------------------------------------------------------------------------

How can i resolve this problem? Any suggestion would be highly apprecialble.

Thanks in advance!

This post has been answered by 591186 on May 27 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 24 2009

Added on May 26 2009

#general-database-discussions

8 comments

6,799 views