Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Shared memory on Solaris?
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.comReceived on Thu May 08 1997 - 00:00:00 CDT
![]() |
![]() |