Re: package STANDARD not accessible

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 8 Feb 2002 06:36:11 +1100
Message-ID: <3c62d728$0$32593$afc38c87@news.optusnet.com.au>

You have to run catalog and catproc whilst connected as SYS, not SYSTEM. Your connection AS SYSDBA will suffice. You also have to run catalog before catproc.

Other than that, it's difficult to advise further because you aren't being terribly specific (an O/S would help, for a start). Did you create your own database, or get the install to create a starter database for you? What does the alert log say? What do you mean that you tried re-running catalog and catproc "to no avail" -who were you logged on as at the time? what error messages did you get?

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"James Keeley" <jkeeley_at_monsanto.com> wrote in message
news:3c6273c5_at_primark.com...


> Just completed a fresh Oracle8i install (8.1.6) and now get the following

> error unless I logon "AS SYSDBA":

>

> ERROR:

> ORA-06553: PLS-213: package STANDARD not accessible

>

> Error accessing package DBMS_APPLICATION_INFO

> ERROR:

> ORA-06553: PLS-213: package STANDARD not accessible

>

> I've tried rerunning the catalog.sql and catproc.sql scripts to no avail.

>

> It seems I'm missing some sort of privledge for SYS and SYSTEM that I

> expected to be set by default.

>

> Any assistance would be appreciated.

>

> Regs!

>

>

Received on Thu Feb 07 2002 - 13:36:11 CST