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

From: Tony Simopoulos <karkalis_at_earthling.net>
Date: 2000/07/31
Message-ID: <cecbosgjho10rv5vrp11mpqh29tt2prgca_at_4ax.com>#1/1

[Quoted] 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