e-business 12.2.5 cloning –six easy steps ... - ebs-dba.com · over 20 years experience with...
TRANSCRIPT
![Page 2: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/2.jpg)
Who Am I?
Over 20 years experience with Oracle DatabaseOver 15 years experience with E-Business SuiteChair, OAUG Database SIGVice Chair, OAUG Sysadmin SIGCo-Founder AppsPerfOracle ACEOAUG Member of the Year 2013Applications DBA, BlueStar
2
![Page 3: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/3.jpg)
UserGroups
• OAUG• EasternStatesOAUG
• DatabaseSIG
• SysadminSIG
• Manyothers
• IOUG
• ODTUG
• Others
![Page 4: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/4.jpg)
Assumptions
• Oneapplicationsnode
• NotRAC
• Unixcommands
• AD/TXKDelta8for12.2.5+
4
![Page 5: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/5.jpg)
Overview
• E-Business Suite 11i to 12.2 -- Overview• E-Business Suite 11i to 12.2 -- Architecture• E-Business Suite 12.2 Cloning – Six Easy Steps• E-Business Suite 12.2 Cloning – Three Easy
Steps (12.2.5 and 12.2.6)
5
![Page 6: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/6.jpg)
Oracle Corporation Documentation
6
OracleE-Business11i ThreeTierArchitecture
Architecture: E-Business 11i/12.1/12.2 & 12.2 Cloning
![Page 7: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/7.jpg)
Oracle Corp., Steven Chan Presentation 2013
7
OracleE-Business12.1ThreeTierArchitecture
Architecture: E-Business 11i/12.1/12.2 & 12.2 Cloning
![Page 8: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/8.jpg)
Oracle Corp., Steven Chan Presentation 2013
8
OracleE-Business12.2ThreeTierArchitecture
Architecture: E-Business 11i/12.1/12.2 & 12.2 Cloning
![Page 9: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/9.jpg)
Oracle Corp., Max Arderius Presentation 2014
9
!
OracleE-Business12.2ThreeTierArchitecture
Architecture: E-Business 11i/12.1/12.2 & 12.2 Cloning
![Page 10: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/10.jpg)
10
!
OracleE-Business12.2ThreeTierArchitecture
Architecture: E-Business 11i/12.1/12.2 & 12.2 Cloning
![Page 11: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/11.jpg)
Cloning
• 3stepsoneachtier• Prepare
• Copy
• Configure
![Page 12: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/12.jpg)
Cloning
• 3 4Steps• PreparetheSource
• Copy
• Configure
• FinishApplications
![Page 13: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/13.jpg)
Cloning• PreparetheSource
• adpreclone.pl dbTier
• Always?
• Requiredincertaincircumstances
• Cold
• Databasepatches
• adpreclone.pl appsTier
• Always?
• Patches
• Anychangesthatwillimpactautoconfig
• 12.2
• Isfs1orfs2theRunFilesystem?
![Page 14: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/14.jpg)
Cloning
• Copy• Database
• HotorCold
• Applications
• Full,Differential
• rsync –a--delete
![Page 15: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/15.jpg)
Cloning
• ConfigureDatabase• Cold
• adcfgclone.pl dbTier
• RelinksandregistersORACLE_HOME
• Configuresandstartslistener
• Buildscontrolfiles,
• ResetsRedo
• Configuresthedatabase
![Page 16: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/16.jpg)
Cloning• ConfigureDatabase
• Hot• ManuallydoingthethreeinternalstepsdoneindbTier mode
• BuildOracleHome(ifdbTier preclone isnotrequired,thiscanbeskipped)
• CopyOracle_Home fromsource
• adcfgclone.pl dbTechStack• RelinksandregistersORACLE_HOME
• Configuresandstartslistener
• CopyisnowinthemiddleofConfigure
• ClonetheDatabaseusingyourfavoritemethod• rman duplicate,DiskBasedSnapshot,etc.
• sqlplus /assysdba @adupdlib so
• adcfgclone.pl dbconfig• Configuresthedatabase
![Page 17: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/17.jpg)
DatabaseClone
• Testyourbackups!• Atleastoneregularlyscheduledcloneshouldcomefrombackups
• SANsolutioncaveats• Knowyourcapacities
• Databasecapacityshouldbemeasurediniops anddatatransferrates,notstorage
• Snapshotbasedtechnologiescanhavedetrimentalimpactsonsourcedisks
• SSDminimizesbutdoesnoteliminatethis
![Page 18: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/18.jpg)
Cloning
• ConfigureApplications• adcfgclone.pl appsTier
• Configurestheapplicationfilesystem,listenersanddatabaseobjects
• Startstheapps
• Notautomaticanymore
• FinishingTasks
• Workflow
• Non-Sitelevelprofileoptions
![Page 19: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/19.jpg)
12.2Cloning
• 3 4 7Steps• PreparetheSource
• CopyonlytheRunFilesystemEBSapps directory
• ConfigureDatabase
• Applications• ConfiguretheRunFilesystem
• PreparetheRunFilesystem
• CopytheRunFilesystemtoPatch(onlyEBSapps)
• ConfigurethePatchFilesystem
• FinishingTasks
![Page 20: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/20.jpg)
Six Easy Steps: E-Business 11i/12.1/12.2 & 12.2 Cloning
OracleE-Business12.2Cloning– SixEasySteps
![Page 21: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/21.jpg)
12.2Patching• Nopatchingcanbeinprogress!!!!
• Implications• Nightlyclonesforreporting/support
• On-Demandclones
• fs_clone isnotnormallyrequired(unlessstatedinthepatchnote)
21
![Page 22: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/22.jpg)
12.2Patching
• Checkifadop sessionisactive• AppsTier
• adop –status
• SQL
• Selectdecode(status,’C’,’Not Active’,’Active’)fromad_adop_sessionswhereadop_session_id=(selectmax(adop_session_id)fromad_adop_sessions);
• Cannotclone
![Page 23: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/23.jpg)
12.2Cloning
• Weblogic Server• Cannotconfigureonthefilesystem
• adpreclone packagesWLSforinstallation
• $COMMON_TOP/clonejustgotalotbigger
• adcfgclone installsandconfiguresWLS
• Thisisnotfast
![Page 24: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/24.jpg)
12.2Gotcha
• Youmustclonetherunfilesystemfromthesource
• Itmustkeepthesamenameonthetarget
• Canbeamajorissueforscriptingyourclone
24
![Page 25: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/25.jpg)
12.2CloneWithADDelta7+
• adcfgclone.pl appsTier dualfs• Backtotheoriginalnumberofsteps
• Aftercompletingtheexpectedconfigurationoftherunfilesystem
• Automaticallyprepares
• AutomaticallycopiesEBSapps tothepatchfilesystem
• Automaticallyconfiguresthepatchfilesystem
• Itdoesnotsavetimeovertheprevious6stepprocess
• Finishingtasks
![Page 26: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/26.jpg)
AutomatingtheProcess
• Easiesttoclonemanuallythefirsttime
• OntheDBTier,copythecontextfilefromthetargetbacktothesource
• OntheAppsTier,copypairsfile$INST_TOP/appl/admin/$CONTEXT_NAME.txt• Needtoeditthefirsttimeforallresponses
![Page 27: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/27.jpg)
Pairsfile
[Base]
s_base=/u01/app/oracle/apps
s_current_base=/u01/app/oracle/apps/fs2
s_other_base=/u01/app/oracle/apps/fs1
s_ne_base=/u01/app/oracle/apps/fs_ne
[General]
…
s_port_pool=
patch_s_port_pool=
…
![Page 28: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/28.jpg)
Automation
• DBTier• adcfgplone.pl dbTier|dbconfig SID_host.xml
• AppsTier• DevelopmentInstance
• adcfgclone.pl component=appsTier pairsfile=pairsfile.txt
• Non-developmentInstance
• adcfgclone.pl component=appsTier pairsfile=pairsfile.txt dualfs=yes
![Page 29: E-Business 12.2.5 Cloning –Six Easy Steps ... - ebs-dba.com · Over 20 years experience with Oracle Database Over 15 years experience with E-Business Suite Chair, OAUG Database](https://reader033.vdocuments.us/reader033/viewer/2022041500/5e20f5d24b77ff1ded6b20d8/html5/thumbnails/29.jpg)
References
• MyOracleSupport• 1383621.1CloningOracleE-BusinessSuiteRelease12.2with
RapidClone
• 2047809.1 CloningOracleE-BusinessSuiteRelease12.2(AD-TXKDelta6orLowerCodelevel)withRapidClone
• 224274.1HowtoMakeaCopyofanOpenDatabaseforDuplicationtoaDifferentMachine
• JamesMorrowAftertheClone:Thingsadcfgclone Doesn’tdo…
29