Skip to Content
avatar image
Former Member

Error:-ORA-27102: out of memory

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 8) 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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 13, 2011 at 06:29 AM

    Hi Krishna ,

    Please check below::

    Note 546006 - Problems with Oracle due to operating system errors

    Note 743328 - Composite SAP note: ORA-27102

    Thanks..

    Mohit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2011 at 07:24 AM

    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 8) 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

    Add comment
    10|10000 characters needed characters exceeded