• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 17188
  • Last Modified:

EXP-00056: ORACLE error 4068 encountered

Subject: EXP-00056: ORACLE error 4068 encountered

RDBMS Version: 9.2.0.4.0
Operating System and Version: MS Windows 2003 Server Standard Edition; 5.2.3790 Build 3790
Error Number (if applicable): 4068
Product (i.e. SQL*Loader, Import, etc.): Export
Product Version: 9.2.0.4.0

EXP-00056: ORACLE error 4068 encountered

Hi,

I am facing a problem in exporting a database on my server. The following is the conents of the log file after the export error.

==============================

Connected to: Oracle9i Release 9.2.0.4.0 - Production
JServer Release 9.2.0.4.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user RBADM
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user RBADM
About to export RBADM's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04067: not executed, package body "SYS.DBMS_METADATA" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

=======================================

I checked & found that there is a package called "SYS.DBMS_METADATA" but there was no package body. When I checked with the other databases on the same server I found the corresponding package bodies, which are wrapped. I don't know how to create this package body in the database where I am facing a problem in exporting. Even if you have any other procedure/scripts please let me know so that I can run them and resolve this issue.

Please help me on this issue. Your earliest reply would be highly appreciated.

Thanks & Regards,
Shyam Pendyala.
0
pppshetty
Asked:
pppshetty
  • 3
  • 3
  • 2
  • +1
1 Solution
 
NievergeltCommented:
Hi Shyam

I wonder, whether you have some incomplete database installation.

Please answer the following questions:
Do you know, whether the installation ran without errors?
Could it be that more objects in the SYS schema are missing?
Is it absolutely neccessary to export the whole database?
Is it neccessary to export the SYS schema?
Are you going to import the database dump in another database?

Christoph
0
 
pppshettyAuthor Commented:
Hi Christoper

Thanks for a response from your side.

Actually we had upgrated Oracle to 9.2.0.4.0 by applying a patch six months earlier, which ended up with some errors. That time we didn't know about it and we didn't care about it. Now we noticed it because of the R&D process in troubleshooting the 'export' issue in the database.

Meanwhile, we had sorted out the issue by running "prvtmeta.plb", which has created the package body for SYS.DBMS_META package (we found this on our own). Once this is done, we ran 'catpatch.sql' from sqlplus after starting the database in 'magration mode' and we ran 'ultrp.sql' in 'restricted mode' of the database. (the later part of the solution has been taken from another thread in this site itself.) Anyway, thanks for the support.

Thanks & Regards,
Shyam.
0
 
peterside7Commented:
Execute this sql statement :

select comp_id, version, status from dba_registry;

If something is not valid, rerun

catalog.sql
catproc.sql
utlrp.sql

also , check in dba_source if  SYS.DBMS_METADATA is there (in which user).
it has to be owner by SYS (nothing else)

Pierre
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
peterside7Commented:
Also check :

select count(*) from dba_objects where status = 'INVALID';
and
select owner,count(*) from dba_objects where status = 'INVALID' group by owner;

to get an idea what`s going on with your objects


0
 
peterside7Commented:
Do you need more info ? Did you try it ?
0
 
NievergeltCommented:
peterside7, please read Author Comment 11/29/2004 12:41PM CET.
I believe the issue is resolved.

Have a nice day  Christoph
 
0
 
pppshettyAuthor Commented:
Hi Christopher

Thanks for you support on this issue and we appreciate you for the same. The issue is resolved now.

Sorry for not answering you questions earlier. Yes, we need to export it fully and we have to import it into another database.

Although we had a problem in XDB schema with some packages & views etc; the export is happening properly without any error/warnings.

I will try your suggestions later and see whether it improves the situation.

Thanks & Regards,
Shyam Pendyala
0
 
VinceNjCommented:
I mistaken ran
catalog.sql
catproc.sql as SYSTEM instead of SYS
(I've subsequently re-run these as SYS)

SQL> select owner,count(*) from dba_objects where status = 'INVALID' group by owner;

OWNER                            COUNT(*)
------------------------------ ----------
ICOSMCUS                                8
PUBLIC                                  1
SYSTEM                                327
XDB                                     5

How can I recover ??

Thanks,
-Vince
0
 
NievergeltCommented:
Hi Vince

I would create a new database create your users and then exp/imp the schemas of those users.
Tedious but save.

Christoph
0
 
VinceNjCommented:
I left out that I'm not able to export ...
Any other way to get the data out?


exp   user/pw file=exp OWNER=icosmcus
Export: Release 10.1.0.2.0 - Production on Sun Aug 14 13:31:48 2005
Copyright (c) 1982, 2004, Oracle.  All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user ICOSMCUS
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user ICOSMCUS
About to export ICOSMCUS's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
EXP-00056: ORACLE error 4067 encountered
ORA-04067: not executed, package body "SYSTEM.DBMS_METADATA" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now