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

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