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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
