Grid Infrastructure version: 11.2.0.4 (OCT 2016 PSU)
Platform : Oracle Linux 6.5
DB version: 11.2.0.4 (OCT 2016 PSU)
--- Cluster1 (production)
In production, I have a highly critical 3-node RAC DB using the following SCAN configuration.
SCAN Name: danprd-scan.apac.nsroot.net
SCAN IP1 : 169.181.23.54
SCAN IP2 : 169.181.23.55
SCAN IP3 : 169.181.23.57
-- Cluster2 ( to-be production )
I am going to migrate the above DB (using RMAN restore) to this new cluster (11.2.0.4) which uses the following SCAN configuration
SCAN Name: danwmprd-scan.apac.nsroot.net
SCAN IP1 : 169.181.23.62
SCAN IP2 : 169.181.23.63
SCAN IP3 : 169.181.23.64
+++ Potential Problem ++++
In the middleware tier, there are around 10 places where the JDBC URLs are referred. Middleware team can update all these JDBC URLs with the new SCAN name.
But, middleware team say that there could be more configuration files with JDBC URLs which THEY MAY NOT AWARE OF !!! After migrating the DB to the new cluster and if all the application modules cannot connect to the DB in the new cluster because some JDBC URLs were not updated with new SCAN name, then the business will have huge monetary losses.
So, If such a situation arises , I want to change the SCAN name of Cluster2 to that of the production one (after shutting down the production cluster). Since the application only uses the SCAN name , I don't want to change the IPs of Cluster2 to that Cluster1(Production)
1) Is it even possible to change SCAN name and IP of a cluster ?
2) Is it recommended to change SCAN name and IP of a cluster ?
Message was edited by: spiral Removed Changing the IP of Cluster2 as it not needed