Satishbabu Gunukula

Author

Database replay was introduced in Oracle 11g R1, and it allows you to capture workloads on a Production system and replay them in your Development or test environments while maintaining the unique characteristics of the workload. This enables the user to test a variety of system changes such as hardware/software migration, operating system/ database upgrade, patches, database config changes etc…. Continue Reading →

All Things Oracle Full Articles, Application Development, Database Administration, Database Development, Oracle Database, Troubleshooting

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 →

Database Administration, Database Development, Oracle Database

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 →

10g, 11g, All Things Oracle Full Articles, Application Development, Database Administration, Oracle Database, Uncategorized

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 →

10g, 11g, All Things Oracle Full Articles, Database Administration, Oracle Database