foalabs

Clone an EBS R12.1.3  application along with Database 12.1.0.2  Source Environment: EBS: R12.1.3 DB: 12.1.0.2 SID: DEV121 Server: ebs122.lab DB OS user: oracle  Apps OS user: applmgr OEL Version: 6.4 Target Environment: EBS: R12.1.3 DB: 12.1.0.2 SID: GOLD121 Server: ebsupgrade.lab DB OS user: oracle  Apps OS user: applmgr OEL Version: 6.10 In case your target machine is new, please perform all pre-requisite required for an EBS environment. Pre-req Steps: On the source application tier below patches should be applied. If it is not applied cloning will have errors. Apply below patches on the application tier. Please read the Readme and follow the instructions carefully. These are critical before starting the cloning process. 23569686-R12.AD.B.delta.8 27102203-TXK AutoConfig Template Rollup patch 27135427-12.1 RAPIDCLONE CONSOLIDATED FIXES AUG/2018 Verify the below bugs as well. select bug_number from ad_bugs where bug_number in ('9171651','9833058','12404574',...

Upgrade Database 11.1.0.7 to 12.1.0.2 for EBS R12.1.3 DB version : 11.1.0.7.0 EBS: 12.1.3 Now I am going to upgrade my DB to 12.1.0.2 1) Stop all Application services and put the application in maintenance mode. 2) Below application patches need to applied. Patch 8796558 Patch 12923944 Patch 13473483 Patch 16289505 - 12c Release 1 interoperability patch for Release 12.1 Patch 18843706 - apply only if you have applied a Recommended Patch Collection (RPC) patch Patch 19558309 I will use adpatch utility to apply all the mentioned patches. 3) Install 12.1.0.2 binary in silent mode Create a directory for 12c db oracle home [oracle@ebs122 tech_st 07:01 PM]$pwd /ebs121/oracle/DEV121/db/tech_st [oracle@ebs122 tech_st 07:01 PM]$ls -ltr total 4 drwxr-xr-x. 77 oracle oinstall 4096 Dec 1 18:00 11.1.0 [oracle@ebs122 tech_st 07:01 PM]$mkdir 12.1.0 [oracle@ebs122 tech_st 07:01 PM]$ls -ltr total 8 drwxr-xr-x. 77 oracle oinstall 4096 Dec 1 18:00 11.1.0 drwxr-xr-x. 2 oracle oinstall 4096 Dec 3 19:...

Upgrade EBS R12.1.1 to R12.1.3  This post will cover the steps to upgrade EBS 12.1.1 to 12.1.3 I have already installed EBS 12.1.1  on Linux x86-64 bit platform. DB version : 11.1.0.7.0 EBS: 12.1.1 Patches to be applied 9239089- R12.AD.B.DELTA.3 9239090- Oracle E-Business Suite Release 12.1.3 9239095- Consolidated online help Post-Applying above patches 9817770- POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH 9966055- TRANSLATED VERSION OF FNDSCSGN NOT LAUNCHED Start the steps: 1) Put Application in Maintenance mode using adadmin   2) Download 12415211 and unzip. Then perform the below steps for Oracle Linux 6 cd <12.1_INSTALL_DIR>/apps/tech_st/10.1.2/lib cp -p -R stubs stubsORIG cd stubs cp <PATCH_INSTALL_DIR>/12415211/files/lib/stubs/libgcc_s-2.3.2-stub.so . ln -s libgcc_s-2.3.2-stub.so libgcc_s.so.1 ln -s libgcc_s.so.1 libgcc_s.so The instructions for the 10.1.3 Oracle Home are: cd <12.1_INSTALL_DIR>/apps/tech_st/10.1.3/lib cp -p -R stubs stubsORIG cd s...

Oracle Apps R12.1 Installation on Linux Create a Virtual Machine with 200 GB space and 10 GB Ram and 16 Gb Swap. I have used Virtual box for creating the machine. I am using OEL 6.4 version. Refer to the below link for installation of the Virtual box and OEL 6.4 https://www.funoracleapps.com/2017/02/installing-oracle-apps-r122-step-by_9.html Once the server is prepared we have to set up the rpm's and other pre-reqs. 1) I will install RPM's using oracle public repository. cd /etc/yum.repos.d Move all present repo files to backup directory. mkdir bkp mv *.repo bkp/ Download oracle public repository repo file. wget http://public-yum.oracle.com/public-yum-ol6.rep o Using a text editor, change the field ‘enabled=0’ to ‘enabled=1’ for the repositories corresponding to the machine’s operating system while also enabling the ‘addons’ channel. Here’s an example of a repo file’s entries: [ol6_latest] name=Oracle Linux $releasever Latest ($basearch) baseurl=http://public-yum.oracle.com/rep...