This content has been marked as final. Show 32 replies
Tnsentry is fine , i think so.. here is the output of tnsping
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.XXX.XXX.173)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = dwh)))
TNS-12541: TNS:no listener
this server has database client and i am able to ping to other tnsnames.ora enteries(means other databases).
and to the remote database(dwh) i am able to connect from other servers and desktops..
So from this machine are you able to connect to 10.XXX.XXX.173?
Also can you check from the machine where you are able to connect to dwh, whether the ip address and port number you sepcified here is correct?
If yes then check if your port is open to comunicate between your linux box and dwh.
sorry for replying late..
I am able to ping to the server where DWH database is installed( I am able to connect to database remotely as well from various other machines except one linux server).
The linux server from which i am not able to connect to DWH database has several other enteries in its oracle client tnsnames.ora file. And i am able to connect to those databases on various servers. The only database i am not able to connect from this linux server is DWH. ON this linux server i have stoped firewall as well by /etc/init.d/iptables stop.
Still i am getting error as NO listener(but listerner is running on the machine and i am able to connect from other machines)..
Please suggest something
Linux grid0-03-dd-37 2.6.18-92.el5 #1 SMP Tue Apr 29 13:16:15 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux
-bash-3.1$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost
tracert 10.XXX.XXX.173------(with root user only)
traceroute to 10.XXX.XXX.173 (10.XXX.XXX.173), 30 hops max, 40 byte packets
1 10.XXX.XXX.173 (10.XXX.XXX.173) 0.892 ms 0.928 ms 0.951 ms
even i suspect some networking issue, however from the same server i am able to connect to other databases on different machines.
I like to mention that client installed is 10.2.1.0 and the database to which i am not able to connect is 11i and to those i am able to connect are 10g. However in my desktop i have same version of client and i am able to connect to DWH database.