Re: please help me .. upgrading to 8.1.6 has made my life miserable

You can try utlrp.sql in the rdbms/admin directory - it goes out and recompiles all objects. A better way though, is to just run catalog.sql and catexp.sql - in that order, and as sys.

Walt Livingston
Oracle Technical Support
DoD

"TurkBear" <johng_at_mm.com> wrote in message news:39870158.5983293_at_news...
>
> Where did you find u0801050.sql my Oracle_Home/Rdbms/Admin dir only has
> u0801030 and u0801040 ....
>
>
> Fred Pierce <fpierce_at_avialantic.com> wrote:
>
> >Check to see if sys.standard is invalid and if so try recompiling it. It
> >that doesn't work, the next step is to run
> >$ORACLE_HOME/rdbms/admin u0801050.sql
> >
> >I and many others ran into the problem but it's a fairly simple fix.
> >More of a documentation problem then anything else but the solution is
> >in Metalink.
> >
> >fdp
> >
> >--------------------------------------------------------------------
> >Fred Pierce (DNRC)- fpierce_at_avialantic.com
> >Mid-Atlantic Aviation on the Web - http://www.avialantic.com
> >** Mid Atlantic Air Museum WWII Weekend June 2-4 ** World Airshow News
> >**
> >---------------------------------------------------------------------
> >
> >Tony Simopoulos wrote:
> >>
> >> hello,
> >>
> >> i have made the profound mistake of upgrading from 8.1.5 to 8.1.6. i
> >> chose to upgrade PL/SQL during this process.
> >>
> >> i have not a single package working, because of an error with
> >> "SYS.STANDARD". i believe my task is to re-install PL/SQL, and
> >> recreate all packages, including rdbms packages and tools packages.
> >>
> >> unfortunately, oracle in its infinite installer wisdom did not give me
> >> an "admin" directory for plsql. using the installer again, there is
> >> no way to "reinstall" plsql.
> >>
> >> what can i do?
> >>
> >> and even if i can reinstall plsql, how do i make sure every package is
> >> properly recompiled? is there an inventory i can use somewhere?
> >>
> >> please help ...
> >>
> >> tonys.
>
Received on Wed Aug 02 2000 - 00:00:00 CDT