Re: Shared Memory Error when installing Designer 2000, Help!
Date: 1999/01/07
Message-ID: <772nqb$7nh98_at_news.uscg.mil>#1/1
Read the installation manual.
You need to set your shared pool to 18,000,000 at the very least. After
install, if you're using personal Oracle, you can decrease this number
again - to around 10,000,000 without problems.
Also, check open cursors and block buffers. Designer requires quite a lot of
tablespace and memory.
Regards
Peter Larsen
Senior Oracle Consultant
Keith Kwiatek wrote in message <77014a$bm4$1_at_news.nist.gov>...
>Hello Oracle Guru,
>
>I was in the process of installing the designer 2000
>repository....everything seemed to be going fine, but then I got the
>printouts below.....what is this indicative of? How do I fix the problem? :
>
>RME-02123: Failed to parse SQL statement
>RME-02105: Oracle error occurred...
>ORA-04031: unable to allocate 1024 bytes of shared memory ("shared
>pool","CIOWEIGHTING_FACTORREPOSITOR","PL/SQL DIANA","PAR.C:parchk:page")
>
>ORA-04031: unable to allocate bytes of shared memory ("","","")
>Dumping Buffer...
>create or replace
>package body rmand as
>.....
>
>
>Thanks!
>
>Keith
>
>
Received on Thu Jan 07 1999 - 00:00:00 CET