Error:-ORA-27102: out of memory

[Former Member]

Hello,

We are performing HW migration, from WIN 2000 to WIN 2003 (Enterprise Edition) server in 32 bit version and our Database is Oracle 9.2.0.7.0.RAM 32 GB, SWAP 40gb, SAP SRM4.0(640)

We are facing the issue at the time of import in the target system phase at u201C Create Databaseu201D.

Please find below the error logs:

ORA-27102: out of memory

OSD-00029: Message 29 not found; product=RDBMS; facility=SOSD

O/S-Error: (OS 😎 Not enough storage is available to process this command.

To troubleshoot we have done following steps;

We have rebooted the server also uninstalled and installed from the begining but the same issue coming up.

We have decreased the SWAP to 20gb and rebotted the server and the same above error mentioned coming up.

Currently we are unable to connect to Oracle.

Please help!

Thanks and Regards,

[Former Member]

Ensure that the physical RAM is greater than the sga_max_size / sga_target

Ensure that the swap size follows the guideline

Between 1GB and 2GB then 1.5 times RAM

Between 2GB and 16 GB then match RAM

More than 16 GB then 16GB RAM

Check if oracle software version is 32bin

If oracle version is 32bit, the maximum SGA_TARGET / SGA_MAX_SIZE is 1.75gb

ORA-27102 out of memory

OSD-00034 Message 34 not found; Product=RDBMS;facility =SOSD

O/S Error: (OS 😎 Not enough storage is available to process this command

If you receive these errors when trying to start the database under 9.2 or higher, this may be because the AWE_WINDOW_MEMORY value in the registry is set too low for the calculated minimum value. If you cannot increase the value for AWE_WINDOW_MEMORY, then you can explicitly set DBBLOCK_LRU_LATCHES to a value lower than the calculated value, and retry the startup.

DBBLOCK_LRU_LATCHES must be at least 8 (equal to the maximum number of buffer pools).

The minimum value for AWE_WINDOW_MEMORY starting with 9.2 is calculated as such:

MIN(AWE_WINDOW_MEMORY)=(4096 * DB_BLOCK_SIZE * DBBLOCK_LRU_LATCHES)/8

let me know how it goes....

Regards

Vinod

[Former Member]

Hi Krishna ,

Please check below::

Note 546006 - Problems with Oracle due to operating system errors

Note 743328 - Composite SAP note: ORA-27102

Thanks..

Mohit