Greetings,

I have a client computer trying to connect to an Oracle database through a dial-up modem. I can dial-up, and my username and password are accepted. When I try connecting to the database, sqlplus user/pw@NN01 I get error ora-12545: connect failed because target host or object does not exist.

The Tnsnames.ora file is:

NN01.NN.WBC.COM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = nansvr4.weyer.com)(PORT = 1521))
(CONNECT_DATA = (SID = NN01)(SERVER = DEDICATED))
)

The sqlnet.ora file is:

NAME.DEFAULT_ZONE = world
SQLNET.EXPIRE_TIME = 0
SQLNET.ENCRYPTION_SERVER = requested
SQLNET.ENCRYPTION_CLIENT = requested
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES)

Tnsping does not work. When I follow the exact same procedure, using the same tnsnames, sqlnet.ora files on the computer beside this one, it all works fine.

Any help on this would be appreciated,

Brad