Re: Package standard - 9i for W2000 installation

From: Harun Altay <haltay_at_indiana.edu>
Date: Sun, 30 Sep 2001 20:45:37 -0700
Message-ID: <F001.0039D072.20010930210018@fatcity.com>

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

Grant succeeded.

from system.repcat$_template_sites

*
ERROR at line 4:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

create or replace public synonym dba_ias_sites for dba_ias_sites
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

select 1 pkexists, cd.obj# from sys.cdef$ cd

ERROR at line 2:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

from system.repcat$_refresh_templates rt,

*
ERROR at line 4:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

create or replace public synonym dba_ias_gen_stmts for dba_ias_gen_stmts
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

from system.repcat$_template_objects ro

*
ERROR at line 4:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

select * from sys.dba_ias_gen_stmts_exp gs

ERROR at line 2:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

select * from sys.dba_ias_gen_stmts_exp gs

ERROR at line 2:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

create or replace package sys.dbms_ias_template as
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

create or replace public synonym dbms_ias_template for dbms_ias_template
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

CREATE OR REPLACE PACKAGE dbms_ias_inst wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

CREATE OR REPLACE PUBLIC SYNONYM dbms_ias_inst FOR dbms_ias_inst
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

CREATE OR REPLACE PACKAGE dbms_ias_mt_inst wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

CREATE OR REPLACE PUBLIC SYNONYM dbms_ias_mt_inst FOR dbms_ias_mt_inst
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

CREATE OR REPLACE PACKAGE dbms_ias_mt_inst_internal wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

CREATE OR REPLACE PACKAGE dbms_ias_inst_utl wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

CREATE OR REPLACE PACKAGE dbms_ias_inst_utl_exp wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

FROM dba_repgenerated r

*
ERROR at line 28:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

FROM sys.user$ u,

*
ERROR at line 5:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

FROM dba_cacheable_tables_base t

*
ERROR at line 4:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

create or replace public synonym DBA_CACHEABLE_TABLES for DBA_CACHEABLE_TABLES
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

FROM dba_cacheable_tables_base t

*
ERROR at line 9:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

create or replace public synonym DBA_CACHEABLE_OBJECTS_BASE
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

FROM dba_cacheable_tables_base t

*
ERROR at line 9:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

create or replace public synonym DBA_CACHEABLE_OBJECTS
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

CREATE OR REPLACE PACKAGE dbms_ias_template_utl wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

CREATE OR REPLACE PACKAGE BODY dbms_ias_template_utl wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

create or replace package body sys.dbms_ias_template wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

CREATE OR REPLACE PACKAGE dbms_ias_template_internal wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

Grant succeeded.

CREATE OR REPLACE PACKAGE BODY dbms_ias_template_internal wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

CREATE OR REPLACE PACKAGE BODY dbms_ias_inst wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

CREATE OR REPLACE PACKAGE BODY dbms_ias_mt_inst wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

CREATE OR REPLACE PACKAGE BODY dbms_ias_mt_inst_internal wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

CREATE OR REPLACE PACKAGE BODY dbms_ias_inst_utl wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

CREATE OR REPLACE PACKAGE BODY dbms_ias_inst_utl_exp wrapped
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1 ORA-06553: PLS-213: package STANDARD not accessible

SQL>

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, September 30, 2001 10:40 PM

> Harun,
>
> How about opening a command window, changing to the
> ORACLE_HOME/rdbms/admin directory, and then running
> catproc.sql.
>
> There's also a registry setting you can set somewhere, called
> SQLPATH (or is it SQL_PATH), that will tell Oracle where
> to look for SQL scripts. This is a more functional alternative,
> and you'd want to do that to name a general directory where
> you keep most of your regularly run scripts, but the first way
> is easier, quicker, and will get the job done, so you can get
> started.
>
> < I've been away for a while, and I'm not fully back for like
> two more weeks, but I'm back a little, in case anyone was
> wondering. >
>
> hth,
>
> Yosi
>
>
> Harun Altay wrote:
>
> > Hello Jared, and other friends,
> >
> > I am new in Oracle Administration. I have experience on MS SQL Server. I

> > in learning phase now.
> >
> > I have installed my first Oracle Database, as Oracle 9i for Windows2000,
> > previous week. I got a similar problem. There is SYS and SYSTEM users.

