Implementing AWE ORA-00371: not enough shared pool memory solved
- From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 21 Aug 2008 12:48:16 -0400
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.
Other related posts:
