SAP Oracle instance not able to start

[Former Member]

Dear Experts,

Successfully, Upgrade the Oracle patch Version 10.2.0.4.0 from oracle Version 10.2.0.1.0 on SCM4.1 with windows 2003 server. After upgrade the patch, I tried to start oracle instance but I got an error

Please see the erroru2026

SQL> Connected to an idle instance.

SQL>

SQL> ORA-27102: out of memory

OSD-00029: additional error information

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

SQL> Disconnected

BR0280I BRSPACE time stamp: 2010-02-18 12.27.14

BR0279E Return code from 'E:\oracle\CIT\102\BIN\sqlplus': 0

BR0302E SQLPLUS call for database instance CIT failed

BR0306E Start and open of database instance CIT failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to

repeat the last action

BR0280I BRSPACE time stamp: 2010-02-18 12.27.14

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Regards,

MMS

[Former Member]

Hi

Try to stop & restart oracle service before restarting Oracle, for details refer SAP note # 441663.

Ravi

[Former Member]

SQL> ORA-27102: out of memory

Check your sga_max_size and increase if possible before restarting the instance.

[Former Member]

Hi Manoj,

As per your advice, I increased SGA size 3GB (sga_max_size = 3GB)

After that I tried to activate the oracle but I am facing error:

BR0280I BRSPACE time stamp: 2010-02-18 15.15.28

BR0304I Starting and opening database instance CIT ...

BR0278E Command output of 'E:\oracle\CIT\102\BIN\sqlplus':

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 18 15:15:28 2010

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

SQL> Connected to an idle instance.

SQL>

SQL> ORA-27100: shared memory realm already exists

SQL> Disconnected

BR0280I BRSPACE time stamp: 2010-02-18 15.15.29

BR0279E Return code from 'E:\oracle\CIT\102\BIN\sqlplus': 0

BR0302E SQLPLUS call for database instance CIT failed

BR0306E Start and open of database instance CIT failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to

repeat the last action

BR0280I BRSPACE time stamp: 2010-02-18 15.15.29

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Regards,

MMS

[Former Member]

From Oracle's documentation:

27100, 00000, "shared memory realm already exists"
// *Cause: Tried to start duplicate instances, or tried to restart an
//         instance that had not been properly shutdown
// *Action: Use a different instance name, or cleanup the failed instance's
//          SGA

There are several ways how to cleanup the failed instance's SGA.

The easiest: reboot

hope this helps

[JPReyes]

Go through SAP Note 830576 - Parameter recommendations for Oracle 10g

Regards

Juan

[Former Member]

Can you revisit the following things

Your memory related params in int<sid>.ora or best option is to set sga_target to 3gb so that all your sga components are dynamically managed now by oracle itself.

Aditionally do you see any space problem in your /tmp and $ORACLE_HOME

Regards

Kausik

[Former Member]

SQL> ORA-27102: out of memory

OSD-00029: additional error information

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

Check whether there is free space avilablity, Since there is no free space it is not able to create log files.

Mahesh

[former_member227283]

Hi,

After applying the patch did you done all the neccesary post activity.

If yes , the just restart the OS.

Thanks

Anil

[Former Member]

HI anil,

Thanks for your reply.

Sorry anil,

can you please explain step by step, what post activity I have to dou2026.



Regards,

MMS

[former_member227283]

Hi,

Can we know what steps you have followed for applying patchs.

Thanks

Anil