ORA-12154: TNS:could not resolve the connect identifier specified message is getting intermittently
We need to access some views from an oracle database (11.2.0.4) through the IBM filenet application and the Filenet database is also Oracle DB (12.1.0.2.0)
The error message "ORA-12154: TNS:could not resolve the connect identifier specified" is thrown intermittently while connecting the host database (12.1.0.2.0 two nodes RAC DB) to another database (11.2.0.4 two nodes RAC DB) through the IBM Filenet Application.
Application servers are running on Windows server 2016 platform while DB is on Oracle Exadata Machine (18.1.15.0.0.190510 - image info).
We are able to connect the back end as the application schema user and can access the target DB using the DB Link.