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

You could try to enable tracing (sql_trace = true ) in init<sid>.ora. This will at least dump the *exact* statement in error to the trace file. Support might need it.
Otherwise, no other option than to reinstall completely. Pl/sql can't be installed separately.

Regards,

Sybrand Bakker, Oracle DBA

"Tony Simopoulos" <karkalis_at_earthling.net> wrote in message news:cecbosgjho10rv5vrp11mpqh29tt2prgca_at_4ax.com...
> On Mon, 31 Jul 2000 18:49:50 +0200, "Sybrand Bakker"
> <postbus_at_sybrandb.demon.nl> wrote:
>
> thanks ... BUT
>
> i am getting TONS of ERRORS while running this script. here is an
> example.
>
> <snip>
> Statement processed.
> Statement processed.
> Statement processed.
> create or replace view gv_$dlm_convert_remote as select * from
> gv$dlm_convert_re
> mote
> *
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00904: invalid column name
> Statement processed.
> Statement processed.
> Statement processed.
> create or replace view gv_$dlm_all_locks as select * from
> gv$dlm_all_locks
> *
> ORA-00604: error occurred at recursive SQL level 1
> ORA-00904: invalid column name
> Statement processed.
> Statement processed.
> <snip>
>
> i believe the invalid column name is because of SYS.STANDARD, which my
> DBMS claimed was no longer valid .. so i dropped it. when trying to
> rerun "standard.sql" .. to recreate, i get the same bad column error.
>
> what to do??
>
> tonys.
>
> >You need to rerun
> >%ORACLE_HOME%\rdbms\admin\catalog.sql
> >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