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

On Mon, 31 Jul 2000 18:22:43 GMT, johng_at_mm.com (TurkBear) wrote:

my platform is NT 4.0.

how did you resolve your problem on Netware??

>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