Ora 12154

[CassidyHunt]

I am receiving an ORA-12154 that points to the tns names file as being the problem. I can login using SQL Plus just fine. My applications on the other hand all return this error.

Any ideas?

tnsName file entry:

VMFG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = PROMETHEUS)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = VMFG)
    )
  )

SQLNet

# sqlnet.ora Network Configuration File: C:\oracle\10G\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

#NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

Thanks

Cassidy

 

[SantaMufasa]

Cassidy,

When you can connect successfully via SQL*Plus, but cannot via some other application, it usually means that the other application's method of linking up with tnsnames.ora (or via some ODBC connection) is broken.

Can you confirm for us the "other application" linkage?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Beilstwh]

In the past, this has happened to my customers because the application is in another home and using a different TNSnames. Do a search on the drive and locate all the different TNSnames and make sure that the are all have the settings for your VFMG instance or that they all point to the same copy by using the TNS_ADMIN environmental variable to point to a single directory holding the correct TNSnames file.

Bill
Oracle DBA/Developer
New York State, USA