OraFAQ Forum: Server Administration » Want to use 32GB RAM in oracle 9i

Home » RDBMS Server » Server Administration » Want to use 32GB RAM in oracle 9i (Windows Server 2003 Ent. (32bit), Oracle9i 9.2.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Want to use 32GB RAM in oracle 9i [message #415751]

Wed, 29 July 2009 02:22

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

Report message to a moderator

Re: Want to use 32GB RAM in oracle 9i [message #415857 is a reply to message #415751]

Wed, 29 July 2009 09:47

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

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

Report message to a moderator

Re: Want to use 32GB RAM in oracle 9i [message #416003 is a reply to message #415954]

Thu, 30 July 2009 02:25

ThomasG
Messages: 3211
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.

Report message to a moderator

Re: Want to use 32GB RAM in oracle 9i [message #416209 is a reply to message #415751]

Fri, 31 July 2009 03:24

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

Report message to a moderator

Re: Want to use 32GB RAM in oracle 9i [message #416211 is a reply to message #416209]

Fri, 31 July 2009 03:40

hristo
Messages: 258
Registered: May 2007

Senior Member

Yes, you need x64 Windows and Oracle.

Report message to a moderator

Re: Want to use 32GB RAM in oracle 9i [message #416217 is a reply to message #415751]

Fri, 31 July 2009 04:38

cookiemonster
Messages: 13925
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.

Report message to a moderator

Re: Want to use 32GB RAM in oracle 9i [message #416297 is a reply to message #415751]

Fri, 31 July 2009 08:45

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

Report message to a moderator

Re: Want to use 32GB RAM in oracle 9i [message #416375 is a reply to message #415751]

Sat, 01 August 2009 04:29

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.

Report message to a moderator

Re: Want to use 32GB RAM in oracle 9i [message #416384 is a reply to message #416375]

Sat, 01 August 2009 06:04

ThomasG
Messages: 3211
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.

Report message to a moderator

Previous Topic:	DBCA error
Next Topic:	Miscellaneous Part in Shared Pool

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 04:30:45 CDT 2024