Applies to:
Workspace Manager - Version 11.2.0.3 and later
Information in this document applies to any platform.
Symptoms
Export dump is failing with following errors.
ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.SYSTEM_INFO_EXP(0,dynconnect,'11.02.00.00.00',newblock)
ORA-04063: package body "WMSYS.LTADM" has errors
ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LTADM"
ORA-06512: at "WMSYS.LT_EXPORT_PKG", line 1516
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 9281
ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.SCHEMA_INFO_EXP('SYS',1,1,'11.02.00.00.00',newblock)
ORA-04063: package body "WMSYS.LTADM" has errors
ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LTADM"
ORA-06512: at "WMSYS.LT_EXPORT_PKG", line 1688
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 9427 Message will email to:
Changes
Execute privileges revoked form PUBLIC on DBMS_SQL package.
Cause
SELECT OBJECT_NAME,OBJECT_TYPE,OWNER FROM DBA_OBJECTS WHERE STATUS != 'VALID';
LTADM PACKAGE BODY WMSYS
DBA_errors show:
WMSYS LTADM PACKAGE BODY 19 13128 15
PLS-00201: identifier 'DBMS_SQL' must be declared
ERROR 201
Solution
To validate the package LTADM grant execute privileges on DBMS_SQL to PUBLIC or WMSYS.
Conn / as sysdba
Grant execute on DBMS_SQL to PUBLIC;
or
Grant execute on DBMS_SQL to WMSYS;
@?/rdbms/admin/utlrp.sql
Run the expdp again.It should work fine now.
If Still Package under WMSYS is invalid Please contact Oracle Support.
References
NOTE:247093.1 - Be Cautious When Revoking Privileges Granted to PUBLIC
