ora-27100 shared memory realm already exists

[hare jjj]

HI All

 how to solve ora-27100 shared memory realm already exists .

 

This error came up when a /3GB switch was added and

pfile has these parameters

 

*.USE_INDIRECT_DATA_BUFFERS=TRUE
# Makes SGA 7.6G
#*.DB_BLOCK_BUFFERS=917504
*.DB_BLOCK_BUFFERS=458752

java_pool_size = 52428800
large_pool_size = 157286400
shared_pool_size = 419430400

*.pga_aggregate_target=203423744

 

 

It is MS windows 2003 Enterprise Edition server (R2) and 32 Bit.

Oracle - 10.2.0.3 Version

 

Please help me in this

 

 

Restart server and DB didnt work out

 

Regards

Hare

 

 

 

[ddf]

You're running 32-bit Oracle so you can't access any memory beyond 4
gig. Making the SGA 7.6 Gig is useless unless you upgrade to a 64-bit
release of Oracle.


David Fitzjarrell

[Aravindkumar Annamalai]

Hi Hare,

 

Please go through this metalink note 370469.1.I hope this will be usefule for you.

 

Regards,

Arvind

[mogobadi]

Hey,

Try to stop and start the database service. If nothing happens startup
the db in nomunt using the pfile, if it goes thru den the problem is
not with the SGA if it doesnt you need to adjust (reduce) your memory
parameters.