Solved

How to prevent stopping of the Oracle Listener

Posted on 2011-03-21
7
242 Views
Last Modified: 2012-05-11
Hi ,

I' m using Oracle 11G on windows server 2008 R2.

My Oracle tns listener is stopped when  Ip of the computer is changed or the computer is disconnected from the network.

How can I prevent this ?

 
0
Comment
Question by:orcun_turkec
7 Comments
 
LVL 11

Expert Comment

by:Akenathon
ID: 35180519
It's not that the listener process stops... the thing is that you have a listening socket on the previous IP. When your new IP shows up, the listener needs to be bounced so that it opens a new listening socket for the new IP. If you disconnect from the network it depends on how you do it: if you turn off the network interface, the IP disappears and so does the listening socket. You should add commands to restart the listener to the scripts that do the network changes.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35181266
Just to add:  The listener listens on an IP address.  If the ip changes, how is it supposed to listen?

It's not dynamic.

Oracle prefers a static IP address.  It doesn't run well in a dhcp environment.
0
 
LVL 11

Expert Comment

by:Akenathon
ID: 35183607
Plus, I'm having a hard time imagining in what scenario you would want a DATABASE SERVER to be migrating from one IP to the other... much less if it's assigned semi-randomly as with DHCP. You typically want to know that your DB server will be waiting for you at the same place at all times... actually you often architect things around that assumption.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 7

Accepted Solution

by:
Piloute earned 500 total points
ID: 35191818
Hi,

As pointed out, Oracle installations are usually done on servers with fixed IP addresses... Now, for your testing purposes, its perfectly OK to run on a DHCP based network.

A simple solution to make sure your listener will always be available on the IP address you currently use (even a changing one) is to modify you listener parameters in the listener.ora file. Instead of using a real IP address, just replace it with 'localhost' alias :

ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.50)(PORT = 1521) << replace this
ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521) << with this

In this case, when you restart your computer (and oracle stack - including listener -), the listener will automatically listenr on the good socket. Of course this assumes you shut down/reboot and IP change is related to this.

Cheers,
P
0
 
LVL 7

Expert Comment

by:Piloute
ID: 35191835
Additional note : the listener has to be restarted in case your computer doesn't restart when the IP address changes.
0
 

Author Closing Comment

by:orcun_turkec
ID: 35314351
Thank you
0
 
LVL 7

Expert Comment

by:Piloute
ID: 35316285
welcome
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now