how to relink oracle to use the -N linker option for Memory windows

[dawood mamsa]

We need to run an oracle 8.1.7.4 (32 bit instance with more than 1.75GB.

where do I change the linker option to -N to use the EXEC_MAGIC executable format...I do know I can change it to use SHEM_MAGIC using chatr -M oracle.

Help is appreciated!

[Yogeeraj_1]

hi,

it seems like the changing the memory mode on the executables is not supported.

Oracle recommends that, if you need more than 1.75G, use Oracle 64bit and HP 11.0 64bit which eliminates the 1.75G limit.

i also found the a Doc ID: 212527.1
(see attachment)

hope this helps!
regards
Yogeeraj

[Yogeeraj_1]

Doc ID: 212527.1

[Patrick Wallek]

We recently began using memory windows with our Oracle 8.1.7 databases. No relink was required. I changed the maxmemwin kernel parameter, set up the /etc/services.window file with the Oracle instance names and when we started the Oracle instances up, they used memory windows automatically.

You may not actually need to relink Oracle. Give it a shot first without relinking and you may save yourself some work.

[dawood mamsa]

Thanks for your replies. I did update the ins_rdbms.mk file to reflect the -N linker option. WHen I chatr the oracle executable I do see that it says"Normal SHMEM_MAGIC executable'. My maxdsize is set to 2.5GB..

I still cant get oracle to start with more than 1.75GB of SGA.....what am i missing

[Steven E. Protter]

I think you need to use the 64 bit verson of the db accomplish your goal.

I can't believe Oracle is telling you to do it.

Attaching a conversion doc.

SEP

[dawood mamsa]

Steven;

Yes ideally 64-bit oracle is way to go and I would do it in a heart beat :-) but its not an option.

[A. Clay Stephenson]

Man chatr and look for SHMEM_MAGIC; you will find that 1.75GB is the limit. If you must have more then 64-bit land is your only viable option.

[dawood mamsa]

How about this thread..
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xfad968da2286d711abdc0090277a778c,00.html


according to this "SHMEM_MAGIC makes 2.75 GB of shared memory available to an application"


what am i missing?