Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

WARNING: system does not seem to be configured optimally

user12010879Feb 23 2015 — edited Feb 25 2015

I have a 11.2.0.3 Enterprise database running in a zone on a Solaris 10 server.

Up to recently I've been successfully stopping and starting this instance by means of cron'd shell scripts. 

However now occassionally the database fails to start, and the only thing I can see in the alert log is

WARNING: The system does not seem to be configured optimally. Creating a segment of size 0x0000000000000000 failed.

Please change the shm parameters so that a segment can be created for this size. While this is not a fatal issue, creating one segment may improve performance.

The cron script output shows;

Connected to an idle instance.

ORA-27102: out of memory

SVR4 Error: 22: Invalid argument

Disconnected

The SGA_TARGET is set to 14GB and the memory available to the Oracle account is 62GB

prctl -n project.max-shm-memory -i project 100

project: 100: user.oracle

NAME    PRIVILEGE       VALUE    FLAG   ACTION                       RECIPIENT

project.max-shm-memory

        privileged      62.7GB      -   deny                                 -

        system          16.0EB    max   deny       

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 25 2015
Added on Feb 23 2015
7 comments
2,354 views