"ORA-12154: TNS:could not resolve the connect identifier specified" - when executing Interface in OD
Hi Experts,
While running interface in ODI, it is giving following error:
ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection XXXXXXXX.
Caused By: java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified
I have checked connection pool and it is working fine without any issues.
There are no issues when running the Interface for the first time.However, when I run the same interface again I am getting the above error message.