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,
I experienced this problem. Infact, some times the IP address might change. So use the IP address in your HOST isntead of system name.
This is in the listener.ora file in one of my databases. You may want to use the Startup wait and Connect timeout parameters in the listener.ora file on you db server. It could be that you connection is slow and it takes to long for the client to connect. You might also try sqlnet tracing. Also make sure try to hard ccode the ip and make sure that tcp/ip is selected for the dial up connection.
(PROTOCOL = TCP)
(HOST = 192.168.0.1)
(PORT = 1521)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 0
TRACE_LEVEL_LISTENER = OFF
(SID_NAME = BSG1)
(ORACLE_HOME = \Oracle\ora81)
(GLOBAL_DBNAME = MYSID)