ODI Error - ORA-12154 TNS:could not resolve service name

ORA-12154 TNS:could not resolve service name

It is an Common Error if your Database Invalid Service Name  or Database Service is Not available.

Solution:

Check your Database TNS names and  Database Host , Port Number ,  Service Name.

Or If you are using DBLink check the DBLink configuration details.