ORA-27101: shared memory realm does not exist AIX 5.3 Oracle 10.2 g

[Former Member]

Hi everybody, please help!!!!!

I have a problem on my ERP, whe the users run reports called ZSD01, ZSD07 these programs exeed the lifetime period of 600 seconds and cause an ABAP - runtime error by time out.

using the TX ST22 I get a report indicating the folow:

C Attaching to DB Server R3P (con_hdl=0,svchp=0x114e60fa8,srvhp=0x1144295e8)

C OCIServerAttach(OCI_DEFAULT) failed with SQL error 12537:

C ORA-12537: TNS:connection closed

C *** ERROR => CONNECT failed with sql error '12537'

[dbsloci.c 11239

C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:

C ORA-01034: ORACLE not available

C ORA-27101: shared memory realm does not exist

C IBM AIX RISC System/6000 Error: 2: No such file or directory

C Detaching from DB Server (con_hdl=0,svchp=0x114e60fa8,srvhp=0x1144295e8)

C *** ERROR => CONNECT failed with sql error '1034'

[dbsloci.c 11239]

My Oracle and SAP instances are runnig and this error occurs when on the report select a several sales offices and was oerating 'til last moth ago...

Thanks!!!!!!!!!!!!!!!

Regards,

Oscar D'Lima

[Former Member]

Hi,

C ORA-12537: TNS:connection closed
C *** ERROR => CONNECT failed with sql error '12537'
[dbsloci.c 11239
C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:
C ORA-01034: ORACLE not available
C ORA-27101: shared memory realm does not exist
C IBM AIX RISC System/6000 Error: 2: No such file or directory
C Detaching from DB Server (con_hdl=0,svchp=0x114e60fa8,srvhp=0x1144295e8)
C *** ERROR => CONNECT failed with sql error '1034'

The ORA-27101 error is generated when the shared memory key generated by the client does not match any currently existing keys. This is to be expected if the ORACLE_HOME or ORACLE_SID used by the client is not the same as that used when starting up the database.

Perform the following:

1) Check these environment variables and if required set them appropriately.

2) Review the listener.ora currently used to startup the listener and verify the ORACLE_HOME value is correct for all listed Oracle databases. If the ORACLE_HOME points to a different Oracle version then what was used when the database was created, then this error can occur.

3) Likewise, review the listener.ora currently used to startup the listener and verify the SID_NAME value is correct and has the right value (the SID_NAME is case sensitive).

Also check Metalink Doc ID: 167252.1 (ORA-27101: Shared Memory Realm Does Not Exist).

regards,

Subhajit.

[Former Member]

Hello people, Thanks surendra in fact I just modify the System Profile Parameters as follow:

Parameter: New Value Previous value

rdisp/max_wprun_time 800 600

rsdb/obj/large_object_size 16384 8192

rsdb/obj/max_objects 25000 20000

rsdb/obj/buffersize 60000 40000

The error is still present and now there are other report failing, this new one is a standard report so I don´t think the problem are in the SQL sentences but I'm gonna request to my developer team to check this out.

Thanks and Regards...

[Former Member]

Hi,

if time_out occure then increase rdisp/max_wprun_time = 3600 (1 Hr).

Its dynamic parameter so not need to restart .

Findout why this report taking longer time .Analyze table ,index etc.

Also Update database statistics

SurendraJain

[Former Member]

Hi,

Check the SQL of those Z-program and tune the sql query as well as do index on used tabel or rebuld the index of these tables. u can also increase the time limit as suggested by Surendra.

Thanks

presu

[Former Member]

Hi,

For time_out you can increase rdisp/max_wprun_time (default 600 seconds)

For another problem send alert<SID>.ora file (few bottom lines)

SurendraJain

[Former Member]

Good Afternoon, Sunny. the SGA of my system it's okay as you refer on the Note 491174 intead I cross between my R3Q system where the report is running good, the listener is up also my DB

Total System Global Area 2399141888 bytes

Fixed Size 2079296 bytes

Variable Size 1207961024 bytes

Database Buffers 1174405120 bytes

Redo Buffers 14696448 bytes

Uday the SB patch level is: Release 10.2.0.2.0

thanks and regards...

[Former Member]

Hi,

Refer below note.

Note 491174 - Composite SAP note for ORA-01034

Let us knwo if u have any issues,

Regards,

Ravi

[Former Member]

Hi

Its the problem with your Oracle parameters setting cross check the same btw what is you oracle patch level ?

Regards

Uday

[sunny_pahuja2]

Hi,

> C ORA-12537: TNS:connection closed

> C *** ERROR => CONNECT failed with sql error '12537'

> [dbsloci.c 11239

> C OCISessionBegin(OCI_DEFAULT) failed with SQL error 1034:

> C ORA-01034: ORACLE not available

> C ORA-27101: shared memory realm does not exist

> C IBM AIX RISC System/6000 Error: 2: No such file or directory

> C Detaching from DB Server (con_hdl=0,svchp=0x114e60fa8,srvhp=0x1144295e8)

> C *** ERROR => CONNECT failed with sql error '1034'

> [dbsloci.c 11239]

>

check your listener is running or not... Also check your databse parameter should be set as per SAP note 830576. Also check size of SGA at database level..

Thanks

Sunny