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:
(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,
Click Here to Expand Forum to Full Width