Martins Blog

Powered by
WordPress

  • UKOUG conference 2009-session review part 2

    This is the second part of my review of UKOUG conference 2009, day 1. Check out the first part as well! This picks up exactly where I left part 1 after Tom Kyte’s session. Virtual Insanity I remained in hall 1 to see the great presentation of James Morle. I have to say that even…

  • Do not shut down ASM when dropping a disk

    I was doing some maintenance today with an ASM disk group (10.2.0.4.1 64bit on RHEL 5.3). UPDATE 221219: this post refers to software that has long gone out of support, the information therefore has been archived and should no longer be referred to. In a nutshell, we swapped disks in the FRA to increase the…

  • A day at UKOUG Conference in Birmingham

    What a great decision to go to UKOUG #tech_ebs on Monday! I’ve managed to see presentations from Wolfgang Breitling, James Morle and Tom Kyte (twice). So that was good. But the even better part was catching up with Julian Dyke, Piet de Visser (I promise I will read more of your blog!), David Kurtz, the…

  • Selectively purging the shared pool

    Another very useful thread has developed on the oracle-l mailing list. On a side note, this is really _the_ list to be subscribed to-there are so many experienced Oracle DBAs out that it’s pure joy. But I digress, back to the problem I often face when performance troubleshooting systems is to purge a SQL statement…

  • Oracle’s secure external password store

    This post has been published in 2009 and a lot has happened since that day. It appears as if it was still quite popular, which is why I decided to update it to Oracle 19c. What hasn’t changed though is the lack of adoption of this feature. I can’t quite understand why there are still…

  • ORA-02290: check constraint (RMAN.AL_C_STATUS) violated

    I ran into this problem today when I was working on a backup problem. The scenario is as follows: Oracle 10.2.0.4 EE RHEL 5.2 PAE kernel, i.e. 32bit Backup taken on the standby database Using a recovery catalog UPDATE 221219: both Oracle 10.2 and Red Hat Enterprise Linux 5 have long since reached their designated…

  • Getting started with iSCSI part IV-Slightly advanced material

    The final part of the article series focuses on some slightly more advanced topics, such as deleting targets, device name stability and insight into how the automatic login works. UPDATE 221219: this article was written for Red Hat 5, which has since reached its designated End Of Live. The article is archived and should not…

  • Getting started with iSCSI part III-Mounting Storage

    After all the necessary work has been completed on the iSCSI appliance we are now ready to present the storage to the RAC nodes; I am using RHEL 5 for these. RHEL 5 and clones require a specific RPM to manage iSCSI storage, which is part of the distribution. Note that the package has a…

  • PRVF-4664 : Found inconsistent name resolution entries for SCAN name

    This has proven to be a worthy adversary – “PRVF-4664 : Found inconsistent name resolution entries for SCAN name”. The error has been thrown at the end of a 11.2.0.1 Grid Infrastructure installation, during the cluster verification utility run. Some bloggers I checked recommended workarounds, but I wanted the solution. Some facts first: Oracle Grid…

  • Getting started with iSCSI part II-Presenting Storage

    This part of the series focuses on how to add storage to your appliance and then make that available to your clients. I have focussed on providing quick success, and this setup is mainly for a lab to experiment with as it’s not secure enough for a production roll out. This part of the article…