This discussion is archived
13 Replies Latest reply: Feb 24, 2012 2:33 PM by hans forbrich RSS

ORA-27123 - IBM AIX RISC System/6000 Error: 22: Invalid argument

919826 Newbie
Currently Being Moderated
Good morning,

I have a question about ORA-27123 and not being able to start up a database.

System and DB info - This is a development enviroment
Oracle 10.2.0.5 Enterprise edition
AIX 6.1
8 CPU
24 GB RAM

We currently have 5 small datbases up on this server with a total SGA of 17.292GB plus an ASM instance.

When I attempt to start another DB, that has been open before, I receive the following error.

ORA-27123: unable to attach to shared memory segment
IBM AIX RISC System/6000 Error: 22: Invalid argument
Additional information: 1
Additional information: 139460619

I ran into this problem and intiially the RAM was 20GB, the 5 databases mentioned above were all open at that time. Sys Admins added 4GB RAM and we are still having the same issue.

After researching the problem, I haven't been able to find a true solution but I have read through many documents and I'm wondering if it may be some sort of a paging issue. I recently installed OEM on the 5 databases (this extra DB was intended for a GRID install) and I am seeing paging issues in the ADDM reports. Below is the finding from the ADDM report from one of the databases that are open.

FINDING 1: 100% impact (2168 seconds)
-------------------------------------
Significant virtual memory paging was detected on the host operating system.

RECOMMENDATION 1: Host Configuration, 100% benefit (2168 seconds)
ACTION: Host operating system was experiencing significant paging but no
particular root cause could be detected. Investigate processes that
do not belong to this instance running on the host that are consuming
significant amount of virtual memory. Also consider adding more
physical memory to the host.


My ulimit -a is
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) unlimited
pipe size (512 bytes, -p) 64
stack size (kbytes, -s) hard
cpu time (seconds, -t) unlimited
max user processes (-u) 16384
virtual memory (kbytes, -v) unlimited

If anyone has any thoughts or ideas, I would be very interesting in you sharing them

Thanks
Ken

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points