Category Archives: General Database

RDC Connected, Collaborated and Communicated at the SAOUG conference

They drove for hours, navigating through wet and winding roads. The unfamiliar site of baboons running along the roadside reminded them of their colleagues at work.  Neither “Average speed prosecution” nor “Toll gates” bothered them. As they reached the outskirts of the mountainous area their boredom changed to amusement. Suddenly the journey was less taxing, and within minutes the fog cleared to reveal the marvelous Champagne Sports Resort.

Errors When Starting Oracle 12c OMS

Our resource had taken leave and I had to stand in for him at one of our clients that is using Oracle 12C OMS. They are currently running 11g Databases on an Exadata Machine and they are basically using OMS to monitor the environment.

So one early morning I came in and tried to log on to OMS to check the status of my database and I got an error that I cannot be logged in and have to contact my administrator and unfortunately in this case I was the Administrator so I had to solve the issue.

Using Oracle LogMiner to determine the cause of high archivelog generation in a database

Oracle LogMiner is one of the most important but underused feature of the Oracle database. It allows us to query the contents of the (archived) redo log files using the SQL interface.

In this blog we describe in brief how to use Log Miner to extract the history of the activity in the database  from redo logs. For this specific example we were trying to determine why there was so much activity in the database between 01h00 and 02h00 leading to generation of a huge number of archives. This example was on an Oracle 10g Release 2 (10.2.0.5) database but the procedure can be used on other versions/releases.

Migrate a RAC Database to a Single Instance Database on another Server

You can use DBCA, RCONFIG or Enterprise Manager to migrate a Single instance database to a RAC database, but how do you convert a RAC database to a Single instance database?

Multiplex control files on ASM

The process of creating multiple copies of control files on oracle database is popularly called as control file multiplexing. The multiplexing controlfiles used to prevent loss of control files. If a control file is lost and the database instance crashes, it becomes impossible to bring up the database to a working state.  DBA’s need to protect control files from any type of loss, and to help with that, Oracle recommends multiplexing control files and locating them at different hard drive partitions.