13 Replies Latest reply on Feb 24, 2012 10:33 PM by Hans Forbrich

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

      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 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