Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Shared memory on Solaris?

Shared memory on Solaris?

From: Jeff Halperin <jeff_at_basistech.com>
Date: 1997/05/08
Message-ID: <337230D7.8EE@basistech.com>#1/1

SQL*Plus reports that the package STANDARD is not accessible. It seems that the Oracle server is unable to allocate enough shared memory to create the STANDARD package.

System Configuration:
SunOS 5.5.1
Oracle7 Server Release 7.3.2.1.0
Sun SparcStation 5 with 32 MB main memory, 200 MB swap file

The gory details:
On logging on to SQL*Plus as 'system', the following error message appears:

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

Ran standard.sql. Did get ORA-04031: unable to allocate 4096 bytes of shared memory ("unknown object","PL/SQL MPCODE","BAMIMA: Bam Buffer")

I've been playing with shared_pool_size in init<db>.ora and SHMAX in /etc/system to try to get more shared memory.

Does anyone have any ideas?

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
Jeff Halperin             One Kendall Square      Tel: 617-252-5636
Basis Technology Corp.    Cambridge, MA 02139     Fax: 617-252-9150
jeff_at_basistech.com        U.S.A.                  www.basistech.com
Received on Thu May 08 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US