Data Guard

hi,

I have a question, I have a data guard solution (not in production at this time, but still).

I have the databases in the listener.ora file, otherwise the switchover command can't mount the "new" standby database.

However, when the database is in the listener.ora file, then the failover doesn't work. Failover in tnsnames.ora is defines like this:

FY_PROD =

(DESCRIPTION=

   (ADDRESS_LIST=

     (FAILOVER=on)

     (LOAD_BALANCE=off)

     (ADDRESS=(PROTOCOL=tcp)(HOST=atp-fyp-ora01)(PORT=1521))

     (ADDRESS=(PROTOCOL=tcp)(HOST=atp-fyp-ora02)(PORT=1521)))

   (CONNECT_DATA=(SERVICE_NAME=FY1P)))

It never hit's the atp-fyp-ora02 server while atp-fyp-ora01 is statics in the listener.