Tnsping References an Address Not in My Tnsnames File

0

When I use the following command in command prompt:

tnsping DEVJAMES

(DEVJAMES is the name of one of the net services in the file) it outputs the following:

Used parameter files:
C:\app\oracle32\product\11.2.0\client_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = lor03800.cov.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DEVJAMES)))
OK (70 msec)

However, the tnsnames file in that directory has no instance of any use of even "800," let alone "lor03800.cov.com"

My sqlnet.ora file in that directory reads:

# 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.DEFAULT_DOMAIN = WORLD
NAMES.DIRECTORY_PATH= (TNSNAMES)

And the entry for DEVJAMES in my tnsnames file is

DEVJAMES =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = lor03799.cov.com)(PORT =
    1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = DEVJAMES.WORLD)
    )
    )

The tnsnames file used to have lor03800.cov.com as its host, but that has been changed. I searched my computer for any tnsnames files that it could possibly be referencing, but found nothing.

Is this sort of thing cached in a windows environment variable, or something of the like? Where would I find that and how would I clear it?

Forrest Matteo

Posted 2019-05-23T14:26:17.603

Reputation: 1

No answers