Exp-00056 Oracle Error 4063 Encountered
12 October 2006 23:23 suvv Messages: 17Registered: October 2006 Junior Member Hi all, i am getting this error while doing export. Database 10.2.0 (Microsoft Windows Server 2003) ****************************************************** EXP-00008: ORACLE error 4063 encountered ORA-04063: exp 00056 oracle error 12154 encountered package body "SYS.DBMS_FILE_GROUP_EXP" has errors ORA-06508: PL/SQL: could not find program unit being exp 00056 oracle error 1017 encountered called: "SYS.DBMS_FILE_GROUP_EXP" ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_FILE_GROUP_EXP.schema_info_exp EXP-00008: ORACLE error 4063 encountered ORA-04063: exp 00056 oracle error 1034 encountered package body "SYS.DBMS_LOGREP_EXP" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGREP_EXP" ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema_info_exp . exporting foreign function library names for user SYSADM . exporting PUBLIC type synonyms . exporting private type synonyms . exporting object type definitions for user SYSADM About to export SYSADM's objects ... . exporting database links . exporting sequence numbers . exporting cluster definitions EXP-00056: ORACLE error 4063 encountered ORA-04063: view "SYS.KU$_XMLSCHEMA_VIEW" has errors EXP-00000: Export terminated unsuccessfully *************************************************************** I have run the utlrp.sql script to recompile the packages and I have recompile all invalid objects. Some object I can not recompile. The error messages gives that they missing SYS.KU$_SCHEMAOBJ_T.I also get the message that SYS.DBMS_REGISTRY_SYS has errors.There is no object with the name 'SYSTEM' in the database.How can I get the object SYS.KU$_SCHEMAOBJ_T back? Report message to a moderator Re: EXP ERROR -Urgent [message #197889 is a reply to message #197858] Fri, 13 October 2006 02:29 pareshjavkar Messages: 7Registered: October 2006 Location: Mumbai Junior Member Hi, Try and execute ORACLE_HOME\rdbms\admin\catexp.sql and retry export. Also, if you can post your exp command. Report message to a moderator Re: EXP ERROR -Urgent [message #197899 is a reply to message #197858] Fri, 13 October 2006 03:19 suvv Messages: 17Registered: October 2006 Junior Member Thanx for ur reply ! i have tried the catexp.sql but it is still giving the error. any other suggestion for this ORA-04063: view "SYS.KU$_XMLSCHEMA_VIEW" has errors. Report message to a moderator Re: EXP ERROR -Urgent [message #197905 is a reply to message #197899] Fri, 13 October 2006 04:26 orausern Messages: 817Registered: December 2005 Senior Member Try running utlrp.sql and see if that helps..(the script is in error 4063 encounteredORA-04063: package body "SYS.DBMS_LOGMNR_LOGREP_DICT" has errorsORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGMNR_LOGREP_DICT"ORA-06512: at line 1EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGMNR_LOGREP_DICT.system_info_expEXP-00008: ORACLE error 4063 encounteredORA-04063: package body "SYS.DBMS_LOGMNR_LOGREP_DICT" has errorsORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_LOGMNR_LOGREP_DICT"ORA-06512: at line 1EXP-00083: The previous problem http://www.orafaq.com/forum/t/70896/ occurred when calling SYS.DBMS_LOGMNR_LOGREP_DICT.system_info_expUsing sql*plus found that the sys schema package body DBMS_LOGMNR_LOGREP_DICT is invalid.Trying to validate this package using the following statement not success:Alter package DBMS_LOGMNR_LOGREP_DICT compile;Searched the $ORACLE_HOME/rdbms/admin and found that this package is created with the Oracle supplied script prvtlmrd.plb. Trying to http://databasefun.blogspot.com/2009/03/full-export-error-caused-by.html validate this package using this script is still not working.@$ORACLE_HOME/rdbms/admin/prvtlmrd.plbFinally, try to rebuild the whole database stored procedures using catproc.sql did not validate this package body(but has a side effect, explained later). So I asked the Oracle support for help. The reply went back quickly with an action plan based on Doc ID 550197.1.For the packages of the LogMiner to be created successfully, you need to drop the SYSTEM.LOGMNR_SESSION$ table first, and then you can run the Oracle supplied scripts to recreate the LogMiner packages successfully. But the action plan missed the prvtlmrd.plb.So, it should be:SQL> connect / as sysdbaSQL> drop table SYSTEM.LOGMNR_SESSION$ purge;SQL> @?/rdbms/admin/dbmslm.sqlSQL> @?/rdbms/admin/prvtlm.plbSQL> @?/rdbms/admin/dbmslmd.sqlSQL> @?/rdbms/admin/prvtlmd.plbSQL> @?/rdbms/admin/prvtlmc.plbSQL> @?/rdbms/admin/prvtlmrd.plbThis makes the invalid sys schema package body DBMS_LOGMNR_LOGREP_DICT valided.But the export still got error. This time, the log is like this:EXP-00056 CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=ORA-00091 JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it http://dbaforums.org/oracle/index.php?showtopic=4781 enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle oracle error VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace 00056 oracle error depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x No.: 5,212 While exporting the database I got the following error in log file. Can anyone explain ho w to remove the error in export? EXP-00008: ORACLE error 4068 encountered ORA-04068: existing state of packages has been discarded ORA-04063: package body "SYS.LT_EXPORT_PKG" has errors ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at line 1 EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_info_expDatabase version is Oracle9i Enterprise Edition Release 9.2.0.1.0. dave View Member Profile Oct 3 2006, 09:17 AM Post #2 Advanced Member Group: Members Posts: 5,208 Joined: 8-October 04 Member No.: 785 ORA-04063: package body "SYS.LT_EXPORT_PKG" has errorsfound out why and fix them milindb View Member Profile Oct 3 2006, 09:46 AM Post #3 Newbie Group: Members Posts: 5 Joined: 3-October 06 From: Pune Member No.: 5,212 I have compiled the package and it is perfectly fine and not giving error. Only during the time of export it shows the error... burleson View Member Profile Oct 3 2006, 01:11 PM Post #4 Advanced Member Group: Members Posts: 13,227 Joined: 26-January 04 Member No.: 13 select comp_id, version, status from dba_registry;If status = "invalid", re-run AS SYS: catalog.sqlcatproc.sqlutlrp.sqlselect owner from dba_source where . . . = 'DBMS_METADATA'.and make sure it's owned by SYS -------------------- Hope this helps. . . Donald K. BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference milindb View Member Profile Oct 5 2006, 01:09 AM Post #5 Newbie Group: Members Posts: 5 Joined: 3-October 06 From: Pune Member No.: 5,212 Thanks for the immediate reply. I tried the solution given by you. Now i am getting different error as,EXP-00056: ORACLE error 6502 encounteredORA-06502: PL/SQL: numeric or value errorLPX-00210: expected '<' instead of 'n'ORA-06512: at "SYS.UTL_XML", line 0ORA-06512: at "SYS.DBMS_METADATA_INT", line 3296ORA-06512: at "SYS.DBMS_METADATA_INT", line 4148ORA-06512: at "SYS.DBMS_METADATA", line 458ORA-06512: at "SYS.DBMS_METADATA", line 1156ORA-06512: at "SYS.DBMS_METADATA", line 1141ORA-06512: at line 1EXP-00056: ORACLE error 6502 encounteredORA-06502: PL/SQL: numeric or value errorLPX-00210: expected '<' instead of 'n'ORA-06512: at "SYS.UTL_XML", line 0ORA-06512: at "SYS.DBMS_METADATA_INT", line 3296ORA-06512: at "SYS.DBMS_METADATA_INT", line 4148ORA-06512: at "SYS.DBMS_METAD