no listener error when internet is enabled [message #67735] |
Wed, 09 February 2005 17:09 |
rishank
Messages: 3 Registered: February 2005
|
Junior Member |
|
|
hi
I'm getting this TNS NO listener when trying to connect to my database when I'm connected to Internet. But when I disable the internet and try to connect it is connecting. After the database is connected I'm enabling my internet and using my oracle reports or TOAD or Discoverer.
Earlier I was not able to connect at all irrespective of the internet connection. I have read all the literature available on this problem and was able to connect to database only by disconnecting from internet.
Can some one help me on this please. Although it is not a serious problem, I find it fussy to disconnect everytime from my net everytime I connect to database.
Thanks in advance.
|
|
|
Re: no listener error when internet is enabled [message #67738 is a reply to message #67735] |
Mon, 14 February 2005 01:14 |
nag raj
Messages: 4 Registered: December 2004
|
Junior Member |
|
|
here also i am facing the same problem but i find the cause for that problem.
when u want to connect to internet u have to enable ur "internet connection" and this connection will have an IP address. but ur tns listener would be configured with different IP address ( normally it is 127.0.0.1 [[in case of single pc]] or other IP address ). and a system cannot serve to IP addresses at a time so this is the cause for the problem.
so u have to face this problem
if u find a solution then pwd it to me
regaurds
nag raj
|
|
|