ORA-16664: unable to receive the result from a database

When querying the status of the configuration from broker, errors like below were seen.

Warning: ORA-16664: unable to receive the result from a database

Standby databases also receive connection errors as below.

Fatal NI connect error 12526, connecting to:

SOLUTION

We can fix the problem by following the steps below.

Step1:

Since the TNS problem appears, it is first checked whether the TNSNAMES.ora and Listener.ora files are working. Test access to Standby from Physical database with sqlplus. As you can see below, only one database connection is seen.

Step2:

Try tnsping. As you can see below, only one database connection is seen.

Step3:

Check Listener on all DBs in configurations. We have seen that there is something odd only in the Primary database “Physical”.

Step4:

In this case, I suspect that the Primary database was opened in RESTRICT mode. We do the necessary checks.

Step5:

Disable RESTRICT mode.

Step6:

Check listener again.

Step7:

Check the configuration status.

 

Onur ARDAHANLI
Author: Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *