ORA-27125: unable to create shared memory segment

Issue:

The below issue has been observed in Oracle Database 12c (in specific 12.1.0.2) on AIX OS, when LOCK_SGA parameter is set.

SQL> startup
ORA-27125: unable to create shared memory segment
IBM AIX RISC System/6000 Error: 1: Not owner

 

Cause:

The OS user with which Oracle is installed must be missing some permissions.

 

Resolution:

Request the AIX admins to set the capabilities for the user in which Oracle is running.

To check whether capabilities is set or not, please issue the below command,

lsuser -a capabilities <DB User>

 

Advertisements
This entry was posted in Oracle Database. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s