STANDARD package not installed on Linux RH 6.1 
Author Message
 STANDARD package not installed on Linux RH 6.1

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

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

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.



Wed, 18 Jun 1902 08:00:00 GMT
 STANDARD package not installed on Linux RH 6.1

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:

  1) 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>

  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"



Quote:
> 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

> (c) Copyright 1999 Oracle Corporation.  All rights reserved.

> 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.



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Oracle Enterprise don't install in Linux RH 6.1

2. installing client on Linux RH 6.1

3. Installation failure for Oracle 815 on RH linux 6.1

4. Help RH 6.1 Linux 8i Installation

5. Need help on Oracle 8051EE for RH-Linux 6.1

6. Oracle 8.0.5 on RH Linux 6.1

7. Which Linux Sybase ok with RH 6.0/6.1?

8. D3 Linux 7.2 RH 6.1 error

9. Installing 8.1.5EE on RH 6.1

10. Installing Oracle 8i 8.1.6 on RH 6.1

11. HELP : Installing Oracle 8i 8.1.6 on RH 6.1

12. 8.1.5.0 on RH 6.1 install quits


 
Powered by phpBB® Forum Software