Hi Yves,
I configured FSFO on one of the productive system, but I am not sure that this mechanism is supported by SAP. It is better you open a ticket and ask to SAP AGS.
Best regards,
Orkun Gedik
Hi Orkun,
Thanks for the information.
I did already open an OSS message on that topic, but sometimes you get quicker and wiser answers from SDN
I'm currently reading all the documentation on FSFO, not as easy as reading a single SAP document... it's a tough time ;-)
Can you please confirm that to install the observer you need to install the client administrator wth OUI ?
Where did you install the observer?
I think I'll install it on one of the SAP AS.
Best regards
Yves
>> Where did you install the observer?
It can be installed on the diffferent host from the DG broker and/or database host. It can can be installed on the SAP application server, but I recommend to install a dedicated server.
Best regards,
Orkun Gedik
Hi
I did get an answer from SAP...
FSFO have not been tested by SAP, though we do not see any technical reason for that not to be used.
So you can use this feature, but you will not have technical support from SAP if you come up into an issue related to this feature. All otherfeatures will still be supported by us in case you decide to use FSFO.
I've asked also how to get some support from Oracle as far as SAP users does note have access to Metalink any more (since more than a yeaur now... a real shame !)
758563 - Oracle Metalink access for SAP customers
In case you need support for FSFO you can open a message and we'll involve Oracle to help you with the issue.
Hello Yves,
i think you are mixing up two things here (TAF and FAN). There are two nice white papers, which describes each in a DG environment and how they interact together.
However - yes it works fine in a SAP environment.
Best Regards
Stefan
Hello Stefan,
Thanks for the information.
TAF & FAN are just two sides of FCF... Oracle has too many acronyms for that mechanism.
It's all about activating FCF (Fast Connection Failover) through FAN (Fast Application Notification) & TAF (Transparent Application Failover)... obvious !
Wish I had some clear statements from SAP on that point...
If we have setup an DG broker + observer it is just a matter of configuring , FAILOVER , FAILOVER_MODE and CONNECT_TIMEOUT parameters in the TNSAME files of SAP AS.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/restart002.htm#CIHJEDDA
You can use Oracle Notification Services (ONS) to immediately notify clients of the failover of services between the primary and standby databases. The Oracle Data Guard Broker uses Fast Application Notification (FAN) to send notifications to clients when a failover occurs.
My concerns are more on the FAILOVER_MODE method option, if set to BASIC as recommended by SAP the client reconnection might fail. If set to PRECONNECT R3trans might fail.
Well the proof is in the eating... so I'll test this by my own, and keep the thread updated.
Best regards
Yves
Hi Yves,
sorry is still don't get your point why you concern about the FAILOVER_MODE and PRECONNECT in a DG environment, because of your service is not available on standby site before a FAILOVER or SWITCHOVER. So the connect to the backup instance will not work.
Have you check the described procedure in the white paper?
OCI Clients: Notification and reconnection is accomplished for OCI clients in a Data Guard configuration using Fast Application Notification (FAN) and Transparent Application Failover (TAF) in the following manner:
• When an OCI client makes a connection to a primary database, the REG$ table is updated to includes the IP address for the client. This data is automatically replicated to the physical standby.
• Upon failover, the Data Guard broker inserts a DB Down event into the database alert queue on the standby which is then sent to all clients having an entry in the REG$ table. Note that this method of automating client failover requires the failover to be managed using the Data Guard broker.
• When clients receive the DB Down event they immediately disconnect from the failed primary.
• TAF enables OCI clients to automatically attempt to create a new connection to the service 'sales', used in the above example.
So your OCI client gets the information about the FAILOVER / SWITCHOVER and tries to reconnect immediately to your defined host(s) with the available service. DG is not RAC and you have the (connect) service only available at your primary site.
Regards
Stefan
Hi Stefan,
I did focus on the 11g document, so I missed this information, and I was misled by wrong info grab on the internet about PRECONNECT. You're true it for RAC and not applicable (nonsense) with DG.
Thank you very much for your help and time
Best regards
Yves
