ORA-27102: out of memory during installation of SAP

[Former Member]

Hello,

I am installing NW 7.1 on Windows/Oracle.

When SAPINST reaches the phase where it creates the database, then i get this error:

ORA-27102: out of memory

"

SQL*Plus: Release 10.2.0.2.0 - Production on On Jul 22 09:36:12 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

ORA-27102: out of memory

OSD-00029: additional error information

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

Disconnected

"

I read some posts that i should change sga_max_size and other parameters, but how do i do this? Because oracle uses internal variable and not init<SID>.ora for parameters...

Any ideas on what to do?

Regards,

Kenneth

[Former Member]

Did you set 3GB or PAE switch in windows boot.ini file? Set your paging file 3 to 4 times of your RAM and 3GB in boot.ini (if your system is 32 bit) and give a go.

[http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx]

[Former Member]

Hello,

It is 64bit windows (x64).

Do i still need to set 3GB and PAE then?

/Kenneth

[Former Member]

No.

[Former Member]

You can copy the spfileSID.ora to initSID.ora and edit sga_max_size directly. Then rename the spfile, oracle will then automatically use the initSID.ora.

At the end, just create a new spfile: SQL> create spfile from pfile;

Regards, Michael

[Former Member]

Hmm, i actually think i managed to get past it.

I reinstalled using SAPINST and when it asked me how much memory the oracle instance shoud take, i just typed a much smaller value than the default.

The first time i did not notice that this value was way to high

So this was my own fault.

But thanks for the help guys.

Regards,

Kenneth

[Former Member]

Check this note on how to work with a spfile (also valid for 10g): [601157 - Oracle9i: Server Parameter File|https://service.sap.com/sap/support/notes/601157]

Basically you set parameters in SQLplus: alter system set <param> = <value> scope = <both|memory|spfile>

The error means you ran out of memory on the server. To reduce the sga might help here, you should look out for other processes consuming too much memory as well.

Regards, Michael

[Former Member]

I will try, but is it possible to change the parameter from sqlplus when i can't mount the database?

I can't even execute show parameters, because oracle is not available.

/Kenneth

[Former Member]

No, i can't change the parameter from sqlplus.

This is the complete ora_sql_result.log from sapinst:

================================================================================

2009-07-22, 10:32:17 SAPINST ORACLE start logging for

SHUTDOWN IMMEDIATE;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.2.0 - Production on On Jul 22 10:32:19 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Disconnected

SAPINST: End of output of SQL executing program I:\oracle\PMD\102/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2009-07-22, 10:32:19 SAPINST ORACLE stop logging

================================================================================

2009-07-22, 10:32:19 SAPINST ORACLE start logging for

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.2.0 - Production on On Jul 22 10:32:19 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected to an idle instance.

ORA-27102: out of memory

OSD-00029: additional error information

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

Disconnected

SAPINST: End of output of SQL executing program I:\oracle\PMD\102/bin/sqlplus.

SAPINST found errors.

SAPINST The current process environment may be found in sapinst_ora_environment.log.

2009-07-22, 10:32:19 SAPINST ORACLE stop logging

[Former Member]

Hi,

take a look @ these notes,

Note 491174 - Composite SAP note for ORA-01034

Note 743328 - Composite SAP note: ORA-27102

Regards,

Ravi