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 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: Yosi Greenfield 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).