Forum Stats

  • 3,826,393 Users
  • 2,260,641 Discussions
  • 7,896,930 Comments

Discussions

ORA-27123 with Linux-x86_64 Error: 49: Protocol driver not attached

User_2PM0E
User_2PM0E Member Posts: 6 Red Ribbon
edited Nov 27, 2013 8:07AM in General Database Discussions

Hello,

Oracle Database 11.2.0.3.0 on RHEL6.2 x86_64

I often see the below errors when starting the database instance.

SQL> Connected to an idle instance.

SQL> ORA-01034: ORACLE not available

ORA-27123: unable to attach to shared memory segment

Linux-x86_64 Error: 49: Protocol driver not attached

Additional information: 393227

Additional information: 69

Additional information: 10

SQL> Disconnected

What should I do in order to prevent these errors? Please suggest.

Thanks.

Tagged:

Answers

  • Alvaro
    Alvaro Member Posts: 709 Silver Badge

    Your SGA is likely larger then what physical memory is available on the server, and so when the instance tries to start up it's unable to allocate the memory needed for the SGA.

    If you are seeing this intermittently then it's likely the issue is due to application and/or other processes hosted on the same server as the database that sometimes are consuming physical memory, sometimes not.

    Please check your free physical memory on server and the SGA_TARGET or MEMORY_TARGET

    Alvaro
  • Anar Godjaev
    Anar Godjaev Member Posts: 988 Gold Badge
    edited Nov 25, 2013 1:06AM

    Hi, welcome to OTN form

    ORA-27123: unable to attach to shared memory segment
    
    
    

    Action:  check permissions on segment, contact Oracle support

    please check Oracle support id : Resolving the ORA-27123 error (Doc ID 115753.1)

    thank you

    Anar Godjaev
  • User_2PM0E
    User_2PM0E Member Posts: 6 Red Ribbon

    Hello,

    Thanks for the very helpful suggestions. But I need to know why I see os error 49 as below.

    --------

    SQL> ORA-01034: ORACLE not available

    ORA-27123: unable to attach to shared memory segment

    Linux-x86_64 Error: 49: Protocol driver not attached

    Additional information: 393227

    Additional information: 69

    Additional information: 10

    ------------

    The document provided shows us the error may be accompanied by one of the following. Error 49 is not mentioned.

    -------------

       A) SVR4 error 12: not enough space

       B) SVR4 error 22: Invalid argument (you are trying to increase SGA and

                                           SHMMAX is large enough)

       C) SVR4 error 22: Invalid argument

       D) SVR4 error 22: Invalid argument

       E) UNIX error 13 (Permission Denied)

       F) SVR4 error 24 - too many open files.

    -------------

    What does potentially cause shmat() to be failed with os error 49, "Protocol driver not attached"?

    Please suggest.

    Thanks.

  • User_2PM0E
    User_2PM0E Member Posts: 6 Red Ribbon

    Thanks, I checked the form provided and I still want to know why I often see ORA-27123 together with OS Error 49, "Protocol driver not attached".

    Thanks.

  • User_2PM0E
    User_2PM0E Member Posts: 6 Red Ribbon

    In what situation do we see linux 49 error, "Protocol driver not attached" with ORA-27123? Please suggest.

    --------

    SQL> ORA-01034: ORACLE not available

    ORA-27123: unable to attach to shared memory segment

    Linux-x86_64 Error: 49: Protocol driver not attached

    Additional information: 393227

    Additional information: 69

    Additional information: 10

    ------------

    Thanks.

  • sb92075
    sb92075 Member Posts: 42,196 Blue Diamond
    d827a00e-d62a-451f-8932-56837a345f91 wrote:
    
    In what situation do we see linux 49 error, "Protocol driver not attached" with ORA-27123? Please suggest.
    
    --------
    SQL> ORA-01034: ORACLE not available
    ORA-27123: unable to attach to shared memory segment
    Linux-x86_64 Error: 49: Protocol driver not attached
    Additional information: 393227
    Additional information: 69
    Additional information: 10
    ------------
    
    Thanks.
    

    What will you do differently after you have this information?

    If you had followed the Installation Guide previously, Oracle would have been successfully installed without ever encountering any error.

  • User_2PM0E
    User_2PM0E Member Posts: 6 Red Ribbon

    Hello,

    I followed the installation instruction and the installation successfully completed. after that I sometimes see these errors sometimes not.

    Thanks.

  • User_2PM0E
    User_2PM0E Member Posts: 6 Red Ribbon

    Anyone plz suggest. I really need suggestions.

    What's the error 49?

    Thanks.

This discussion has been closed.