Home » RDBMS Server » Networking and Gateways » tns listener
tns listener [message #348345] Tue, 16 September 2008 08:23 Go to next message
panyam
Messages: 146
Registered: May 2008
Senior Member

Hi All,

I stoped the TNS listener and Oracle service in my local system but still i am able to connect to the remote server DB using TOAD
??.how this can happen ??
Re: tns listener [message #348347 is a reply to message #348345] Tue, 16 September 2008 08:25 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Are you using a TNS connection from Toad, or a Direct/LDAP connection?

Are you sure you've only got one Listener process running?
Re: tns listener [message #348349 is a reply to message #348345] Tue, 16 September 2008 08:30 Go to previous messageGo to next message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
panyam wrote on Tue, 16 September 2008 09:23

Hi All,

I stoped the TNS listener and Oracle service in my local system but still i am able to connect to the remote server DB using TOAD
??.how this can happen ??


Your local listener has nothing to do with how you connect remotely. You do not need a listener or Oracle at all to connect to a remote database. All you need is a tnsnames.ora file and a client product.
Re: tns listener [message #348481 is a reply to message #348349] Tue, 16 September 2008 22:53 Go to previous message
panyam
Messages: 146
Registered: May 2008
Senior Member

Thanks Joy & JRowbottom
Previous Topic: Not able to connect to Oracle
Next Topic: TNS ***ERROR*** on an AIX pltform
Goto Forum:
  


Current Time: Fri Dec 09 17:52:09 CST 2016

Total time taken to generate the page: 0.32386 seconds