Oracle Database Source Control made easy using Red Gate’s new tool

Satishbabu Gunukula on 01 March 2013 with 0 comments

Red Gate is launching new tool “Source Control for Oracle tool” on March 12, 2013. How this tool can help you: Manual processes to script out database objects and check in them into SVN or TFS, can be time consuming and error prone. Source Control for Oracle automates scripting of objects and check-in to SVN or TFS. Developers and DBAs… Continue Reading →

Convert Single Instance to RAC – Part 2: Manually Convert to RAC

Satishbabu Gunukula on 10 October 2012 with 13 comments

In part 1 I explained how to duplicate a single instance database using RMAN. This article will focus on converting the single instance to RAC. 2. Convert Single instance to RAC We have migrated the database successfully from Non-ASM to ASM using RMAN; the database is still running as single instance.  Now we need to convert the single instance database… Continue Reading →

Convert Single Instance to RAC – Part 1: Duplicate DB using RMAN

Satishbabu Gunukula on 20 September 2012 with 20 comments

This article is for users of Oracle Database version 10g+ who want to convert their Oracle single instance database to RAC.  I will provide detailed procedure for converting non-RAC database to RAC and we will use Oracle Automatic storage management (ASM) as shared storage. In general, if the database is small then you can consider installing a new RAC database… Continue Reading →