We help IT Professionals succeed at work.

Change in IP

162 Views
Last Modified: 2018-08-13
We are moving from Oracle to Exadata. In this scenario, do we expect change in Server Ipaddress and DNs names or just IP addresses.

Please help!
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008

Commented:
Moving only the data to Exadata doesn't change the IP address of the instance.
But moving the Oracle instance to Exadata  (in the Computing Node of Exadata machine) will need a new IP address (in case of RAC - 4 new IP addresses - 1 for VIP and 3 for SCAN IP's)

Author

Commented:
What is VIP and Scan IPs. Is there any link that I can find more about it.

Also, we currently have One Primary db and two ready only on active dataguard and have wide ips configured for all of these.  When we move to exadata, we are planning to have only one ready only db. How can we configure wide ip so that clients don't have any impact.

Please advise.
CERTIFIED EXPERT
Top Expert 2008
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2008

Commented:
VIP Address

http://docs.oracle.com/cd/B28359_01/rac.111/b28254/admcon.htm

Virtual internet protocol address (VIP)
A virtual IP address is an alternate public address that client connections use instead of the standard public IP address. To configure VIP addresses, you need to reserve a spare IP address for each node, and the IP addresses must use the same subnet as the public network.
If a node fails, then the node's VIP address fails over to another node on which the VIP address can accept TCP connections but it cannot accept Oracle connections. Generally, VIP addresses fail over when:
•      The node on which a VIP address runs fails
•      All interfaces for the VIP address fail
•      All interfaces for the VIP address are disconnected from the network
Clients that attempt to connect to the VIP address receive a rapid connection refused error instead of waiting for TCP connect timeout messages. You configure VIP addresses in the address list for your database connection definition to enable connectivity.
VIP and SCAN

https://community.oracle.com/thread/2595729

Author

Commented:
What changes should be made on Client's side who connect to Oracle DB who use tnsnames.ora,

Should the host in tnsnames.ora be replaced with dnsname of SCAN as SCAN includes the nodes of DB Servers with different IP addresses.

Any input in wideip set up?
CERTIFIED EXPERT
Top Expert 2008
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

Commented:
If that is the case. In the scenario moving from Oracle to Exadata on RAC, what would be the change in tnsnames.ora.
CERTIFIED EXPERT
Top Expert 2008

Commented:
Single Instance or RAC installation?

Author

Commented:
RAC installation.
CERTIFIED EXPERT
Top Expert 2008
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION