Re: $CRMPSC_GDZRO_64 failure when starting oracle7 on OpenVMS

Hi,

ORA-7690 indicates you do not have enough free global pages

   (SYSGEN parameter GBLPAGES) to map the SGA.

You must either:

1. Reserve memory for the SGA using the SYSMAN RESERVED_MEMORY command, or
2. Increase the SYSGEN parameter GBLPAGES to allocate sufficient free GBLPAGES. In OpenVMS V7.1, this SYSGEN parameter is dynamic, so it can be changed without having to reboot your system.

   The following chart can be used to estimate the number of GBLPAGES    required for different SGA sizes:

   Total System Global Area (bytes) GBLPAGES required

• ----------------- 4.9Mb, 5,005,668 bytes (default db) 9,952 9.8Mb, 10,005,668 bytes 19,696 19.5Mb, 20,005,668 bytes 39,296 48.8Mb, 50,005,668 bytes 97,968 97.7Mb, 100,005,668 bytes 195,600 488.3Mb, 500,005,668 bytes 977,680 976.6Mb, 1,000,005,668 bytes 1,955,152 1.953Gb, 2,000,005,668 bytes 3,910,208

You may also receive an ORA-7690 when restarting a database and

   users are still mapped to the SGA (i.e. not a clean shutdown).    Use the OpenVMS INSTALL utility ($ INSTALL LIST/GLOBAL) to determine    if any global sections corresponding to the SGA are still mapped or    are in "delete pending" state.

Vladimir

In article <7tenso$4dk$1_at_wanadoo.fr>,
  "Jean-Luc RAYON" <jl.rayon_at_wanadoo.fr> wrote:
> I try to increase the db_block_buffers parameter in the init.ora file
> on Oracle7 Server Release 7.3.3.4.0 under OpenVMS V7.1-1H2 on an Alpha
> server 800.
>
> But when I start the instance I obtain the error message:
>
> ORA-07690: smscre: $CRMPSC_GDZRO_64 failure
>
> The Oracle doc say for this error:
>
> Examine system error and refer to VMS documentation !
>
> But there is no system error message associated in the log file !
>
> Does anyone can tell me witch system parameter or account quota I have
to
> change?.
>
> Thanks,
>
> J-L RAYON
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 06 1999 - 03:14:02 CDT