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

Yaa, that is correct. YOu just need to rerun "catproc.sql", and that should take of it. Remember you have to run that as 'sys'.

Amit
Oracle DBA/Unix SA

Richard Wilson wrote:

> 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