Oracle Database Discussions

Hi,

I installed Oracle DB 10gR2 on Windows 2003 Server Enterprise Edition and created a database using DBCA. In DBCA I specified to use 60% of the system memory for the database instance. After creation, sga_max_size and sga_target parameters were set to 892M (the system has 8GB RAM). I decided to increase sga_max_size to 4GB.

ALTER SYSTEM SET SGA_MAX_SIZE=4G SCOPE=SPFILE.

After that I tried to restart the instance using SHUTDOWN IMMEDIATE and STARTUP commands but a problem occured. The startup command returned:

ORA-27102: out of memory
OSD-00022: additional error information
O/S-Error: (OS 8) Not enough storage is available to process this command.

I decided to restart oracle service but it didn't help. Instance didn't start correctly. The startup command returned:

ORA-27100: shared memory realm already exists

The command sequence: SHUTDOWN ABORT and STARTUP also didn't help.

I restored old copy of spfile and the instance started correctly, but again with 892MB of SGA.

I tried to increase the value of sga_max_size step by step (adding 100MB in each step). Everything worked till sga_max_size was about 1800MB. Above this value instance couldn't restart. But even with 1800MB the instance sometimes couldn't start. I had to go back to 892MB, with this value everything works fine.

Does anybody know what to do? Is there any way to have 4GB SGA on Windows 2003 Server?

Regards,
Tim