Create oracle database process failed - DB installation 10G

[Former Member]

Hello All,

I am doing a system copy in our environment from development machine to new the system.

Landscape details

We have exported the current database = 8.1.7.4, SAP R/3 4.7 * 110, 620 engine in linux 2.1AS

In the target machine we are trying to import the same using the new installation master with 640 engine and oracle 10g as database in RHEL5 16GB RAM

In the target system we have installed CI and 10g database successfully without errors. In the database installation process (create oracle database is getting failed) and not able to proceed further

The log are below

ERROR 2009-10-20 10:04:20

CJS-00084 SQL statement or script failed.<br>DIAGNOSIS: Error message: ORA-27102: out of memoryLinux Error: 22: Invalid argumentDisconnected.<br>SOLUTION: See ora_sql_results.log and the Oracle documentation for details.

Then I have followed the note u2013 851169 and changed the parameters as per the suggestions from the note but still I am getting the same error.

The parmeters changed are

shared_pool_size = 800000000

shared_pool_reserved_size = 80000000

db_cache_size = 800000000

sga_max_size = 1100000000

In our environment the RAM size is 16GB.

The kernel parameters are below

1. Controls the maximum shared segment size, in bytes

kernel.shmmax = 4294967296

1. Controls the maximum number of shared memory segments, in pages

kernel.shmall = 2097152

#SAP Settings

kernel.msgmni = 1024

kernel.sem = 1250 256000 100 1024

vm.max_map_count = 300000

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default = 262144

net.core.rmem_max = 262144

net.core.wmem_default = 262144

net.core.wmem_max = 262144

The ora_sql_results.log are as follows

start logging for

connect / as sysdba ;

STARTUP NOMOUNT;

exit;

Output of SQL executing program:

SQL*Plus: Release 10.2.0.2.0 - Production on Tue Oct 20 07:39:32 2009

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

Connected to an idle instance.

ORA-27102: out of memory

Disconnected

SAPINST: End of output of SQL executing program /oracle/DEV/102_32/bin/sqlplus.

SAPINST found errors.

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

2009-10-20, 07:39:32 SAPINST ORACLE stop logging

If anyone have idea on this error , Kindly let me know your suggestions

Regards

Vijay Kumar

[jgleichmann · Accepted solution]

ORA-27102: out of memory

It seems to be that your parameterization is not correct. Please follow note 830576.

SAPINST: End of output of SQL executing program /oracle/DEV/102_32/bin/sqlplus.

I hope you installed not the 32bit variant... You get problems if you want to use 16GB in a 32bit environment. Which Linux version do you use 32bit or 64bit?

Regards,

Jens

[Former Member · Accepted solution]

Hello Jens,

Thanks for the reply.

We are using 32bit software only in 32bit OS. - Linux 5.

I have tried the oracle parameter changes in shared pool size and also DB cache as per the recommendations. Rest of the parameters looks fine in initdev.ora.

No luck - Still getting the same error. Tried by rebooting the machine.

Any other suggestions

Regards

Vijay

[Former Member · Accepted solution]

Hello Vijay,

shared_pool_size = 800000000
shared_pool_reserved_size = 80000000
db_cache_size = 800000000
sga_max_size = 1100000000   <== ??

I know these parameters come from note 851169, but I find it starnge to have sga_max_size set to a value smaller than the sum of shared_pool_size + db_cache_size. Can you try with the following settings:

db_cache_size = 600000000
shared_pool_size = 400000000
shared_pool_reserved_size -> do not set
sga_max_size = 1100000000

Regards,

Mark

[Former Member · Accepted solution]

Hello Mark,

Thanks alot for the reply. I have tried with the parameter as you said but it didnt work(tried after restarting the system as well)

But problem solved by following the note - 804186 - increased the shmax size in kernel parameter from 4GB to 8GB.

Thanks Mark and jens

Regards

Vijay

[jgleichmann · Accepted solution]

Hi Vijay,

that´s very interesting because the redhat FAQ doesn´t recommend to use a higher value than 4GB. I don´t know why you don´t want to use a 64bit system to use you memory efficient because a single process can´t grow over 4GB on a 32bit system.

Regards,

Jens

[Former Member · Accepted solution]

Vijay,

When you later set up the SAP instance on Linux 32-bit, I recommend you look at note 386605 for setting up SAP memory management. I know from experience that this can save you some serious performance trouble.

Regards,

Mark