Re: Shared memory on Solaris?

> 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

The default amount of shared memory should be fine. I do not remember what the shared pool value is but if you look at the ORACLE_HOME/dbs/init.ora you will see the defaults for a small db. I would flush the shared pool then try running catproc.sql again and see if the problem still exists. Received on Mon May 12 1997 - 00:00:00 CDT