环境:
OS:Centos 7
DB:11.2.0.4
1.部署了vault后expdp导出报错
[oracle@11g rman_bakckup]$ expdp system/oracle directory=data_pump_dir dumpfile=schema_jt.dmp schemas='(jt)'
Export: Release 11.2.0.4.0 - Production on Sun Oct 17 21:14:42 2021
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, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
ORA-31626: job does not exist
ORA-31633: unable to create master table "SYSTEM.SYS_EXPORT_SCHEMA_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1038
ORA-47401: Realm violation for CREATE TABLE on SYSTEM.SYS_EXPORT_SCHEMA_05
解决办法:
将system用户加入到Oracle Data Dictionary领域的参与者(Participant)
再次执行后也继续报错
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_TRANSFORM_EXIMP.INSTANCE_INFO_EXP('AQ$_MGMT_NOTIFY_QTABLE_S','SYSMAN',1,1,'11.02.00.04.00',newblock)
ORA-01031: insufficient privileges
解决办法:
使用dbvowner登录执行如下的授权过程
SQL> conn dbvowner/Oracle#123
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Connected as dbvowner
SQL> exec dbms_macadm.authorize_datapump_user('SYSTEM');
再次执行成功:
[oracle@11g dpdump]$ expdp system/oracle directory=data_pump_dir dumpfile=schema_jt.dmp schemas='(jt)'
Export: Release 11.2.0.4.0 - Production on Sun Oct 17 21:57:17 2021
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, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/******** directory=data_pump_dir dumpfile=schema_hxl100.dmp schemas=(hxl100)
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type SCHEMA_EXPORT/USER
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/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCACT_SCHEMA
. . exported "HXL100"."TB_100" 5.429 KB 2 rows
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:
/u01/app/oracle/admin/slnngk/dpdump/schema_hxl100.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Sun Oct 17 21:57:22 2021 elapsed 0 00:00:04