Avatar of d27m11y d27m11y
d27m11y d27m11y
Flag 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!
Unix OSOracle DatabaseOperating Systems

Avatar of undefined
Last Comment
schwertner

8/22/2022 - Mon
schwertner

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)
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
schwertner

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
schwertner

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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
d27m11y d27m11y

ASKER
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
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
d27m11y d27m11y

ASKER
If that is the case. In the scenario moving from Oracle to Exadata on RAC, what would be the change in tnsnames.ora.
schwertner

Single Instance or RAC installation?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
d27m11y d27m11y

ASKER
RAC installation.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.