WARNING: Detected too many memory locking problems


My alert log file entries:
Current log# 3 seq# 4645 mem# 0: <DATAFILE_LOCATION>/redo03.log
Wed May 21 21:19:53 2014
WARNING: Detected too many memory locking problems.
WARNING: Performance degradation may occur.

The real cause of those warnings is the file oradism located on $ORACLE_HOME/bin folder was lacking permission.
As per meta link note 374367.1, issuing the following command should stop the warnings to get generated:
1- cd $ORACLE_HOME/bin
2- chmod 4550 oradism
3- chmod g+s oradism
4- chown root:dba oradism 
5- Bounce the database

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

%d bloggers like this: