Monday, January 21, 2013

ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.SCHEMA_INFO_EXP

Following was seen while doing an export (expdp) in a 11gR2 standard edition database.
ORA-39127: unexpected error from call to export_string :=WMSYS.LT_EXPORT_PKG.SCHEMA_INFO_EXP('REPOS',0,1,'11.02.00.00.00',newblock) 
ORA-04063: package body "WMSYS.LT_EXPORT_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "WMSYS.LT_EXPORT_PKG"
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 9427
Querying the dba_registry showed OWM (Oracle Workspace Manager) status invalid.
Execute on utl_file has been revoked from public for security and 1331906.1 says grant utl_file to wmsys but this did not resolve the issue.
Running (1263697.1)
dbms_registry.loading('OWM', 'Oracle Workspace Manager', 'VALIDATE_OWM', 'WMSYS');
didn't help either.
Finally reinstall the OWM (731576.1)
$ORACLE_HOME/rdbms/admin/owminst.plb
and OWM status became VALID in the dba_registry and expdp continue without any errors.



Useful metalink notes
ORA-39705 When Removing Oracle Workspace Manager [ID 1263697.1]
Errors During Full DataPump Export (EXPDP) In 11gR2 [ID 1331906.1]
How do you manually install/deinstall Oracle Workspace Manager [ID 731576.1]

Related Posts
ORA-39127: unexpected error from call to export_string :=SYS.DBMS_CUBE_EXP.SCHEMA_INFO_EXP while Exporting
Dictionary Scripts