- Powered by
- WordPress
-
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…
-
Getting started with iSCSI part I-Openfiler Fundamentals
After having read a number of articles detailing the use of Openfiler and Real Application Clusters I was intrigued, especially by the prospect to set up my own extended distance cluster. There was an excellent article by vnull (Jakub Wartak) on OTN about how to do this. So Openfiler seems to be my “SAN”, provided…
-
Connected to an idle instance-RAC 10.2.0.4.1
I encountered a strange problem today with a 3 node cluster. Let’s start with the facts first: RHEL 5.3 64bit Oracle Clusterware 10.2.0.4 + bundle patch#4 Oracle ASM 10.2.0.4.1 (that is PSU 1) ASMLib in use Cluster members: nodea, nodeb, nodec (their real names are known to the author) UPDATE 221219: Oracle 10.2 is effectively…
-
Build your own RAC system part IV – extending Grid Infrastructure
UPDATE 221103: Oracle 11.2 is effectively out of support, this article is now archived and should not be referred to After having experimented with my 11.2.0.1 Clusterware setup in the lab, I thought it was time to put the promise of easy extensibility to the test and run addNode.sh to extend the cluster to two…
-
Archivelog retention policy changes in RMAN 11g
UPDATE 221103: Oracle 11.2 is effectively out of support, this article is now archived and should not be referred to In the past, that means at least until 10.2.x it used to be a bit clumsy to set the archivelog deletion policy to “applied on standby” on both primary and standby database. It involved setting…
