High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center