Switchovering Ip address of oracle server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Switchovering Ip address of oracle server

  1. #1
    Join Date
    Jan 2004
    Location
    india
    Posts
    7

    Switchovering Ip address of oracle server

    Hi

    oracle server System has 2 ip address (IP1,IP2)
    Say suppose Oracle server is bounded to IP1.
    If IP1 is disconnected,
    Will oracle server bound to IP2 with out restarting the system?

    Thank U
    vijay mohan ch.

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    The Oracle server isn't "bound" to an IP address. The listener can "listen" on any number of IP addresses.

    With Net8 Assistant or Net Manager (according to your version) you can configure the "Listening Locations" and add as many IP address/port combinations as you like. (Using lsnrctl you can RELOAD the listener configuration without stopping anything).

    Doing it without the GUI: In listener.ora you have multiple (ADDRESS = . . . . . . ) lines.

    Unless you are using a names server, all the clients will need to have both addresses configured in their tnsnames.ora (multiple (ADDRESS = . . . ) or Net Assistant/Manager again).

  3. #3
    Join Date
    Jan 2004
    Location
    india
    Posts
    7

    Thanks alot

    Hi

    Thanks Alotttt
    Its worked
    vijay mohan ch.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width