Apps DBA Workshop

This article illustrates step-by-step upgrading of a RAC database from 11.2.0. to 11.2.0.4. High Level steps: 1) Install 11.2.0.4 RDBMS software with RAC option 2) Perform full database backup of 11.2.0.1 database in mount stage 3) Run DBUA from 11.2.0.4 Oracle_home 4) Verify number of INVALID objects and version of database 1) Install 11.2.0.4 RDBMS software with RAC option - Make sure that proper DISPLAY variable is configured and execute ./runInstaller - Follow screen shots - current version of database. 3) Run DBUA from 11.2.0.4 Oracle_home Database has been successfully upgraded from 11.2.0.1 to 11.2.0.4. thanks for reading. regards, X A H E E R

In this article i will illustrate all steps involved in cloning an Oracle E-Business suite environment using online backup. There are other ways also to do a clone of database with online backup. But in this article I am illustrating rman database cloning with nocatalog option. - Database will be backed up using rman - Application File system will be backed up when all services are up and running. source system - Existing system for which you want to create a new copy target system - New system on which clone is prepared Source and target OS   - oracle solaris 10 - sparc 64-bit Application Version - R12.1.1 Database Version   - 11.1.0.7 High Level Steps: Install all required rapid clone patches from Note "406982.1" on source system if doesn't exists. Run clone preparation script (adpreclone.pl) on database and application Tier Perform full database backup using rman Perform application file system backup using tar/backup too...