Implementing AWE ORA-00371: not enough shared pool memory solved
Date: Thu, 21 Aug 2008 12:48:16 -0400
Trying to implement awe on windows 2003 enterprise edition oracle 10.2.0.3.0, based
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
ORA-00371: not enough shared pool memory, should be atleast 1189627904 bytes
SQL> startup pfile=E:\ORASSUN\init\initsun2.ora ORA-27102: out of memory
OSD-00014: informaci+n adicional sobre errores
SQL> startup pfile=E:\ORASSUN\init\initsun2.ora ORA-27100: shared memory realm already exists
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 bytesBase 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. Received on Thu Aug 21 2008 - 11:48:16 CDT