Re: STANDARD package not installed on Linux RH 6.1

From: Yass Khogaly <ykhogaly_at_us.oracle.com>
Date: Mon, 22 Nov 1999 17:25:35 -0800
Message-ID: <81cmrq$43i$1@inet16.us.oracle.com>

Problem Explanation:

The PL/SQL compiler could not find package STANDARD in the current Oracle database. To compile a program, PL/SQL needs package STANDARD.

Search Words:

PLS-00213 ORA-1933 Solution Description:

You need to verify the package STANDARD is valid and owned by SYS. Do the following:

Check the status of the package STANDARD using:

connect sys/<password>
SQL> SELECT * FROM DBA_OBJECTS WHERE OWNER = 'SYS' AND OBJECT_NAME = 'STANDARD'; If you find the status is 'INVALID' then:

SQL> ALTER PACKAGE STANDARD COMPILE; You may also find that a number of other packages are in 'INVALID' state. They should ALL be (re)compiled.

If you find STANDARD does not exist then:

Verify "$ORACLE_HOME/rdbms/admin/standard.sql" exists.

If this file does not exist then:

     You probably did not install PL/SQL.
     You must use the Installer to install PL/SQL.

If the file does exist then:

Verify that your ORACLE_SID is set correctly:

     SQL> connect sys/<password>
     SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql

2) Verify that STANDARD is owned by SYS:

SQL> SELECT * FROM DBA_OBJECTS WHERE OBJECT_NAME = 'STANDARD';

     If OWNER != SYS then catproc.sql was not correctly executed
     by SYS.  You will have to drop these packages and rerun catproc
     as SYS.

  3) Try running "catalog.sql" and "catproc.sql" while opening a spool file
     to catch any errors that may have occurred.

Look for Errors like:

ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 2192 bytes of shared memory ("shared pool,

","PROCEDURE$","KQLS heap","KQLS MEM BLOCK")

  Create or Replace:
  *
  ORA-06553: PLS-213: package STANDARD not accessible

grant execute on STANDARD to public

ORA-04042: procedure, function, package, or package body does not exist

In this case, you would need to increase the "SHARD_POOL_SIZE" in the "init<sid>.ora".

Then re-execute CATALOG and CATPROC.

Increasing "SHARED_POOL_SIZE" will allocate more resources and allow the scripts to run successfully.

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

Søren Asbjørn Hattel <sah_at_firmamentet.dk> wrote in message news:3839CA21.2FF59FFC_at_firmamentet.dk...
> Hi there,

> I thought that I finally got the Oracle 8i installed, but failed at
> this point, when I started to create tables with sqlplus:
> ------------------------------------------------------------------

> SQL*Plus: Release 8.1.5.0.0 - Production on Tue Nov 23 02:51:14 1999

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

>
>

> Error accessing package DBMS_APPLICATION_INFO
> ERROR:
> ORA-06553: PLS-213: package STANDARD not accessible

>


> -------------------------------------------------------------------------


>

> Is far as I can read from this the STANDARD package is missing from the
> installation. Unfortunately something broke during GUI installation, but
> I thought that I had it all done by hand. Anyone has a hint on how to
> install the STANDARD package?

>
>

> --
> F I R M A M E N T E T A / S
> Kong Georgs Vej 21, 1. Søren A. Hattel
> 2000 Frederiksberg Webchef
> T 3888 0833 F 3888 0837 Civilingeniør, ph. d.
>
> Received on Mon Nov 22 1999 - 19:25:35 CST