Re: Problem installing Des2000

From: Allan Kelly <ac_kelly_at_bellsouth.net>
Date: 1999/03/21
Message-ID: <NS8J2.12575$Ek.12937283_at_news1.mia>#1/1


The first error is being caused by the settings in your INIT.ORA file. Increase SHARED_POOL_SIZE parameter. You may have to resize the kernel parameters and rebuild the kernel to accomodate this. The second error is a SQL*Plus error. Find the particular script that builds this package and insert a "SET MAXDATA 60000" before the call to "CREATE PACKAGE BODY cdbh_fhrg".

Allan

>Here are parts of the log file generated by that particular step:
>
>Loading rmac.opb...
>Loading rman.opb...
>Loading rmand.opb...
>create or replace
>*
>ERROR at line 1:
>ORA-04031: unable to allocate 1024 bytes of shared memory ("shared
>pool","CIOORACLE_DB_USER_GROUPREPOS","PL/SQL DIANA","PAR.C:parapt:Page")
>
>
>Loading rmdc.opb...
>Loading rmdd.opb...
>Loading rmdq.opb...
>Loading rmet.opb...
>
>and:
>
>Creating package body CDI_NETWORK_REPORTS ...
>Building cdbls Body ....
>Building cdbh_fhrg Body ....
>buffer overflow. Use SET command to reduce ARRAYSIZE or increase MAXDATA.
>No errors.
Received on Sun Mar 21 1999 - 00:00:00 CET

Original text of this message