13 Replies Latest reply: Feb 24, 2012 4:33 PM by Hans Forbrich RSS

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

    919826
      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