Re: Package standard - 9i for W2000 installation

Thank you Paul, Jared, Yosi,

One of my friend checked my database, and he discovered that my database is not working properly. We removed the database and installed it again. Now it is working well. He also does not know what was the problem.

Thank you very much for your instant help, Harun.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, October 01, 2001 12:25 AM

> Harun,
>
> connect in sqlplus as user sys and execute:
>
> ALTER PACKAGE dbms_standard COMPILE;
>
> hth,
>
> Paul
>
>
> Harun Altay wrote:
> >
> > I did it at last, as you and Jared had described. I run that script. I
got
> > those messages below. Later on, I tryed to give privilages to SYS user
by
> > administrator, and I got the same error message as before : ORA-06553:
> > PLS-213: package STANDARD not accesible.
> >
> > Thanks.
> >
> > the very(!) last part of the output message in the ms-dos screen for
> > SQL*Plus is below:
> >
> > ------------------------------------------------------------------
> > create or replace public synonym dba_ias_objects for dba_ias_objects
> > *
> > ERROR at line 1:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-06553: PLS-213: package STANDARD not accessible
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul Drake
> INET: paled_at_home.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harun Altay
  INET: haltay_at_indiana.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).