Oracle dblink and ORA-12154.

  • 0
  • 1
  • Question
  • Updated 4 weeks ago
  • Answered

Hi,

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?


Thanks
Henrik
Photo of Henrik Bjørn Nielsen

Posted 1 month ago

  • 0
  • 1
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 1,946 Points 1k 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.