Monday, February 11, 2013

ORA-04063: package body "XDB.DBMS_CSX_INT" has errors

Following could be observed in the database alert log (11.2.0.3) during a schema export.
Errors in file /opt/app/oracle/diag/rdbms/db/db/trace/db_dw00_5669.trc:
ORA-00604: error occurred at recursive SQL level 3
ORA-04063: package body "XDB.DBMS_CSX_INT" has errors
XDB SGA reset to NULL.
This is a consequence of revoking execute privilege on utl_file from public. More on revoking execute privilege from public on some packages is available on 247093.1,797706.1,1165830.1.
To resolve the issue with the expdp grant the revoke execute privilege back to public or explicitly to the xdb user.


Useful metalink notes
Data Pump Export (expdp) = ORA-39126 ORA-39127 ORA-4063 (on XDB.DBMS_XDBUTIL_INT & XDB.DBMS_XDBZ0) ORA-6508 RESOURCE_VIEW Query = ORA-4063 [ID 1526443.1]
ORA-20011 Approximate NDV failed ORA-04063 package body XDB.DBMS_CSX_INT has errors [ID 1356250.1]

Related to revoking execute privilege on certain packages from Public
Problems After Revoking Execute On DBMS_SQL, DBMS_JOB, DBMS_LOB, DBMS_RANDOM, and DBMS_OBFUSCATION_TOOLKIT From PUBLIC [ID 1165830.1]
Be Cautious When Revoking Privileges Granted to PUBLIC [ID 247093.1]
Invalid Objects After Revoking EXECUTE Privilege From PUBLIC [ID 797706.1]