Sometimes the easiest questions isn't that easy to find an answer to :) I'm going over some notes from San Diego and the notes on how to find the RAC Cluster name caught my interest. This can of … [Read more...] about What is your RAC cluster name?
When you try o create or rebuild an oracle spatial index in another schema, there is a big chance that you have the wrong privileges. You need to make sure that the target schema has CREATE TABLE and … [Read more...] about ORA-13249: Error in Spatial index: index build failed
I managed to mess up my DNS settings after moving my private mail domains to googlemail. For some reason when i changed my MX records I also did some changes on some CNAME records, don't know how, … [Read more...] about DNS Issues
In this article I will discuss the concept of voting disks and why they are a critical component in RAC, what they are, why they are needed and how you can manage them Voting disks (also known … [Read more...] about RAC – Voting Disks, what the fuzz is all about.
This Article will go though and describe the most common tools for managing your OCR files. I will also talk about what the purpose of them and how they are managed internally. OCR … [Read more...] about Manage your Oracle Cluster Registry (OCR)
RMAN-03009: failure of delete command ... ORA-19606: Cannot copy or restore to snapshot control file I've hade some issues deleting obsolete backups. This error happen when a snapshot … [Read more...] about ORA-19606: Cannot copy or restore to snapshot control file
This article will show how to manage Oracle RAC startup and shutdown scenarios. Both for Individual instances and for all instances, also including the ASM instances. We will cover: Shutdown RAC … [Read more...] about Manage RAC – Starting and stopping – Multiple options
The name of Oracle I'm going to San Diego to day, to try to figure out the mystics about Oracle RAC. I'm really looking forward to spend one whole week only dedicated to Databases and RAC, nothing … [Read more...] about Going to San Diego
This article will show you how you can Use RMAN to create a new database using the DUPLICATE.....FROM ACTIVE DATABASE command. The steps are as follow: Create the initialization Parameter file … [Read more...] about Duplicate Active database using RMAN
This article will show you how you can clone the database files from one host to another with out using RMAN, instead only coping the required files to the new host. This is a very easy way of moving … [Read more...] about Clone the Oracle Database to new host, without RMAN