Solved

How to prevent stopping of the Oracle Listener

Posted on 2011-03-21
7
243 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
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 shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

863 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

26 Experts available now in Live!

Get 1:1 Help Now