Using the adodfcmp and FndXdfCmp utilities to manually create and verify 11i database objects

Posted by Gavin Soorma
On April 27, 2012
0 Comments

Recently while applying the Financials Family Pack G, we encountered some issues where certain forms and libraries were not compiling and we had to manually create some new tables and packages and also modify some existing tables and view. We can not only create new database objects, but also verify if the objects currently stored […]

Posted by Gavin Soorma
On April 19, 2012
3 Comments

A common DBA task is to perform regular clones and database refreshes of the production database for the purpose of setting up training or test or development environments. If we are having a physical standby Data Guard environment, then we can easily offload the potentially I/O and CPU intensive backup process required for creating these […]

Posted by Gavin Soorma
On April 18, 2012
2 Comments

This note details the procedure used to upgrade an OEM Grid Control 10.2.0.5 environment on Linux to Oracle 12c Enterprise Manager Cloud Control. Broadly speaking at a high level, these are the main steps involved in the 12c upgrade. Decide on what upgrade you are going to follow. I have used the 2-System Upgrade approach […]

Posted by Gavin Soorma
On April 4, 2012
0 Comments

This note outlines the procedure to clone or refresh an Oracle Real Application Clusters database using the RMAN Duplicate Database feature. In case of a RAC to RAC clone, with RMAN Duplicate we first create a target or duplicate single instance database and then convert the single instance database to a RAC database. While the […]

News

Using the adodfcmp and FndXdfCmp utilities to manually create and verify 11i database objects

Performing a database clone using a Data Guard physical standby database

Upgrading 10g Grid Control to Oracle Enterprise Manager 12c

RMAN Duplicate Database RAC to RAC