How to fix the Oracle error ORA-23535: instantiating templates from multiple back ends is not allowed.?

In this post, you’ll learn more about the Oracle ErrorORA-23535: instantiating templates from multiple back ends is not allowed. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-23535: instantiating templates from multiple back ends is not allowed.

Reason for the Error ORA-23535: instantiating templates from multiple back ends is not allowed.

An attempt was made to set a new non-null back end database for an iAS site.

How to fix the Error ORA-23535: instantiating templates from multiple back ends is not allowed. ?

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

Call dbms_ias_configure.set_back_end_db procedure with null dblink. Then, call the same procedure with the new non-null dblink.