Implementing AWE ORA-00371: not enough shared pool memory solved

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Thu, 21 Aug 2008 12:48:16 -0400
Message-ID: <cd4305c10808210948n2a98b149jb390540218bc8973@mail.gmail.com>

Hi,
Trying to implement awe on windows 2003 enterprise edition oracle 10.2.0.3.0, based
on document:

Subject: Implementing Address Windowing Extensions (AWE) or VLM on Windows Platforms

      Doc ID: Note:225349.1

I started to receive the message
ORA-00371: not enough shared pool memory, should be atleast 1189627904 bytes I searched around and it was as an unresolved bug in metalinkg, and it gave another error similar to the lack of Lock pages in memory' privilege.

After several hours I found the error was ridiculous simple, when implementing awe you can't use db_cache_size you must use db_block_buffers So, I run my script to enable it after configuring s2003 os and set cache to 200M the mistake I did is to forget db_cache_size can be expressed in bytes but db_block_buffers was in blocks

This are the 4 situations I had
1)
db_block_buffers=200000000
SQL> startup
ORA-00371: not enough shared pool memory, should be atleast 1189627904 bytes

2)
db_block_buffers=100000000
SQL> startup pfile=E:\ORASSUN\init\initsun2.ora ORA-27102: out of memory
OSD-00014: informaci+n adicional sobre errores

3)
db_block_buffers=25000
SQL> startup pfile=E:\ORASSUN\init\initsun2.ora ORA-27100: shared memory realm already exists

4)
restart service from os
SQL> startup pfile=E:\ORASSUN\init\initsun2.ora Instancia ORACLE iniciada.

Total System Global Area 465567744 bytes

Fixed Size                  1290012 bytes
Variable Size             252379364 bytes
Database Buffers          204800000 bytes
Redo Buffers                7098368 bytes

Base de datos montada.
Base de datos abierta.
SQL> I post this solution because I couldn't find this solution on internet and there were other people having the same problem.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 21 2008 - 11:48:16 CDT