| 8GB RAM - Windows Server 2003 - ORACLE 9.2 [message #112686] |
Mon, 28 March 2005 13:48  |
JANY
Messages: 1
Registered: March 2005
|
Junior Member |
|
|
JANY Posted At 04:25:25 03/27/2005
---------------------------------------------------------------
Autor: JANY [62.65.180.xxx]
Date: 28.3.2005 20:30:38
---------------------------------------------------------------
HI,
I have problem with Windows Server 2003 Enterprise, I have 8GB RAM and Oracle 9.2.0.4. I have turn on PAE a AWE in boot.ini for support >2GB RAM. In oracle I have turn on support for Very Large Memory (VLM) and I have Oracle SGA setting on 5GB. But I have problem, error message on workong database: ORA-04030....
ORA-04030: out of process memory when trying to allocate 32 bytes (callheap,qerrmbv[]: qerrmObnd)
For customers having access to Microsoft® Visual Studio® 6 development environment can use editbin.exe as an alternative to imagecfg.exe:
Using editbin.exe utility, generally found in C:\Program Files\Microsoft Visual Studio\VC98\bin, the syntax is as follows:
---------------------------------
editbin.exe /LARGEADDRESSAWARE oracle.exe
---------------------------------
In my utility IMAGECFG.EXE (for windows 2003) I have not check " -l " !!!
*********************************************
Picture with my error message is on www link:
http://www.mujweb.cz/www/vitkovic/CHYBA.jpg
*********************************************
Thank you very much !
JANY
vitkovic@pobox.sk
I read on oracle metalink about .... , and that :
(shared_pool+large_pool+java_pool+pga_target+AWE_WINDOW_MEMORY) < 2GB-2.2GB (2252 MB)
----- MY NEW SETTING SGA ----------------------------
-----------------------------------------------
buffer cache = 5700 MB ( calculate only 1000 MB as AWE_WINDOW_MEMORY)
--------------------------------------------
shared pool = 360 MB -> Library and Dictionary cache
large pool = 64 MB -> For shared server (parall.execution)
java pool = 24 MB -> For javu
pga target = 800 MB -> automatic ( max_concurent_session and sort_area_size )
--------------------------------------------------------------
TOTAL = 2248 MB < 2.2 GB ( 2252 MB )
--------------------------------------------------------------
Is this NEW setting parameter of SGA is OK ?
My oracle server working this time OK, but is this setting OK ?
Will memory use for ORACLE.EXE > 5 000 000 K OK ? (5GB)
Thanks.
vitkovic@pobox.sk
JANY
-
Attachment: CHYBA.jpg
(Size: 141.63KB, Downloaded 4576 times)
|
|
|
|
| Re: 8GB RAM - Windows Server 2003 - ORACLE 9.2 [message #112812 is a reply to message #112686] |
Tue, 29 March 2005 08:48  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
Looks like you have researched this more than I, so I can't help much, but it sounds like you need to discuss it both with the vendor support where you got your 2003 server as well as oracle support. I seem to remember the Dell people telling me that we had to either do or actually buy something extra to get anything more than 4 gigs of memory to work on our 2003 box. Will 32 bit cpu do it or need 64? This is definitely something I would expect my hardware vendor's support on, regardless of what application (oracle) I was running. Maybe even write a tiny c program (or find some utility) that attempts to allocate say 6 gigs, and see if the OS actually allows it. Confirm that first before adding the oracle complications.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
