Windows Single Sign-On to an Oracle database using Kerberos

I’ve recently been investigating Kerberos authentication as a means for providing Windows Single Sign On from Windows clients into an Oracle database servers. Maybe you are wondering one of the following questions. What on earth does Kerberos authentication have to do with Microsoft Windows? Don’t you have to pay extra money to Oracle for such …

Windows Single Sign-On to an Oracle database using Kerberos Read More »

12.2 controlfile backup never gets marked as obsolete

I’ve blogged about this bug in passing, but I thought would be worthwhile to document my testcase.    Basically backups of controlfiles never get marked as obsolete. The issue reproduces for both image copies and backupsets, my test-case uses the latter for simplicity. RMAN> show all; RMAN configuration parameters for database with db_unique_name PVJTEST are: CONFIGURE …

12.2 controlfile backup never gets marked as obsolete Read More »

Slovenia & Croatia Oracle User Group Conferences 2017

The fact that these two conferences run back-to-back seemed a perfect opportunity to experience both, at the expense of a single long-haul flight.  Their taking place at amazing locations on the Istrian coast which I had never visited before sealed the deal. I submitted abstracts and was delighted when they both accepted me to speak. …

Slovenia & Croatia Oracle User Group Conferences 2017 Read More »

In-Memory Column Store and tables with more than 255 columns

Last week, developers reported some unexpected behavior on a test system.  I thought I would take advantage of the long weekend here in Hong Kong to build the simplest possible reproducible testcase.  I find this is useful to not only in allowing others to easily test on their system, but also to distill exactly what …

In-Memory Column Store and tables with more than 255 columns Read More »

High Five POUG

Earlier in the year while digging into AWR Warehouse internals I noticed that POUG (Pint with/Polish Oracle User Group depending on who you ask) had opened their call for papers so on impulse I submitted an abstract and thought no more about it. I was surprised to receive a response that I could attend as …

High Five POUG Read More »

“ORA-20110: set stamp set count conflict” after upgrading to 12.2 Recovery Catalog

This is the second time we have hit this error after upgrading the recovery catalog to 12.2. The first is now documented by Oracle as Document 2291791.1, and affects 12.1 multi-tenant instances with DBBP 12.1.0.2.161018 or later applied. If you have applied that patchset, you can see the problem by checking the contents of file …

“ORA-20110: set stamp set count conflict” after upgrading to 12.2 Recovery Catalog Read More »

Instance crash when not restarted through clusterware after patching

We had some issues, fortunately on a test instance, after applying a database patch. With the help of a colleague (thanks Kei) I was able to identify what had gone wrong and setup a testcase to demonstrate the issue. I think it is worth sharing as it reveals some of the complexities of the relationships …

Instance crash when not restarted through clusterware after patching Read More »

Scroll to Top