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

Sorry...

It may be that your standard.sql script is corrupt, but, more likely, it is a platform specific bug...what platform are you installing this on ( I had a similar problem with 8.1.5 on Netware )...

The only columns named in standard are in procedure and function definitions so I doubt if there is a 'truly' invalid name in there ( Oracle wrote the code, after all) ...

You may want to resort to Oracle support....

Tony Simopoulos <karkalis_at_earthling.net> wrote:

>On Mon, 31 Jul 2000 16:58:42 GMT, johng_at_mm.com (TurkBear) wrote:
>
>thanks ... i have tried the CATALOG.SQL and CATPROC.SQL.
>
>the first thing that CATALOG.SQL does is try to run STANDARD.SQL which
>fails.
>
>here is my error:
>rem Load PL/SQL Package STANDARD first, so views can depend upon it
>@@standard
>create or replace
>package STANDARD is ...
>
>ORA-00604: error occurred at recursive SQL level 1
>ORA-00904: invalid column name
>
>the rest is history. what column is bad???
>
>now, if i de-install and re-install what product to i de-install.
>
>if i choose to de-install PL/SQL, it requires a de-installation of the
>entire SERVER, among other utilities.
>
>finally, on an install, there PL/SQL is not even listed as a product
>or utility, so i can't even "re-install" it. what needs to be done??
>
>tonys.
>
>>
>>Without knowing what error you got with sys.standard, it is hard to tell if you
>>need any drastic steps to get up and running...
>>
>>Try this, before doing a reinstall
>>
>>the 'admin' directory you are seeking is ( should be) under the RDBMS
>>directory...there is another Admin directory directly under Oracle_Home but that
>>is a different one...
>>
>>If it is there, just re-run catalog and catproc ( while connected as sys or
>>internal)
>>
>>These will build ( or rebuild) the packages you need...
>>
>>If it is not there, then a reinstall, from scratch, is probably the best idea (
>>de-install first)
>>
>>hth
>>
>>Tony Simopoulos <karkalis_at_earthling.net> 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 Mon Jul 31 2000 - 00:00:00 CDT