I have a dblink defined with a TNS alias in an Oracle VDB on AIX. The dblink needs to lookup the TNS entry in a tnsnames.ora file, which it can not find. Returns ORA-12154.
The issue is probably caused by the VDB being started with no proper TNS_ADMIN set and no tnsnames.ora file in the OracleHome.
Where shall the environment variable TNS_ADMIN be set?