cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-27102: out of memory SVR4 Error: 22: Invalid argument

Former Member
0 Kudos

Hi all,

I'm doing an install of a Solaris 10.2, Oracle 10.2 system. During the Create Database phase, I am getting;

ORA-27102: out of memory SVR4 Error: 22: Invalid argument

Doing some research, and reading through the details here:

Link: [http://technopark02.blogspot.com/2006/09/solaris-10oracle-fixing-ora-27102-out.html]

I think my issue is my SHM parameters, reinforced by the repeated entry in the Oracle Alert log:

+WARNING: EINVAL creating segment of size 0x0000000085000000+*

+fix shm parameters in /etc/system or equivalent+*

when the create fails.

I am not familar with Solaris' new project mechanism, although from what I have read, it seems to be set up properly.

Here are my server details:

# prtconf | grep Mem

Memory size: 8192 Megabytes

# prctl -n project.max-shm-memory -i project 200

project: 200: QBI

NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT

project.max-shm-memory

privileged 10.0EB - deny -

system 16.0EB max deny -

And as for Oracle:

shared_pool_size = 1522029035

shared_pool_reserved_size = 152202903

pga_aggregate_target = 2705829396

sga_max_size = 3439329280

db_cache_size = 1159641169

During the course of troubleshooting, I have:

1 - Increased the amount of SHM allocated in the project. I have tried 16GB, 8 GB, 10 GB, 11GB etc, to no effect, so I reset it to 10GB (as seen above) and focused my efforts elsewhere.

2. SHARED_POOL_SIZE - I have decreased this by roughly 75% from the original value, again to no effect.

3. PGA and SGA sizes - I have increased these from the original values by an increment of 25%

Following the advice from the referenced blog (which does a good job of explaining the logic behind the actions) I have determined that the Alert log error message is telling me that it is lacking

2231369728

(Hex conversion value, which I think I need to read as 2GB, not 100% sure)

I've increased my project allocation, and the PGA sizes, did I just not do it enough?

Any advice?

Thanks for any input,

Troy Shane

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

check following sap note

Note 546006 - Problems with Oracle due to operating system errors

Note 743328 - Composite SAP note: ORA-27102

regards,

kaushal