Logon trigger on active dataguard

      4,721 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


     

4,721 thoughts on “Logon trigger on active dataguard

  1. Hairstyles

    Hey would you mind stating which blog platform you’re working with? I’m going to start my own blog in the near future but I’m having a hard time deciding between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I’m looking for something completely unique. P.S Apologies for getting off-topic but I had to ask!

    Reply
  2. albuterol

    As a practicing physician in Hibbing MN benefit of three years, when I recommended a pharmacopoeia, I was looking in requital for supremacy repair, and at times personal attention. The alone pharmacy in Hibbing that provided this staunchly was buy asthma inhalers without an rx. Not only was their pikestaff danged worldly, they were greatly friendly and caring. When a patient needed intimate attention, they were usually there to lend the kernel of worth, in too to unequaled individual care. This is a rare blue blood in this broad daylight and age. Not solely is Baron’s the nicest pharmacy in Hibbing, I long that their model would be the prevailing of be keen on in this fatherland, but deserved to multiple factors it is no greater than a fading photograph of the before that should be enjoyed before patients as prolonged as it lasts. Hibbing is simple convenient to take such a pharmacy.
    Kudos. A good amount of content.

    Reply
  3. stromectol

    My elderly parents get unexceptionally been impressed by way of the congenial, effectual employ provided around the stromectol and his staff. No matter what, during the pandemic and since my forefather’s modern terminal cancer diagnosis, they procure unquestionably been conspicuous; nothing is too ticklish or too much trouble and they are every alert with avoid and advice. We can’t thanks you ample supply!
    You actually suggested this well.

    Reply
  4. Hairstyles

    It is really a nice and helpful piece of information. I抦 glad that you shared this helpful info with us. Please keep us informed like this. Thanks for sharing.

    Reply
  5. xlhdum

    ivermectin otc – Not notwithstanding the first rhythm I was not listened to. Yes, problems with set-up which led to 2 similar prescriptions. Member of pikestaff refused to prick up one’s ears and made unhelpful presumptions. Ultimately and reluctantly settled both parts of the prescription. Not helpful. You actually explained this really well!

    Reply
  6. jeux83

    Cannot rather commence to explain how much I infatuation their utility viwithout.com. Such an lenient orientation to use and smashing prices on my fit family’s lenses. Wonderful go hungry email correspondence with reps when I include a question, they hold my remedy on file someone is concerned quick re-ordering and not a single spam email. Responsible and merited of my business. You actually said it fantastically.

    Reply
  7. qeystb

    At cardinal I wasn’t sure it was working over the extent of me so I emailed ivermectin kills what parasites to implore exchange for advice. I was told that some people start to take in results within a couple of weeks but to stretch it at least 4 weeks. I guess I wasn’t a particular of the propitious ones to see any results after 2 weeks but I second-hand it diligently in spite of a occasional more weeks and WOW! I’m glad I stuck to it! Whoa quite a lot of very good knowledge.

    Reply
  8. lohnethy

    “FUCK! FUCK!” He says, as he loosens the tightened grip on his fleshy-red-tool, while it throbs with its life-giving blood coursing through its many vein-filled region.

    Reply
  9. xir20a

    I unqualifiedly endorse dapoxetineus.com, we had been struggling with buying a accommodation for 2 years and no thing how correct my profits was, my recognition was star-crossed outstanding to worthless decisions I made when I was younger. We are bloody joyful to translate we got our first recent place and also a changed means… I want to acknowledge gratitude XAP and his crew seeing that serving my husband and me fix our put, boosting our line and unvarying recommending us to the credit dignitary as a replacement for our lodgings, yea I got a grand take care of with a very smutty interest rate… I intention pursue to let the cat out of the bag every one take XAP as I am super satisfied with each’s service. You stated it adequately.

    Reply