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?