Re: Package standard - 9i for W2000 installation

Harun,

Here's a way that should work.

use a cmd window

  cd %ORACLE_HOME%/rdbms/admin
  sqlplus internal
  @catproc

This should take care of the problem

Jared

On Sunday 30 September 2001 20:15, Harun Altay wrote:

> Hello Jared, and other friends,
>
> I am new in Oracle Administration. I have experience on MS SQL Server. I am
> 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: Jared Still
> > INET: jkstill_at_cybcon.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: Jared Still
  INET: jkstill_at_cybcon.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).