How to fix the Oracle error INS-35172: Target database memory (stringMB) exceeds the systems available shared memory ({0}MB).?

In this post, you’ll learn more about the Oracle ErrorINS-35172: Target database memory (stringMB) exceeds the systems available shared memory ({0}MB). with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

INS-35172: Target database memory (stringMB) exceeds the systems available shared memory ({0}MB).

Reason for the Error INS-35172: Target database memory (stringMB) exceeds the systems available shared memory ({0}MB).

Cause: The total available shared memory on the system (string MB) was less than the chosen target database memory (string MB).

How to fix the Error INS-35172: Target database memory (stringMB) exceeds the systems available shared memory ({0}MB). ?

You can fix this error in Oracle by following the below steps

Action: Enter a value for target database memory that is less thanstring MB.