Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
tns!!!!!
- Thread starter 230173
- Start date
U get this error message if you specify a wrong or invalid database name, or maybe the instance is shutdown. or there could be 10000 reasons for this, 1 may be that ur using a wrong port. I doubt this has anything to do with the amount of connections.but it could be.ask a pro dba to help u out or else get oracle8i dba handbook(the best).
This error message is telling you that it found a reference to the database in your local name directory (TNSNAMES.ORA or Oracle Names or network directory service) but it couldn't connect using the protocol specified. There can be many reasons for this, but some of the most common are:
Wrong protocol - you said SPX but the server is using TCP/IP for instance.
Wrong port - you said 1521 but the server is listening on 1526.
DNS lookup failed - Your Domain name server is down, or you got the wrong name for the server.
A firewall is blocking your access - these have often been set up for telnet, ftp, and http, but not for Net8.
To diagnose the problem, first make sure that you can make a non-Oracle connection to the server - can you ping it? can you telnet or ftp to it? Does your naming service have the right name and port (check with the DBA about the port that the listener is using - there IS a listener, isn't there?) Try using the IP address rather than the name - this will take the DNS server out of the loop. HTH
Wrong protocol - you said SPX but the server is using TCP/IP for instance.
Wrong port - you said 1521 but the server is listening on 1526.
DNS lookup failed - Your Domain name server is down, or you got the wrong name for the server.
A firewall is blocking your access - these have often been set up for telnet, ftp, and http, but not for Net8.
To diagnose the problem, first make sure that you can make a non-Oracle connection to the server - can you ping it? can you telnet or ftp to it? Does your naming service have the right name and port (check with the DBA about the port that the listener is using - there IS a listener, isn't there?) Try using the IP address rather than the name - this will take the DNS server out of the loop. HTH
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question