Oracle Dataguard Switchover and DNS
Hi, few days ago we planned a switchover in a dataguard 10g configuration (pasive dataguard) between 2 servers.
primary: APP in europe.com
secondary: APP1 in asia.com
Both databases was Oracle 10.2.0.3 in Redhat (single instance)
Everything goes ok with the databases and the switchover but what happend with the web based applications ?
I have a lot of PHP web applicattion that have a connection string with oci and oracle client, all of them have the connection like user/pass@dbname where dbname is defined in the local tnsnames.ora with the DNS names to the host.
(All of them have xxx/xxx@APP) , and APP was ( host:europe.com and SID=APP)