10g

PL/SQL Subtypes

Patrick Barel on 03 April 2013 with 5 comments

Technology is dominated by two types of people: those who understand what they do not manage, and those who manage what they do not understand – Putt’s Law We are always working with data and their datatypes. In the tables we constrain the data by their datatype. For instance, we create a price column of type NUMBER(4,2) telling the database… 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 →

Introduction to Scheduled Jobs

David Njoku on 17 October 2011 with 2 comments

Psst, wanna see something cool? I bet I can read your future. Your tomorrow is going to be almost exactly like your today; unless it’s a weekend, in which case it’ll be almost exactly the same as last weekend. You’re welcome: that’ll be ten quid. It is a truth that life’s events – and, by extension, computer operations – are… Continue Reading →