Re: Shared memory on Solaris?

Jeff Halperin wrote:
>
> 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

Are you trying to run catproc.sql to install the procedure option? Use sqldba or server manager might help.

Bob Received on Tue May 13 1997 - 00:00:00 CDT