Re: Repository build problem

Hi,

You will have to increase the size of the SAHRED_POOL_SIZE in the initORCL.ora
(or init.ora?) file. It will be in the $ORACLE_HOME\DATABASE directory. Make it to 9000000 or even more. it should look like

shared_pool_size = 9000000                                          # LARGE

If you have less memory,
you can reduce this parameter
once you install the repository.

HTH Madhu Cherukuri

Mark Lichtenberg wrote:

> Hello, we are having problems when building our repository. Everthing
> works fine until it gets to the package install. We recieve an error
> "ORA-04031 - unable to allocate bytes of shared memory" Because of this,
> we are unable to create an application in Designer 2000. This is for a
> college course, and many of us are having this exact problem. We are using
> Personal Oracle 7 on Win95 and NT. Thanks in advance....
>
> ---------------------------------------
> ////
> |..| o o Mark Lichtenberg
> c >| o markl_at_radiks.net
> \'/
> /><\
Received on Fri Nov 06 1998 - 02:20:57 CET