Re: Export throws ORA-04063 on a brand new DB

Rick Denoire wrote:
> I just migrated a DB from 8.1.7.0 to 9.2.0.4 via full export/import
> and everything seemed to go well. But now, at my first attempt to do a
> full export from the new created DB, a get following errors:
>
> EXP-00008: ORACLE error 4068 found
> ORA-04068: existing state of package has been discarded
> ORA-04063: package body "SYS.LT_EXPORT_PKG" hat errors
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: in line 1
> EXP-00083: former problem occurred calling
> SYS.LT_EXPORT_PKG.schema_info_exp aufgetreten
>
> The export itself finishes with warnings, but I am afraid it won't be
> of any use.
>
> Then I found that I have 66 invalid sys objects. I ran
> $ORACLE_HOME/rdbms/admin/utlrp.sql to recompile, but that did not
> help. I also tried "grant execute on sys.lt_export_pkg to public", did
> not help either.
>
> Hey, this was supposed to be a well organized procedure. It was tested
> several times before in a different environment, the resulting DB was
> checked by developers, etc. I just missed doing an testwise export of
> the target DB.
>
> Neither export or rman are running for the new DB...
> Now I am lost in [Oracle] space. Any help will be highly appreciated!
>
> Bye
> Rick Denoire
>
> PS:
> The actual procedure was:
> 1. Install Oracle 9.2.0.1 using a new ORACLE_HOME (Solaris 7)
> 2. Apply PatchSet 9.2.0.4
> 3. Produce a DB creation script using the DBCA.
> 4. Edit and Use the script to create an empty DB (no example schemas).
> 5. Do a full import to the empty DB and check everything.
> 6. Cold backup of old prod. DB, rename old DB.
> 7. Rename new DB to original name(using the "backup controlfile to
> trace" script).
>
> (and yes, I know that renaming was not absolutely necessary, but hell
> knows what can go wrong - DB links?).

It would be helpful to know what objects are in an invalid state and who owns them.

But off the top of my head I'd start by running catalog, catproc, any other relevant scripts, then utlrp again.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)