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

You need to rerun
%ORACLE_HOME%\rdbms\admin\catalog.sql
[Quoted] and catproc.sql in the same directory, using svrmgrl. Please issue a spool command before starting this.

Replace %ORACLE_HOME% (NT) by $ORACLE_HOME (Unix).

There has never ever been a separate pl/sql admin directory.

Hth,

Sybrand Bakker, Oracle DBA

"Tony Simopoulos" <karkalis_at_earthling.net> wrote in message news:7t9bos8a78s9is72giofl8t2gj39leq3m6_at_4ax.com...
> 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 Mon Jul 31 2000 - 00:00:00 CEST