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

I didn't....
The version was, actually, 8.0.5 not 8.1.5 and happened when I tried to export grants, etc in addition to data ....Oracle support could not replicate the error , nor could they solve it..
I solved it by upgrading to 8.1.5 -
8.1.6 is not available on Netware yet ( its the 'poor relation' OS as far as Oracle is concerned)..

I had no problems with my NT 8.1.5 to 8.1.6 upgrade.... sorry :-(   

Tony Simopoulos <karkalis_at_earthling.net> wrote:

>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