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 ??

Report message to a moderator

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?

Report message to a moderator

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: 4963
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.

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 09 04:25:40 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.