给radius的linux系统数据库做备份,导出数据时报错,无法正确导出,信息如下:
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Export done in US7ASCII character set and US7ASCII NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
EXP-00008: ORACLE error 4045 encountered
ORA-04045: errors during recompilation/revalidation of SYS.DBMS_AQ_SYS_EXP_INTERNAL
ORA-06552: PL/SQL: Compilation unit analysis terminated
ORA-06553: PLS-905: object SYS.AQ$_SUBSCRIBERS is invalid
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_AQ_EXP_QUEUES", line 141
ORA-06512: at line 1
EXP-00083: The previous problem occurred when calling SYS.DBMS_AQ_EXP_QUEUES.grant_sysprivs_exp
. exporting resource costs
……………………
感觉是系统进程出现了什么问题,查metalink解释如下:
fact: Oracle Server - Enterprise Edition 8.1
fact: Advanced Queuing (QUEUE)
fact: Export Utility (EXP)
symptom: Export terminated unsuccessfully due to invalid advanced queuing
objects
symptom: EXP-00008: ORACLE error %lu encountered
symptom: ORA-04045: errors during recompilation/revalidation of %s.%s
symptom: SYS.DBMS_AQ_IMPORT_INTERNAL
symptom: ORA-06553: PLS-%s: %s
symptom: PLS-905: object %s is invalid
symptom: SYS.AQ$_SUBSCRIBERS
cause: The interdependency of DBMS_AQ_IMPORT_INTERNAL on AQ$_SUBSCRIBERS is
complex and indirect therefore the cause would be difficult to determine.
fix:
The solution is to perform the following
In your init.ora place
_SYSTEM_TRIG_ENABLED=FALSE
and stop and restart the database. As internal or sys with sysdba run
do the following with sqlplus.
ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10'
?/rdbms/admin/utlirp.sql
ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT OFF'
Shutdown the database
Remove
_SYSTEM_TRIG_ENABLED=FALSE
from you init.ora and start the database up.
按照解决方法操作后,问题解决。老版本问题还是多多啊。
阅读(3198) | 评论(0) | 转发(0) |