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

User_2PM0E

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.

Alvaro

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

Anar Godjaev

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

User_2PM0E

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

   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.

Anar Godjaev

Hi

Can you please check form: https://forums.oracle.com/thread/457218?start=0&tstart=0

Thank you

User_2PM0E

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

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

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

Hello,

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

Thanks.

User_2PM0E

Anyone plz suggest. I really need suggestions.

What's the error 49?

Thanks.