Hitesh Verma - Oracle Apps DBA

Step to create a new Compartment under Root Compartment 1) Login to Oracle Cloud OCI 2) Navigate to Identity --> Compartments 3) Fill up the details and click on create. After the above step you will successfully create a new compartment in Oracle OCI

Oracle SOA Source Details Weblogic Version - 12.2.1.0.0 SOA Suit Version - 12.2.1.0.0 Oracle Linux Version - 6.0 Oracle SOA Target Details  As this is a lift and shit migration there is no upgrade hence the version of application remains same Weblogic Version - 12.2.1.0.0 SOA Suit Version - 12.2.1.0.0 Oracle Linux Version - 7.0 Steps to Migrate Oracle SOA using lift and shift method. 1) Copying the binaries from source to target 2) Configuring the domain with new database or existing database 3) Verifying the Domain configuration 4) Starting the application To start with this migration in details, assuming that you already have a database with all existing metadata schema available. As this is a lift and shift method you will even need to have all your existing schema exported and imported to the database where your migrated SOA will connect. 1) Copying the binaries from source to target This step includes copying your full application binaries with same mount...

Source DB Version: 12.1.0.2.0 - File System Target DB Version: 12.1.0.2.0 - ASM Database Steps to Migrate Database from from File system to ASM using RMAN: 1) Take Full RMAN backup with archivelog & current controlfile from source db. 2) Copy pfile and password file from source db to target db 3) Restore RMAN backup on Target DB On Source Side: We will be targeting to take a hot backup assuming we dont have downtime, hence it is necessary that database is up and running, if not please start the database. Just to note we can even take cold backup, my demonstration will be for hot backup. sqlplus / as sysdba startup Please check if the LOG_MODE is Archive select name,log_mode from v$database; Check for correct ORACLE_SID, if not set the ORACLE_SID echo $ORACLE_SID export ORACLE_SID=ORCL (To Set ORACLE_SID) Next step is to take RMAN Backup rman target / run { backup database format="PATH_TO_BACKUP_LOCATION/db_%U"; backup archivelog all forma...

Source DB Version: 12.1.0.2.0 Target DB Version: 12.1.0.2.0 Steps to Migrate Database from one instance to another: 1) Take Full RMAN backup with archivelog & current controlfile from source db. 2) Copy pfile and password file from source db to target db 3) Restore RMAN backup on Target DB On Source Side: We will be targeting to take a hot backup assuming we dont have downtime, hence it is necessary that database is up and running, if not please start the database. Just to note we can even take cold backup, my demonstration will be for hot backup. sqlplus / as sysdba startup Please check if the LOG_MODE is Archive select name,log_mode from v$database; Check for correct ORACLE_SID, if not set the ORACLE_SID echo $ORACLE_SID export ORACLE_SID=ORCL (To Set ORACLE_SID) Next step is to take RMAN Backup RMAN> backup database plus archivelog; RMAN> backup current controlfile; RMAN> exit Take a Pfile backup from the Source Instance SQL> cre...