Logon trigger on active dataguard

      No Comments on Logon trigger on active dataguard

Hi There,

Normally this works fine!
But today I just discovered that it could not work anymore when it has worked few weeks before.

What the…
I was able to reproduce the problem on the standby and decided to convert it to snapshot standby to see if it works.

–> Yes it works

So I convert it back to physical standby and I was guessing it’s not working again…

–> But it works now!

So what fixed the issue?

–> Database restart

Why?

–> Shared pool

Last software release has changed some package names and also the logon trigger name.

I suspect some objects in the SGA where not referenced anymore.
I think I would have fixed the problem by flushing the shared pool on the standby.

This flush might be integrated as post step for next releases.

Cheers
jko

The following two tabs change content below.

Jacques

I am Oracle Certified Master 11g & 12c database architect with significant experience in heterogeneous environments, and strong ability to lead complex and critical projects requiring multiple technical implementations. at Trivadis SA

Leave a Reply

Your email address will not be published. Required fields are marked *