| listener [message #213028] |
Tue, 09 January 2007 03:23  |
maoro
Messages: 312
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  |
ThomasG
Messages: 3212
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 #213548 is a reply to message #213028] |
Thu, 11 January 2007 04:08 |
maoro
Messages: 312
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 |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
