Re: UREGENT HELP- i blew up the DB??

From: Richard Wilson <onyx01_at_globalnet.co.uk>
Date: 1998/01/15
Message-ID: <01bd214d$2c365ac0$3e5f7ec2@onyx>#1/1

Maybe you can re-run "catprocs.sql" (its in 7 but not sure about 8) to rebuild the packages and procedures.

Michael Will de Laforcade <mwill_at_dris.com> wrote in article <69jfu1$5g4$1_at_client3.news.psi.net>...
> If anyone could help with this I'd really appreciate it.
>
> I have Orcl8 installed with all default options.
> I tried creating a new instance. Didn't work.
>
> Went back to do other things and now I'm getting the following from
> SqlPlus8.
>
> It seems all system procs have been invalidated.
> Can this be fixed without a full reinstall..
>
> !!!!!!!!!!!!!!!!!! HELP!!!!!!!!!!!!!!!!!!!!!!! Michael.
>
>
>
> SQL*Plus: Release 8.0.3.0.0 - Production on Wed Jan 14 17:44:7 1998
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-06553: PLS-213: package STANDARD not accessible
>
>
> Error accessing package DBMS_APPLICATION_INFO
> ERROR:
> ORA-06553: PLS-213: package STANDARD not accessible
>
>
>
> Connected to:
> Oracle8 Release 8.0.3.0.0 - Production
> With the Partitioning and Objects options
> PL/SQL Release 8.0.3.0.0 - Production
>
> SQL>
>
>
>
Received on Thu Jan 15 1998 - 00:00:00 CST