They
> > are not capable of adding a new table to SCOTT Schema, for example. I want
> > to give them more priviledges. I am running "Enterprise Manager Console",
> > and lounching it as "Standalone", connecting to database with the NT's > > "administrator" user. When I try to add some more priviledges to that users,

> > I am getting this message below:
> >
> > ORA-06553: PLS-213: package standard not accessible.
> >
> > I saw your advice for leo: that is "run
> > ORACLE_HOME/rdbms/admin/catproc.sql". I did it. I got the log below:
> >
> > Can you advice me something?  (other than reading manuals more :)
> >
> > Best Regards,
> > Harun.
> >
> > SQL*Plus: Release 9.0.1.0.1 - Production on Sun Sep 30 20:52:52 2001
> >
> > (c) Copyright 2001 Oracle Corporation.  All rights reserved.
> >
> > Connected.
> > Connected.
> > > SP2-0310: unable to open file "catprc.sql"
> > SP2-0310: unable to open file "catjobq.sql"
> > SP2-0310: unable to open file "catrpc.sql"
> > SP2-0310: unable to open file "dbmsstdx.sql"
> > SP2-0310: unable to open file "plitblm.sql"
> > SP2-0310: unable to open file "plspur.sql"
> > SP2-0310: unable to open file "pipidl.sql"
> >
> > Grant succeeded.
> >
> > SP2-0310: unable to open file "pidian.sql"
> >
> > Grant succeeded.
> >
> > SP2-0310: unable to open file "diutil.sql"
> > SP2-0310: unable to open file "pistub.sql"
> > SP2-0310: unable to open file "prvtpckl.plb"
> > SP2-0310: unable to open file "utlfile.sql"
> > SP2-0310: unable to open file "prvtfile.plb"
> > SP2-0310: unable to open file "utlraw.sql"
> > SP2-0310: unable to open file "prvtrawb.plb"
> > SP2-0310: unable to open file "utltcp.sql"
> > SP2-0310: unable to open file "prvttcp.plb"
> > SP2-0310: unable to open file "utlinad.sql"
> > SP2-0310: unable to open file "prvtinad.plb"
> > SP2-0310: unable to open file "utlsmtp.sql"
> > SP2-0310: unable to open file "prvtsmtp.plb"
> > SP2-0310: unable to open file "utlhttp.sql"
> > SP2-0310: unable to open file "prvthttp.plb"
> > SP2-0310: unable to open file "utlurl.sql"
> > SP2-0310: unable to open file "prvturl.plb"
> > SP2-0310: unable to open file "utlenc.sql"
> > SP2-0310: unable to open file "prvtenc.plb"
> > SP2-0310: unable to open file "catspace.sql"
> > SP2-0310: unable to open file "catactx.sql"
> > SP2-0310: unable to open file "catsvrmg.sql"
> > SP2-0310: unable to open file "dbmsutil.sql"
> > SP2-0310: unable to open file "prvthtxn.plb"
> > SP2-0310: unable to open file "dbmsapin.sql"
> > SP2-0310: unable to open file "dbmssyer.sql"
> > SP2-0310: unable to open file "dbmslock.sql"
> > SP2-0310: unable to open file "dbmspipe.sql"
> > SP2-0310: unable to open file "dbmsalrt.sql"
> > SP2-0310: unable to open file "dbmsotpt.sql"
> > SP2-0310: unable to open file "dbmsdesc.sql"
> > SP2-0310: unable to open file "dbmssql.sql"
> > SP2-0310: unable to open file "dbmspexp.sql"
> > SP2-0310: unable to open file "dbmsjob.sql"
> > SP2-0310: unable to open file "dbmsstat.sql"
> > SP2-0310: unable to open file "prvthddl.plb"
> > SP2-0310: unable to open file "prvthjob.plb"
> > SP2-0310: unable to open file "prvthsye.plb"
> > SP2-0310: unable to open file "prvthssq.plb"
> > SP2-0310: unable to open file "prvtutil.plb"
> > SP2-0310: unable to open file "prvtapin.plb"
> > SP2-0310: unable to open file "prvtsyer.plb"
> > SP2-0310: unable to open file "prvtlock.plb"
> > SP2-0310: unable to open file "prvtpipe.plb"
> > SP2-0310: unable to open file "prvtalrt.plb"
> > SP2-0310: unable to open file "prvtotpt.plb"
> > SP2-0310: unable to open file "prvtdesc.plb"
> > SP2-0310: unable to open file "prvtssql.plb"
> > SP2-0310: unable to open file "prvtsql.plb"
> > SP2-0310: unable to open file "prvtpexp.plb"
> > SP2-0310: unable to open file "prvtzhlp.plb"
> > SP2-0310: unable to open file "prvtzexp.plb"
> > SP2-0310: unable to open file "prvtjob.plb"
> > SP2-0310: unable to open file "prvtstas.plb"
> > SP2-0310: unable to open file "prvtstat.plb"
> > SP2-0310: unable to open file "dbmspsp.sql"
> > SP2-0310: unable to open file "prvtpsp.plb"
> > SP2-0310: unable to open file "dbmstran.sql"
> > SP2-0310: unable to open file "prvttran.plb"
> > SP2-0310: unable to open file "catrule.sql"
> > SP2-0310: unable to open file "dbmsread.sql"
> > SP2-0310: unable to open file "prvtread.plb"
> > SP2-0310: unable to open file "catxpend.sql"
> > SP2-0310: unable to open file "dbmslob.sql"
> > SP2-0310: unable to open file "prvtlob.plb"
> > SP2-0310: unable to open file "cattrans.sql"
> > SP2-0310: unable to open file "dbmstxfm.sql"
> > SP2-0310: unable to open file "prvttxfm.plb"
> > SP2-0310: unable to open file "catqueue.sql"
> > SP2-0310: unable to open file "catrm.sql"
> > SP2-0310: unable to open file "catdefer.sql"
> > SP2-0310: unable to open file "catsnap.sql"
> > SP2-0310: unable to open file "prvtdfrd.plb"
> > SP2-0310: unable to open file "prvtitrg.plb"
> > SP2-0310: unable to open file "prvtxpsw.plb"
> > SP2-0310: unable to open file "dbmspb.sql"
> > SP2-0310: unable to open file "prvtpb.plb"
> > SP2-0310: unable to open file "dbmssum.sql"
> > SP2-0310: unable to open file "dbmssnap.sql"
> > SP2-0310: unable to open file "dbmshord.sql"
> > SP2-0310: unable to open file "prvtxrmv.plb"
> > SP2-0310: unable to open file "prvtsnap.plb"
> > SP2-0310: unable to open file "prvtsum.plb"
> > SP2-0310: unable to open file "prvtsms.plb"
> > SP2-0310: unable to open file "prvtsmv.plb"
> > SP2-0310: unable to open file "prvtsma.plb"
> > SP2-0310: unable to open file "dbmshias.sql"
> > SP2-0310: unable to open file "prvtbias.plb"
> > SP2-0310: unable to open file "prvtbord.plb"
> > SP2-0310: unable to open file "dbmspbt.sql"
> > SP2-0310: unable to open file "prvtpbt.plb"
> > SP2-0310: unable to open file "catpitr.sql"
> > SP2-0310: unable to open file "dbmspitr.sql"
> > SP2-0310: unable to open file "prvtpitr.plb"
> > SP2-0310: unable to open file "catplug.sql"
> > SP2-0310: unable to open file "dbmsplts.sql"
> > SP2-0310: unable to open file "prvtplts.plb"
> > SP2-0310: unable to open file "utlrefld.sql"
> > SP2-0310: unable to open file "utlcoll.plb"
> > SP2-0310: unable to open file "prvtcoll.plb"
> > SP2-0310: unable to open file "dbmstrst.sql"
> > SP2-0310: unable to open file "prvttrst.plb"
> > SP2-0310: unable to open file "dbmsrman.sql"
> > SP2-0310: unable to open file "prvtrmns.plb"
> > SP2-0310: unable to open file "dbmsbkrs.sql"
> > SP2-0310: unable to open file "prvtbkrs.plb"
> > SP2-0310: unable to open file "catsnmp.sql"
> > SP2-0310: unable to open file "catrls.sql"
> > SP2-0310: unable to open file "dbmsrlsa.sql"
> > SP2-0310: unable to open file "prvtrlsa.plb"
> > SP2-0310: unable to open file "prvtctx.plb"
> > SP2-0310: unable to open file "catol.sql"
> > SP2-0310: unable to open file "dbmsol.sql"
> > SP2-0310: unable to open file "prvtol.plb"
> > SP2-0310: unable to open file "catodci.sql"
> > SP2-0310: unable to open file "prvtodci.plb"
> > SP2-0310: unable to open file "catar.sql"
> > SP2-0310: unable to open file "dbmsrpr.sql"
> > SP2-0310: unable to open file "prvtrpr.plb"
> > SP2-0310: unable to open file "dbmstrig.sql"
> > SP2-0310: unable to open file "dbmsrand.sql"
> > SP2-0310: unable to open file "dbmsobtk.sql"
> > SP2-0310: unable to open file "prvtobtk.plb"
> > SP2-0310: unable to open file "dbmslm.sql"
> > SP2-0310: unable to open file "prvtlm.plb"
> > SP2-0310: unable to open file "dbmslmd.sql"
> > SP2-0310: unable to open file "prvtlmd.plb"
> > SP2-0310: unable to open file "dbmsany.sql"
> > SP2-0310: unable to open file "prvtany.plb"
> > SP2-0310: unable to open file "catxml.sql"
> > SP2-0310: unable to open file "utlcxml.sql"
> > SP2-0310: unable to open file "prvtcxml.plb"
> > SP2-0310: unable to open file "dbmsmeta.sql"
> > SP2-0310: unable to open file "catmeta.sql"
> > SP2-0310: unable to open file "prvtmeta.plb"
> > SP2-0310: unable to open file "initmeta.sql"
> > SP2-0310: unable to open file "dbmscdcu.sql"
> > SP2-0310: unable to open file "dbmscdcp.sql"
> > SP2-0310: unable to open file "dbmscdcs.sql"
> > SP2-0310: unable to open file "prvtcdcu.plb"
> > SP2-0310: unable to open file "prvtcdcp.plb"
> > SP2-0310: unable to open file "prvtcdcs.plb"
> > SP2-0310: unable to open file "catfga.sql"
> > SP2-0310: unable to open file "dbmsfga.sql"
> > SP2-0310: unable to open file "prvtfga.plb"
> > SP2-0310: unable to open file "dbmsjdwp.sql"
> > SP2-0310: unable to open file "prvtjdwp.plb"
> > SP2-0310: unable to open file "dbmsjdcu.sql"
> > SP2-0310: unable to open file "dbmslms.sql"
> > SP2-0310: unable to open file "prvtlms.plb"
> > SP2-0310: unable to open file "dbmstypu.sql"
> > SP2-0310: unable to open file "prvttypu.plb"
> > drop package sys.wpiutl
> > *
> > ERROR at line 1:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-06553: PLS-213: package STANDARD not accessible
> >
> > SP2-0310: unable to open file "wpiutil.sql"
> > SP2-0310: unable to open file "dbmsepgc.sql"
> > SP2-0310: unable to open file "prvtepgc.plb"
> > SP2-0310: unable to open file "owainst.sql"
> > SP2-0310: unable to open file "dbmspump.sql"
> > SP2-0310: unable to open file "dbmsres.sql"
> > SP2-0310: unable to open file "prvtres.plb"
> > SP2-0310: unable to open file "dbmssjty.sql"
> > SP2-0310: unable to open file "prvtsjty.plb"
> > SP2-0310: unable to open file "dbmsdrs.sql"
> > SP2-0310: unable to open file "prvtdrs.plb"
> > SP2-0310: unable to open file "catrep.sql"
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Sunday, September 30, 2001 3:30 PM
> >
> > >
> > > run ORACLE_HOME/rdbms/admin/catproc.sql
> > >
> > > That should have been run when the database was created.
> > >
> > > Jared
> > >
> > > On Saturday 29 September 2001 19:25, Joe LaCascio wrote:
> > > > I've just installed 8.1.6.2.0, created a database and found that
> > > > dbms_standard is not there.  When I try to run utlrp.sql I get the
> > > > message STANDARD is not available.  I found this out because

DBMS_PIPE

> > > > is missing and can't create created unles DBMS_STANDARD is there.
> > > >
> > > > Any help would be appreciated.
> > > >
> > > > Joe
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Yosi Greenfield
>   INET: yosi_at_comhill.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).

Received on Sun Sep 30 2001 - 22:45:37 CDT