QL statement or script failed. DIAGNOSIS: Error message: ORA-27102: out of

[Former Member]

Dear all,

please help me4 on this

i am getting this error

FCO-00011 The step createDatabase with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|createDatabase was executed with status ERROR ( Last error reported by the step :Caught ESAPinstException in Modulecall: ORA-27102: out of memory

SVR4 Error: 22: Invalid argument

Disconnected

my logs are:

sapinst.log

ERROR 2011-12-18 09:40:34.550

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-27102: out of memory

SVR4 Error: 22: Invalid argument

Disconnected

. SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.

ERROR 2011-12-18 09:40:34.558

MUT-03025 Caught ESAPinstException in Modulecall: ORA-27102: out of memory

SVR4 Error: 22: Invalid argument

Disconnected

.

ERROR 2011-12-18 09:40:34.717

FCO-00011 The step createDatabase with step key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|createDatabase was executed with status ERROR ( Last error reported by the step :Caught ESAPinstException in Modulecall: ORA-27102: out of memory

SVR4 Error: 22: Invalid argument

Disconnected

.).

INFO 2011-12-18 09:57:09.852

An error occured and the user decided to stop.\n Current step "|NW_ABAP_OneHost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_CreateDB|ind|ind|ind|ind|0|0|NW_OraDBCheck|ind|ind|ind|ind|0|0|NW_OraDBMain|ind|ind|ind|ind|0|0|NW_OraDBStd|ind|ind|ind|ind|3|0|NW_OraDbBuild|ind|ind|ind|ind|5|0|createDatabase".

INFO 2011-12-18 09:57:15.747

Creating file /tmp/sapinst_instdir/.lastInstallationLocation.

INFO 2011-12-18 09:57:16.545

Creating file /tmp/sapinst_instdir/ERPEhP4/AS-ABAP/ORA/CENTRAL/__instana_tmp.xml.

oracle_sql_results.log

SQL*Plus: Release 10.2.0.4.0 - Production on Sun Dec 18 09:40:34 2011

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

Connected to an idle instance.

ORA-27102: out of memory

SVR4 Error: 22: Invalid argument

Disconnected

SAPINST: End of output of SQL executing program /oracle/PRD/102_64/bin/sqlplus.

SAPINST found errors.

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

2011-12-18, 09:40:34 SAPINST ORACLE stop logging

alert_prd.log

Sun Dec 18 09:40:34 2011

Starting ORACLE instance (normal)

Sun Dec 18 09:40:34 2011

WARNING: EINVAL creating segment of size 0x000000d8001b2000

fix shm parameters in /etc/system or equivalent

please sujest the solution very urjent pz........

[Former Member]

my INSTALLATION environment is

sun Solaris 10 ldom

j2sdk1.4.2_19

oracle 10.2.0.4

sap erp6.0ehp4ready1

ram:16gb

cpu:8cpus

Edited by: phanikrishnakosaraju1987 on Dec 18, 2011 12:32 PM

[former_member188883]

Hi,

ORA-27102: out of memory

Could you check whether your oracle database is up and running or not. Mostly this error comes when database is not running.

Repeat the process once your database is up and running.

hope this is useful.

Regards,

Deepak Kori

[Former Member]

Dear deepak

itried to start the database manually

but it is not working.

SQL> startup

ORA-27102: out of memory

SVR4 Error: 22: Invalid argument

SQL>

and my shm parametrs for the Solaris ACCORDING TO NOTE 724713 are

projadd -p 333 -c "SAP System PRD" \

-U prdadm,oraprd \

-K "process.max-file-descriptor=(basic,65536,deny)" \

-K "process.max-sem-nsems=(priv,2048,deny)" \

-K "project.max-sem-ids=(priv,1024,deny)" \

-K "project.max-shm-ids=(priv,256,deny)" \

-K "project.max-shm-memory=(priv,18446744073709551615,deny)" \

dr

projmod -s \

-K "process.max-file-descriptor=(basic,65536,deny)" \

-K "process.max-sem-nsems=(priv,2048,deny)" \

-K "project.max-sem-ids=(priv,1024,deny)" \

-K "project.max-shm-ids=(priv,256,deny)" \

-K "project.max-shm-memory=(priv,18446744073709551615,deny)" \

user.root

prdadm::::project=dr;oraprd::::project=dr

thanks & Regards

k.Phani Krishna

[former_member188883]

Hi,

Can you reboot the zone and check again.

Regards,

Deepak Kori

[Former Member]

Dear experts,

issue is resolved...

by checking the initsid.ora file.....

and check the shm parametrs....

Thanks & Regards

K.Phani krishna

[Former Member]

Please share with us what exactly was the problem and what exactly you did to resolve the problem, so that if someone gets this discussion thread in his/her search then he/she can utilize the Solution !

Thanks

[Former Member]

You didn't mention all the details about 'what' you are doing.

Please refer an old discussion thread and the SAP Note mentioned (outdated though) there. See similar Note for your installation release.

Thanks