Oracle 11.2.0.4, on RHEL 6.4.
I'm running a FULL datapump export as user SYSTEM and getting the following errors.
Let me also state that this is an OMS repository database for OMS 12.1.0.3.
My basic command is:
${ORACLE_HOME}/bin/expdp system/$SYSTEM \
| FULL=Y |
\ |
| directory=${ORACLE_SID} |
\ |
dumpfile=expdp_${ORACLE_SID}_FULL_${DATE}_%U.dmp \
| logfile=expdp_${ORACLE_SID}_FULL_${DATE}.log |
\ |
| JOB_NAME=${ORACLE_SID}_expdp_full_${DATE} |
\ |
| PARALLEL=4 |
\ |
| COMPRESSION=ALL |
\ |
FILESIZE=30G
|
|
When I run the above as SYSTEM, and even though it has
EXPORT FULL DATABASE
GLOBAL QUERY REWRITE
CREATE MATERIALIZED VIEW
CREATE TABLE
UNLIMITED TABLESPACE
SELECT ANY TABLE
I get 55 separate privilege errors similar to: (even though I did not turn on any type of FGA controls - unless they are automatic when setting up OMS repository)
| ORA-39181: Only partial table data may be exported due to fine grain access control on "SYSMAN_MDS"."MDS_DEPENDENCIES" |
| . . exported "SYSMAN_MDS"."MDS_DEPENDENCIES" |
0 KB |
0 rows |
I also get the following error whether I run the export as SYS or SYSTEM.
Starting "SYS"."omsrp_expdp_full_20140318_10_2": "/******** AS SYSDBA" FULL=Y directory=omsrp dumpfile=expdp_omsrp_FULL_20140318_10_23_%U.dmp logfile=expdp_omsrp_FULL_20140318_10_23.log JOB_NAME=omsrp_expdp_full_20140318_10_23 PARALLEL=4 COMPRESSION=ALL FILESIZE=30G
Estimate in progress using BLOCKS method...
>>> ORA-31642: the following SQL statement fails:
BEGIN "SYS"."DBMS_RULE_EXP_RULES".SCHEMA_CALLOUT(:1,0,1,'11.02.00.04.00'); END;
ORA-01950: no privileges on tablespace 'SYSAUX'
And yes, I have explicitly granted quota unlimited on SYSAUX to both SYS and SYSTEM, but still getting the error.
But then at the end of the export, it shows it exported successfully without error.
Master table "SYS"."omsrp_expdp_full_20140318_10_2" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.omsrp_expdp_full_20140318_10_2 is:
/backup/exports/omsrp/expdp_omsrp_FULL_20140318_10_23_01.dmp
/backup/exports/omsrp/expdp_omsrp_FULL_20140318_10_23_02.dmp
/backup/exports/omsrp/expdp_omsrp_FULL_20140318_10_23_03.dmp
/backup/exports/omsrp/expdp_omsrp_FULL_20140318_10_23_04.dmp
Job "SYS"."omsrp_expdp_full_20140318_10_2" successfully completed at Tue Mar 18 10:28:26 2014 elapsed 0 00:04:56
This one has me stumped.