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.
pppshettyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

NievergeltSenior SW DevCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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
NievergeltSenior SW DevCommented:
peterside7, please read Author Comment 11/29/2004 12:41PM CET.
I believe the issue is resolved.

Have a nice day  Christoph
 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
NievergeltSenior SW DevCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.