Home » RDBMS Server » Server Administration » listener
listener [message #213028] Tue, 09 January 2007 03:23 Go to next message
maoro
Messages: 310
Registered: May 2005
Senior Member
hello
why if i change my ip, the listener stop responding , and everytime i have to edit the listener.ora file and restart the listener,even if i disable the network card the listener stops,
any workaround for this dependency ?
thanks
Re: listener [message #213065 is a reply to message #213028] Tue, 09 January 2007 05:13 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
No.

The listener listenes on an IP, if you change the IP the listener configuration must be changed, too.

And if you disable the network card, there is not much reason to run a listener.

If you just want wo work locally, though, you might want to consider running the listener on the loopback address 127.0.0.1
Re: listener [message #213118 is a reply to message #213028] Tue, 09 January 2007 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>If you just want to work locally,
If working "locally" on the DB server system itself, then NO listener is required.
Re: listener [message #213129 is a reply to message #213118] Tue, 09 January 2007 10:54 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
>If working "locally" on the DB server system itself, then NO listener is required.
Except when you have to work with some application that can only connect with a host_name / instance_name / port connect string, like some using the java thin client. Wink
Re: listener [message #213548 is a reply to message #213028] Thu, 11 January 2007 04:08 Go to previous messageGo to next message
maoro
Messages: 310
Registered: May 2005
Senior Member
hello
but when i connect locally and the listener is down, i get and error " no listener" from sqlplus
so how can i connect locally without a listener
thanks
Re: listener [message #213562 is a reply to message #213548] Thu, 11 January 2007 05:03 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
To avoid using the listener when connecting locally, ensure that your ORACLE_SID is set and don't use the tns alias when connecting to the database locally.

export ORACLE_SID=testdb
sqlplus scott/tiger

[Updated on: Thu, 11 January 2007 05:03]

Report message to a moderator

Previous Topic: unable to extend table employee
Next Topic: Deadlock Problem
Goto Forum:
  


Current Time: Sun Dec 04 02:24:45 CST 2016

Total time taken to generate the page: 0.05669 seconds