Oracle dblink and ORA-12154.

  • 0
  • 1
  • Question
  • Updated 9 months ago
  • Answered


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?

Photo of Henrik Bjørn Nielsen

Posted 9 months ago

  • 0
  • 1
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 2,302 Points 2k badge 2x thumb
Official Response
I think Henrik you will need to set the tns_admin as a global environment variable on the target server, rather than as an oracle parameter.  If indeed this is what is causing your issue.  Perhaps raise a support case for this if you are still having problems.