ORA-27102: out of memory

[Former Member]

Hello!

I have just installed SOLMAN with Oracle on Unix (as a second system on the same host) and I am facing the following problem with start of SOLMAN.

If I trying to start Oracle DB I am getting the error

<b>ORA-27102: out of memory

SVR4R Error 22: invalid argument

ORA-27101: shared memory realm does not exist</b>

Is the error may be due to tnsnames.ora or listener.ora?

I have configured the both oracle on the same Port 1527 and can start or stop both of them.

>R3trans -d

retrieves

no connection possible 'DBMS=ORACLE--dbs_ora_tnsnames=<SID>'

R3trans finished (0012)

Thank you very much!

regards

Thom

[Former Member]

Thom,

Check the logs in database alert file, location is:

background_dump_dest (/oracle/<SID>/saptrace/background)

It will mostly be related to lack of contiguous memory to bring up oracle instance. Check if the database is open. Alter database parameters, DB_CACHE_SIZE, SHARED_POOL_SIZE

Cheers,

Nisch

[Former Member]

Hi Nisch,

thank you very much for your answer.

The log file alert<SID>.log tells me

<b>Specified value of sga_max_size is too small, bumping to 2399141888

WARNING: EINVAL creating segment of size ...

fix shm parameters in /etc/system or equivalent</b>

Even that is my problem. The DB is down and cannot unfortunately be started due to ORA-27102.

Is there other possibilities to edit the parameters in configuration file?

Thank you!

regards

Thom

[Former Member]

How is ulimit for this OS User that starts the database?

<b><i>ulimit -a</i></b>

how is the DB Parameter SGA_MAX_SIZE set?

SQL> <b><i>show parameter sga</i></b>

ORACLE_SID and ORACLE_HOME should be set correctly and your listner.ora should point to the correct ORACLE_HOME.

Best regards

Baran

[Former Member]

Hi!

Thank you very much!

I do not have possibilities to execute the comand >show parameter sga

bacause of the error ORA-27101.

BUT:

I have found the configuration file init<S11>.ora.

The parameter sga_max_size there is

2319282339

<b>Can I edit these parameter there?

Should I enlarge or make smaller?</b>

I install SOLMAN

Is there some other possibilities to show and set this parameter e.g. init<SAP>.ora or spfile?

How should this parameter be set for Solaris sparc 5.10 with ORACLE 10?

Thank you very much!

regards

Thom

[Former Member]

if the database is down, you can't change the parameter with ALTER SYSTEM, only by changing in init<SID>.ora.

See please the following thread:

for the 10g database Parameters see please this SAP note:

830576 - Parameter recommendations for Oracle 10g

How is ulimit (of the OS user that starts up the database) set?

ulimit -a

Best regards

[Former Member]

Hi!

Thank you very much!

The command uname -a for ora<sid>

retrieves almost "unlimited" value, besides:

open files: 8192

stack size: 8192

pipe size: 10

max user processes: 29995

I eddited the file init<SID>.ora and changed the value of sga_max_size first from 2.319.282.339 to 4.319.282.339

and then from 2.319.282.339 to 1.319.282.339

but without success.

I got the relevant information from alert<SID>.log:

<b>Warning:EINVAL creating segment of size …

fix shm parameters in /etc/system</b>

I edited the file vi /etc/system and added:

set shmmax=4294967295

but nothing is changed.

Should the OS be rebooted?

If yes --> I have problem here.

Is there some other possibilities?

Thank you very much indeed!

regards

Thom

[Former Member]

Hi

Check the enviornment variables , Note 491174 , check listner.ora and make sure ORACLE_HOME is correct

Thanks

Prince Jose

[Former Member]

Hi!

Thank you very much!

How should the file listener.ora look like?

Thank you very much!

regards

[Former Member]

Hi Thom,

Listener.ora looks like this

1. Filename......: listener.ora

2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

3. Name..........:

4. Date..........:

################

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = <SID>.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = <SID>)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = <hostname>)

(PORT = <port #. eg:1528>)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SDU = 32768)

(SID_NAME = <SID>)

(ORACLE_HOME = /oracle/<SID>/920_64)

)

)

Thanks

Prince Jose

[Former Member]

I see, your listener.ora points to wrong ORACLE_HOME = /oracle/<SID>/<b><i>920_64,</i></b> if you have 10g Oracle Database, it should point to the correct ORACLE_HOME, e.g. ORACLE_HOME = /oracle/<SID>/<u><i><b>102_64</b></i></u>

[Former Member]

Hi!

No, it is not my listener. It was just example...

regards

Thom

[Former Member]

sorry.

How are the kernel parameters set for Oracle? Is there a file like /etc/sysconfigtab? Do you set these parameters according to the recommendations in the installation guide?

See please also Oracle installation guides:

http://www.oracle.com/pls/db102/homepage

[Former Member]

did you see this SAP Note and check the settings according that?

743328 - Composite SAP note: ORA-27102

[Former Member]

if you don't have an access to the SAP Notes (Service Marketplace), let me know?

[Former Member]

you have also for the same problem another thread:

<u>Thread: Warning:EINVAL creating segment of size</u>

Maybe it is better to use only one thread:

see please following SAP notes:

<b><u>743328 - Composite SAP note: ORA-27102</u></b>

<b>723744 - WARNING: EINVAL creating segment of size</b>

789011 - FAQ: Oracle memory areas

<b><i>546006 - Problems with Oracle due to operating system errors</i></b>

395438 - Parameter settings for Solaris 9 and below

300464 - Shared Memory Parameters in Solaris

If you don't have access to the SAP notes, let us know. I don't want to copy and paste the contents of notes.