Home » RDBMS Server » Server Administration » Want to use 32GB RAM in oracle 9i (Windows Server 2003 Ent. (32bit), Oracle9i 9.2.)
icon5.gif  Want to use 32GB RAM in oracle 9i [message #415751] Wed, 29 July 2009 02:22 Go to next message
pinkalsolanki
Messages: 25
Registered: December 2008
Location: Surat/Gujarat
Junior Member

Hi..
I have IBM x3950 Server with 32GB of RAM, WINDOWS SERVER 2003 ENT.(32BIT), ORACLE 9I 9.2.0.2,


my problem is that,, at time of database creation in DATABASE ASSISTANT CONFIGURATION oracle display only 2gb ram avaiable at time ram allocation for SGA ,

so, how can i use full 32gb of ram in oracle 9i
even os also displaying 32gb ram in my computer property.

so please suggest me what configuration i need to use full ram
which os i need,

- Pinkal
Re: Want to use 32GB RAM in oracle 9i [message #415857 is a reply to message #415751] Wed, 29 July 2009 09:47 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
By default, 32-bit can't address that amount of memory. You can consider AWE/PAE to address more memory on 32-bit architecture.

[Updated on: Wed, 29 July 2009 09:48]

Report message to a moderator

Re: Want to use 32GB RAM in oracle 9i [message #415954 is a reply to message #415751] Wed, 29 July 2009 23:09 Go to previous messageGo to next message
pinkalsolanki
Messages: 25
Registered: December 2008
Location: Surat/Gujarat
Junior Member

Thanks for reply.

I have already done,

i have added " /PAE " in boot.ini file and i also added "/3GB" for to enable 4GT.

and i also created registry string parameter "AWE_WINDOW_MEMORY" with value of " 1288490188 " (1.2 GB) in registry in ORACLE DATABASE HOME...


but, thereafter i am unable to locate full(32gb) memory or more than 2 gb ram in database creation.

- Pinkal
Re: Want to use 32GB RAM in oracle 9i [message #416003 is a reply to message #415954] Thu, 30 July 2009 02:25 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Which is the way it is. Read up on what /PAE and /3GB actually do.

They just allow the OS to give more RAM to all running applications. But a single application will never be able to address 32GB on a 32bit system.

Re: Want to use 32GB RAM in oracle 9i [message #416209 is a reply to message #415751] Fri, 31 July 2009 03:24 Go to previous messageGo to next message
pinkalsolanki
Messages: 25
Registered: December 2008
Location: Surat/Gujarat
Junior Member

So, i want to know that which OS and Oracle version i need to get benefit of 32gb ram ORACLE.

i have to go for 64bit OS and 64bit oracle 9i version or something else.. please suggest me.


- Pinkal
Re: Want to use 32GB RAM in oracle 9i [message #416211 is a reply to message #416209] Fri, 31 July 2009 03:40 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Yes, you need x64 Windows and Oracle.
Re: Want to use 32GB RAM in oracle 9i [message #416217 is a reply to message #415751] Fri, 31 July 2009 04:38 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do you really need to use all 32G for oracle?
I don't have a single production machine running on more than 4G.
Re: Want to use 32GB RAM in oracle 9i [message #416297 is a reply to message #415751] Fri, 31 July 2009 08:45 Go to previous messageGo to next message
pinkalsolanki
Messages: 25
Registered: December 2008
Location: Surat/Gujarat
Junior Member

i have 32gb available ram,
but i want atleast more than 2gb ram should be display (for available ram) at a time of memory allocation during database creation.

i want to use atleast 8gb ram for database.

- Pinkal
Re: Want to use 32GB RAM in oracle 9i [message #416375 is a reply to message #415751] Sat, 01 August 2009 04:29 Go to previous messageGo to next message
pinkalsolanki
Messages: 25
Registered: December 2008
Location: Surat/Gujarat
Junior Member

can i install oracle9i rel 2 (64-bit) On Intel Xeon Processor ?

bcoz, there is only Itanium Processor is suggested in system requirement in installation guide of Oracle9i 64-bit.


Re: Want to use 32GB RAM in oracle 9i [message #416384 is a reply to message #416375] Sat, 01 August 2009 06:04 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Nope. Iitanium is a completely different beast. Xeon is "EM64T"

Alas, when you browsed down the Certification Matrix you will find :

Quote:

There is no 64-bit version of 9iR2 nor 10gR1 for 64-bit Windows on AMD64/EM64T hardware



So you need to install 10gR2 at least.
Previous Topic: DBCA error
Next Topic: Miscellaneous Part in Shared Pool
Goto Forum:
  


Current Time: Mon Dec 05 20:57:59 CST 2016

Total time taken to generate the page: 0.10017 seconds