Link to home
Start Free TrialLog in
Avatar of d27m11y d27m11y
d27m11y d27m11yFlag for United States of America

asked on

Change in IP

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!
Avatar of schwertner
schwertner
Flag of Antarctica image

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)
Avatar of d27m11y d27m11y

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If that is the case. In the scenario moving from Oracle to Exadata on RAC, what would be the change in tnsnames.ora.
Single Instance or RAC installation?
RAC installation.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial