求Oracle报错UDI-04045、ORA-04045、ORA-01775解决办法
0
[已解决问题]
解决于 2022-09-23 23:43
创建完成用户及表空间后，导入数据库，出现如下问题：
[oracle@ufdb165 bin]$ ./impdp cwy_init0914/cwy_123456789@ufgovdb1 directory=DATA_PUMP_DIR dumpfile=cwy_init_0902.dmp REMAP_SCHEMA=cwy_init:cwy_init0914 transform=segment_attributes:n logfile= imp_cwy_init_0914.log
Import: Release 11.2.0.4.0 - Production on Wed Sep 14 17:11:38 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_FULL_01 for user CWY_INIT0914
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 798
ORA-39080: failed to create queues "KUPC$C_1_20220914171138" and "KUPC$S_1_20220914171138" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1534
ORA-00604: error occurred at recursive SQL level 2
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
解决办法：
SQL> conn / as sysdba
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
SQL> @?/rdbms/admin/catmetx.sql
SQL> @?/rdbms/admin/utlrp.sql
出现如下新问题：
[oracle@ufdb165 bin]$ ./impdp cwy_init0914/cwy_123456789@ufgovdb1 directory=DATA_PUMP_DIR dumpfile=cwy_init_0902.dmp REMAP_SCHEMA=cwy_init:cwy_init0914 transform=segment_attributes:n logfile= imp_cwy_init_0914.log
Import: Release 11.2.0.4.0 - Production on Wed Sep 14 19:20:27 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
UDI-04045: operation generated ORACLE error 4045
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_DATAPUMP
ORA-01775: looping chain of synonyms
尝试度娘提供的各种办法，仍未解决
最佳答案
0
其他回答(1)
0
01775：https://blog.csdn.net/weixin_29159711/article/details/116445418
04045：https://blog.csdn.net/totorobig/article/details/111058342
哈哈，该问题昨天已解决。附上解决问题记录
https://www.cnblogs.com/silgen/p/16694486.html
您给的两个链接都有尝试，问题根源还是在于undo表空间不足（达到了32G）
该问题昨晚已解决，附上问题解决记录：https://www.cnblogs.com/silgen/p/16694486.html
– 查拉图斯特拉面条 1年前