CJS-00084 and ORA-27123

[Former Member]

Hello

SAP: ECC5

OS: RHEL 4u6

DB: Oracle 9.0.2

I'm trying to install ECC5, everything was OK for CI but the following error for DB install

After oracle and oracle patchset, continue SAPINST Pahse 19 of 36: Create Oracle Database

ERROR 2008-02-26 16:09:05

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-27123: unable to attach to shared memory segmentLinux Error: 22: Invalid argumentAdditional information: 1Additional information: 131073Disconnected. SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

ora_sql_results.log

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

2008-02-26, 16:17:36 SAPINST ORACLE start logging for

connect / as sysdba ;

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 9.2.0.7.0 - Production on Tue Feb 26 16:17:36 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

ORA-27123: unable to attach to shared memory segment

Linux Error: 22: Invalid argument

Additional information: 1

Additional information: 163841

Disconnected

SAPINST: End of output of SQL executing program /oracle/RE6/920_32/bin/sqlplus.

SAPINST found errors.

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

2008-02-26, 16:17:36 SAPINST ORACLE stop logging

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

I've try to change shmmax value following ORA-27123 error but still the same error.

Thanks

Eric

[Former Member]

Solved by restart installation

[former_member204746]

check in the installation guide, it will refer you to Linux kernel parameters. you must set them properly... this will need a reboot.

[Former Member]

Hi thanks for your support

I've setup my OS folllowing SAP Note 722273, with

For 32-bit systems:

1. SAP settings

kernel.shmmax=2313682943

kernel.msgmni=1024

kernel.sem=1250 256000 100 1024

vm.max_map_count=300000

Activate these settings with the command "sysctl -p".

REgards

Eric

[Former Member]

If the error "Invalid argument" occurs in connection with ORA-27123 when starting the database, the SGA is larger than permitted by the operating system. Either reduce the SGA size (shared_pool_size, db_block_buffers) or set the operating system limit to a higher value.

Also chek the Notes 159989,123366 and 583861.

Regards. Award if helpful.

[Former Member]

Hi

I've change shhmmax value according to the init.ora value,

sysctl.conf

kernel.shmmax=50000000

init.ora

shared_pool_size = 5000000 # MEDIUM

ora- 27123 is now solved but new error appear

ERROR 2008-02-27 09:55:07

CJS-00084 SQL statement or script failed. DIAGNOSIS: Error message: ORA-12547: TNS:lost contact

Regards

Eric

[Former Member]

Read Note 505630 -->

Symptom

ORA-12547: TNS:lost contact

Also check if LISTENER is up .

Regards .

Edited by: Sergo Beradze on Feb 27, 2008 11:07 AM