Cloning Oracle EBS R12.2.7 with Database 19c using (Offline or Snapshot)

 The following are the highlevel steps to Clone Oracle EBS R12.2.7 with Database 19c using (Offline or Snapshot).


Steps to Clone DB:

-          run adpreclone.pl on production DB

-          run adpreclone.pl on production application

-          Downtime starts here for (30 minutes)

-          shutdown the production DB & Application services

-          Take a snapshot of Production DB and Application

-          Start the production DB and Application services

-          Downtime ends here

-          Prepare a new TEST VM using the Production DB snapshot with different IP and Hostname

-          Prepare a new TEST VM using the Production Application snapshot with different IP and Hostname

-          Run perl adclonectx.pl and create DB context file

-          run adcfgclone.pl and configure the TEST DB technology stack

-          create listener.ora and tnsnames.ora for the TEST DB

-          start listener in TEST DB

-          connect to TESTCDB and rename CDB

-          SQL> alter pluggable database "PROD" close;

-          SQL> alter pluggable database "PROD" unplug into '/oraprod/oracle/db/19.3.0/dbs/PROD.xml';

-          SQL> drop pluggable database "PROD";

-          SQL> create pluggable database "UPG" using '/oraprod/oracle/db/19.3.0/dbs/PROD.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_PROD','ebs_UPG','PROD_ebs_patch','UPG_ebs_patch');

-          SQL> alter pluggable database "UPG" open read write;

-          Restart the TEST DB it should show TEST as PDB

-          Startup PDB and save its state

-          SQL> alter pluggable database all open;

-          Run the library update script against the TEST DB

-          sqlplus / as sysdba @adupdlib.sql

-          Set the Target UTL_FILE_DIR

-          Run txkCfgUtlfileDir.pl

-          Run adcfgclone.pl to configure TEST DB

-          Restart the TEST DB

-          Restart TEST CDB Listener

-          Check the TEST CDB and PDB status it should be up and running

 

 

Steps to Clone Application:

-          Configure Target Application Node

-          Run perl adpreclone.pl appsTier

-          Run adautoconfig

 


Comments

Post a Comment

Popular posts from this blog

adop phase=prepare failed with error "data dictionary corrupted"

  After fresh clone when I run adop phase=prepare then prepare phase failed with the error "data dictionary corrupted". Solution: Follow the instructions in the "Fix data dictionary corruption" section of My Oracle Support Knowledge Document 1531121.1 . *  Fix Data Dictionary Corruption ( Conditional ) Copy the script $AD_TOP/patch/115/sql/adzddmpfix.sql to the database tier. On the database tier, connect to the database as SYSDBA. Run the $AD_TOP/patch/115/sql/adzddmpfix.sql script. [oraprod@deverpdb01 12.1.0]$ sqlplus / as sysdba SQL> @adzddmpfix.sql On the application tier, run the $AD_TOP/sql/ADZDDBCC.sql script again to identify whether data dictionary corruption is still present. [applprod@deverpapp01 sql]$ cd $AD_TOP/sql [applprod@deverpapp01 sql]$ sqlplus apps @ADZDDBCC.sql a.     If no corruption is found, proceed with the upgrade or patching cycle. b.   ...
Read more

upgrade the AD/TXK Delta Patch to 14 in Oracle EBS R12.2.7

Image
  Environment: - Multi-node Applications (1 Internal Node & 1 External Node)    - Single Database Node - Version: Oracle EBS R12.2.7 and Database 19c ----------------------------------------------------------------------------------------------------------- We have to upgrade the AD/TXK level to 14. Follow the read me of AD patch 33600809 and perform all the steps as per read me and apply the patch using ADOP - Usually there will be only 2 patches to be applied to upgrade to AD/TXK. i.e. one patch for AD and another patch for TXK. But, in our environment we have Arabic Language enabled so I have to apply the AD/TXK patches for Arabic also. But, if no additional language is installed then you have to apply only English language patches which is the default. Below are the 4 patches which I have downloaded for English and Arabic If you have only English language in your setup then you have to download and install the below 2 patches only. 33600809:u33600809.drv  ...
Read more

Apply Latest CPU Patch of April 2024 on Oracle EBS R12.2.7 Application and Database 19c

Image
  Ref: Oracle E-Business Suite Release 12.2 Critical Patch Update Availability Document (April 2024) (Doc ID 3007752.1) As mentioned in the above document, before applying the Latest CPU patch we need to run ECPUC tool to identify any missing patches at Application node. To run ECPUC, download  Patch 35583866  and follow the instructions in the patch  Readme.txt  file. 3.2.1 EBS CPU Patches and Security Fixes  [applprod@upgapp03 oracle]$ . EBSapps.env run [applprod@upgapp03 scripts]$ cd $PATCH_TOP [applprod@upgapp03 patch]$ pwd /applprod/oracle/fs_ne/EBSapps/patch [applprod@upgapp03 patch]$ cd ECPUC/ [applprod@upgapp03 ECPUC]$ unzip p35583866_R12_GENERIC.zip [applprod@upgapp03 ECPUC]$ sqlplus apps/apps@UPG SQL> @ECPUC.sql SECTION-2 Oracle E-Business Suite (EBS): Instance Information ======================================================================== ***************************************************************************...
Read more