We will have two synchronized oracle databases. Initially at least, failover will be a manual operation requiring:

a) db-admin to manually designate the backup server as "primary"
b) All of our applications which use the DB may need to be restarted

In order that the connections to the DB do not have to be reconfigured the following tnsnames.ora prescription will be used:

GLASTPRD=
  (DESCRIPTION=
   (ADDRESS_LIST=
    (LOAD_BALANCE=off)
    (FAILOVER=ON)
    (ADDRESS=(PROTOCOL=tcp)(HOST=glast-oracle03)(PORT=1521))
    (ADDRESS=(PROTOCOL=tcp)(HOST=glast-oracle04)(PORT=1521)))
   (CONNECT_DATA=(SERVICE_NAME=GLASTPRD)))
  • No labels