Re: ORA-12154: TNS:could not resolve service name

> NAMES.DIRECTORY_PATH= (HOSTNAME)
Felix,

  If you want the TNSNAMES file to be used, then you need to change this parameter in your SQLNET.ORA file. It should look something like:

NAMES.DIRECTORY_PATH= (HOSTNAME,TNSNAMES) The path is just like a search path. If I configure it this way, then when resolving TNS entries, the TNSNAMES file is checked last. To check TNSNAMES first, put the entry first in the path.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================