Dataguard with after logon trigger

From: Michael Schmitt <mschmitt_at_uchicago.edu>
Date: Wed, 26 Oct 2011 15:59:19 -0500
Message-ID: <E37E556CF8A6C44381D2DA9FC354D24103485AD35CF7_at_EVS03.ad.uchicago.edu>



Hello,

We are running 11.2.0.2 Dataguard in fast_start failover mode and one of the applications we support in this configuration creates an after logon trigger to track who connects to the database. Whenever we do a controlled switchover (or unplanned failover), the Dataguard configuration gets messed up. From what I can tell the after logon trigger is causing ORA-00604 errors at some point in the rebuild process of the old primary.

Does anyone have any experience on working around an issue like this with DataGuard?

Thanks in advance

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 26 2011 - 15:59:19 CDT

Original text of this message