Re: ORA-07429: smsgsg: shmget() failed to get segment. on SUN

RYoung wrote:
>
> I received this message when trying to build a new database with a large
> value (90) for maxdatafiles.
> I thought this might arise because I had too many instances running, but
> when the others were completely shutdown I still get the same message. When
> I tried to take one of the existing databases (maxdatafiles=30) , dump the
> control file to trace to change maxdatafiles, and then try to rebuild the
> controlfiles I also get the same message. I don't have the SUN manuals with
> me...is there something special re: the SUN system I am missing?

07429, 00000, "smsgsg: shmget() failed to get segment."

// *Cause:  a shared memory segment used for all part of the SGA could not be
//          retrieved.
// *Action: Use the system error number in the error message to determine why
//          the segment could not be retrieved. If it does not exists, shutdown
//          the database using the "abort" option, and then restart it.
//          If the get failed because the permissions are incorrect, make sure
//          that the ownership of the oracle executable is the same as that on
//          the shared memory segment.

  Moreover, try to check the /etc/system shmxxx parameters to ensure your setting is correct and large enough to allow your instance to start.

---
Name   : Lun Wing San (Certified Oracle Database Administrator)

Title  : Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.