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

From: Fred Pierce <fpierce_at_avialantic.com>
Date: 2000/08/01
Message-ID: <3986BDD5.5CA0A6D5@avialantic.com>#1/1

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 Tue Aug 01 2000 - 00:00:00 CDT