Troubleshooting: After adding RAM, Oracle fails to start

Issue

After inserting additional RAM into the Database Server, the change is detected by Solaris, but Oracle fails to start.

Details

The Oracle project settings are not automatically updated to reflect the additional memory. Oracle detects that the SGA value exceeds the available memory, and fails to start.

Solution

After adding RAM, manually update the Oracle project settings.

1. Log in as the root user.

2. Run the command

   projmod -sK "project.max-shm-memory=(privileged,value,deny)" user.oracle

   where value is 110% of SGA, converted to the appropriate units.

   For example, if sga_max_size=4096, so value=4096*1.1*1024*1024=4724464026.