How to fix the Oracle error ORA-37117: olapi history retention has been disabled?

In this post, you’ll learn more about the Oracle ErrorORA-37117: olapi history retention has been disabled with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-37117: olapi history retention has been disabled

Reason for the Error ORA-37117: olapi history retention has been disabled

Under certain circumstances, for example, when the database is read only, olapi history retention is not possible because it requires updating persistent tables from time to time. If olapi history retention has been disabled, setting _olapi_history_retention parameter to true has no effect.

How to fix the Error ORA-37117: olapi history retention has been disabled ?

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

Ensure that Oracle is properly installed with the OLAP option. If the RDBMS has been patched, review the patch log for errors. If the problem persists, report it to Oracle Customer Support.