CLUVFY Pre-Check Errors: PRVG-0446, PPRVG-0449, PRVG-0448

Findings

When you run CLUVFY for pre-checks, you may encounter errors like

Verifying Hard Limit: maximum open file descriptors …FAILED
rac2: PRVG-0446 : Proper hard limit for maximum open file descriptors was not
found on node “rac2” [Expected >= “65536” ; Found = “4096”].

rac1: PRVG-0446 : Proper hard limit for maximum open file descriptors was not
found on node “rac1” [Expected >= “65536” ; Found = “4096”].

Verifying Hard Limit: maximum user processes …FAILED
rac2: PRVG-0448 : Proper hard limit for maximum user processes was not found on
node “rac2” [Expected >= “16384” ; Found = “14557”].

rac1: PRVG-0448 : Proper hard limit for maximum user processes was not found on
node “rac1” [Expected >= “16384” ; Found = “14557”].

Verifying Soft Limit: maximum stack size …FAILED
rac2: PRVG-0449 : Proper soft limit for maximum stack size was not found on
node “rac2” [Expected >= “10240” ; Found = “8192”].

rac1: PRVG-0449 : Proper soft limit for maximum stack size was not found on
node “rac1” [Expected >= “10240” ; Found = “8192”].

Factors

When running CLUVFY, errors like PRVG-0446, PRVG-0448, and PRVG-0449 may occur due to default settings not meeting Oracle RAC demands and improper limits configured for the grid user. Adjusting these limits in the system configuration is necessary for resolution

Solution

To resolve the CLUVFY errors, you need to adjust the resource limits for both the grid and oracle users. Follow these steps to edit the relevant configuration files and set the appropriate limits:

Edit /etc/security/limits.conf: Open the file using a text editor (e.g., vi):

###GRID##############
grid   soft   nofile    1024
grid   hard   nofile    65536
grid   soft   nproc    16384
grid   hard   nproc    16384
grid   soft   stack    10240
grid   hard   stack    32768
grid   hard   memlock    134217728
grid   soft   memlock    134217728
###ORACLE##############
oracle   soft   nofile    1024
oracle   hard   nofile    65536
oracle   soft   nproc    16384
oracle   hard   nproc    16384
oracle   soft   stack    10240
oracle   hard   stack    32768 
oracle   hard   memlock    134217728
oracle   soft   memlock    134217728

Edit /etc/security/limits.d/oracle-database-preinstall-19c.conf: Open this file using vi

grid   soft   nofile    1024
grid   hard   nofile    65536
grid   soft   nproc    16384
grid   hard   nproc    16384
grid   soft   stack    10240
grid   hard   stack    32768
grid   hard   memlock    134217728
grid   soft   memlock    134217728

Note: In the file /etc/security/limits.d/oracle-database-preinstall-19c.conf, we only updated the parameters for the grid user because the installation of the package with yum install -y oracle-database-preinstall-19c automatically updates the resource limits for the oracle user.

Save and exit the editor (in vi, press Esc, then type :wq, and press Enter).

To apply the changes, you can either reboot the node or use the sysctl -p command to reload the configuration settings without a reboot. This command ensures that the new limits take effect immediately.

Note: Make sure to update the resource limits on both Node 1 and Node 2 to ensure consistency across your cluster.

I hope you found this blog helpful! We’d love to hear about your experiences or any questions you might have please share your thoughts in the comments. Your feedback is greatly appreciate