Tuesday, July 7, 2015

Run Autoconfig On DB Tier and Apps Tier

Follow below steps to run autoconfig on database tier and Application tier.

EBS version - R12.2.0
DB version - 11.2.0.3

Step 1 : Stop Application (Middle tier) services
a) source APPS environment
-bash-3.2$ source /u01/R122_EBS/EBSapps.env run

b) Check whether you source run edition
-bash-3.2$ echo $FILE_EDITION
run
-bash-3.2$

c) Now stop middle tier services
-bash-3.2$ cd $ADMIN_SCRIPTS_HOME
-bash-3.2$ sh adstpall.sh
Step 2 : run Autoconfig on DB-Tier
a) source RDBMS environment
-bash-3.2$ source /u01/R122_EBS/11.2.0.3/testdb_ebstestdb.env

b) check RDBMS environment was sourced
-bash-3.2$ echo $ORACLE_HOME
/u01/R122_EBS/11.2.0.3
-bash-3.2$

c) Now run Autoconfig on DB Tier
-bash-3.2$ cd /u01/R122_EBS/11.2.0.3/appsutil/scripts/
-bash-3.2$ ls -rlt
total 4
drwxr-xr-x 2 oracle dba 4096 Jun 18 00:16 testdb_ebstestdb
-bash-3.2$ cd testdb_ebstestdb/
-bash-3.2$ ls
adautocfg.sh adchknls.pl addbctl.sh addlnctl.sh adexecsql.pl adlsnodes.sh adpreclone.pl adstopdb.sql adstrtdb.sql
-bash-3.2$
-bash-3.2$ sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/R122_EBS/11.2.0.3/appsutil/log/testdb_ebstestdb/06180637/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/R122_EBS/11.2.0.3
Classpath:/u01/R122_EBS/11.2.0.3/jdbc/lib/ojdbc6.jar:/u01/R122_EBS/11.2.0.3/appsutil/java/xmlparserv2.jar:/u01/R122_EBS/11.2.0.3/appsutil/java:/u01/R122_EBS/11.2.0.3/jlib/netcfg.jar:/u01/R122_EBS/11.2.0.3/jlib/ldapjclnt11.jar
Using Context file          : /u01/R122_EBS/11.2.0.3/appsutil/testdb_ebstestdb.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
-bash-3.2$
Step 3 : Check Autoconfig log files
a) Check the autoconfig logfiles for any errors

-bash-3.2$ cd $ORACLE_HOME/appsutil/log/
-bash-3.2$ pwd
/u01/R122_EBS/11.2.0.3/appsutil/log
-bash-3.2$
 
Step 4 : run Autoconfig on Application Tier
a) source APPS environment
-bash-3.2$ source /u01/R122_EBS/EBSapps.env run

b) Check whether you source run edition
-bash-3.2$ echo $FILE_EDITION
run
-bash-3.2$

c) run Autoconfig on Application Tier
-bash-3.2$ cd $ADMIN_SCRIPTS_HOME
-bash-3.2$ sh adautocfg.sh
  Enter the APPS user password:
    The log file for this session is located at: /u01/R122_EBS/fs1/inst/apps/testdb_ebstestdb/admin/log/06180638/adconfig.log
        AutoConfig is configuring the Applications environment...
        AutoConfig will consider the custom templates if present.
          Using CONFIG_HOME location     : /u01/R122_EBS/fs1/inst/apps/testdb_ebstestdb
             Classpath                   : /u01/R122_EBS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/R122_EBS/fs1/EBSapps/comn/java/classes
             Using Context file          : /u01/R122_EBS/fs1/inst/apps/testdb_ebstestdb/appl/admin/testdb_ebstestdb.xml
                         Context Value Management will now update the Context file
                                  Updating Context file...COMPLETED
                                  Attempting upload of Context file and templates to database...COMPLETED
                               Configuring templates from all of the product tops...
                                  Configuring AD_TOP........COMPLETED
                                  Configuring FND_TOP......COMPLETED
                                  Configuring ICX_TOP.......COMPLETED
                                  Configuring MSC_TOP......COMPLETED
                                  Configuring IEO_TOP.......COMPLETED
                                  Configuring BIS_TOP.......COMPLETED
                                  Configuring CZ_TOP........COMPLETED
                                  Configuring AMS_TOP.....COMPLETED
                                  Configuring CCT_TOP.......COMPLETED
                                  Configuring WSH_TOP.......COMPLETED
                                  Configuring CLN_TOP.......COMPLETED
                                  Configuring OKE_TOP.......COMPLETED
                                  Configuring OKL_TOP.......COMPLETED
                                  Configuring OKS_TOP.......COMPLETED
                                  Configuring CSF_TOP.......COMPLETED
                                  Configuring IBY_TOP.......COMPLETED
                                  Configuring JTF_TOP.......COMPLETED
                                  Configuring MWA_TOP....COMPLETED
                                  Configuring CN_TOP........COMPLETED
                                  Configuring CSI_TOP.......COMPLETED
                                  Configuring WIP_TOP.......COMPLETED
                                  Configuring CSE_TOP.......COMPLETED
                                  Configuring EAM_TOP.......COMPLETED
                                  Configuring FTE_TOP.......COMPLETED
                                  Configuring ONT_TOP.......COMPLETED
                                  Configuring AR_TOP........COMPLETED
                                  Configuring AHL_TOP.......COMPLETED
                                  Configuring IES_TOP.......COMPLETED
                                  Configuring OZF_TOP.......COMPLETED
                                  Configuring CSD_TOP.......COMPLETED
                                  Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
-bash-3.2$
Step 5 : Start Application (Middle tier) services
a) start middle tier services
      
-bash-3.2$ echo $FILE_EDITION
run
-bash-3.2$ cd $ADMIN_SCRIPTS_HOME
-bash-3.2$ sh adstrtal.sh
That's it..Now check application.

Thanks,
Chowdari

Sunday, July 5, 2015

Oracle EBS R12.2 installation on Linux Virtual Box

This is a step by step detailed article for Installing Oracle E-business suite R12.2 on Oracle Enterprise Linux 5.7 (64-bit). I have used oracle virtual box for Installing Linux.

This Installation is demonstrated on virtual machine with 6GB RAM and CPU (2 core) and Installation completed in 7 hours. I am not sure whether this Installation will work with less than this.
Follow my previous article for create Oracle VirtualBox and installation of Oracle Enterprise Linux 5.7 (64 bit).

Note: As per documentation should use minimum 8GB RAM, 2 core CPU and 180 GB (for fresh prod DB)/300 GB (vision DB) diskspace.

After installed the OEL 5.7, follow below steps.

Prepare staging area:

a) Download all required EBS R12.2 software
b) Unzip start CD for getting buildStage.sh
c) Execute bulildStage.sh script for creating Stage

a) Download all required EBS R12.2 software

 - Download software from https://edelivery.oracle.com

Oracle E-Business Suite Release 12.2.0 Rapid Install Start Here (Part 1 of 3) V46243-01 Part 1 of 3 3.1G
Oracle E-Business Suite Release 12.2.0 Rapid Install Start Here (Part 2 of 3) V46243-01 Part 2 of 3 81M
Oracle E-Business Suite Release 12.2.0 Rapid Install Start Here (Part 3 of 3) V46243-01 Part 3 of 3 97M
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 2 (Part 1 of 5) V35231-01 Part 1 of 5 933M
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 2 (Part 2 of 5) V35231-01 Part 2 of 5 628M
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 2 (Part 3 of 5) V35231-01 Part 3 of 5 587M
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 2 (Part 4 of 5) V35231-01 Part 4 of 5 457M
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 2 (Part 5 of 5) V35231-01 Part 5 of 5 108M
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 1 (Part 1 of 2) V35230-01 Part 1 of 2 1.3G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Oracle Database 11.2.0.3.0 - Disk 1 (Part 2 of 2) V35230-01 Part 2 of 2 1.1G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 6 V35812-01 2.3G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 5 V35811-01 2.6G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 4 V35810-01 2.8G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 3 V35809-01 2.9G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 2 V35808-01 2.9G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases VISION - Disk 1 V35807-01 3.2G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 (Part 1 of 3) V35806-01 Part 1 of 3 1.4G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 (Part 2 of 3) V35806-01 Part 2 of 3 1.1G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 2 (Part 3 of 3) V35806-01 Part 3 of 3 1.0G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1 (Part 1 of 2) V35805-01 Part 1 of 2 1.4G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Databases PROD - Disk 1 (Part 2 of 2) V35805-01 Part 2 of 2 1.3G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install AS10.1.2 V35802-01 711M
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2 (Part 1 of 2) V35804-01 Part 1 of 2 1.2G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 2 (Part 2 of 2) V35804-01 Part 2 of 2 1.6G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 (Part 1 of 3) V35803-01 Part 1 of 3 1.2G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 (Part 2 of 3) V35803-01 Part 2 of 3 1.0G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install APPL_TOP - Disk 1 (Part 3 of 3) V35803-01 Part 3 of 3 1.4G
Oracle E-Business Suite Release 12.2.0 for Linux x86-64 Rapid Install Technology one-off Patches V35813-01 730M
Oracle WebLogic Server 11gR1 (10.3.6) Generic and Coherence V29856-01 1.0G
Oracle Fusion Middleware Web Tier Utilities 11g Patch Set 5 (11.1.1.6.0) for Linux x86-64 V29764-01 1.6G

b) Unzip startHere CD for getting buildStage.sh

 - Create directory for R12 Stage
 - unzip parts of StartCD in R12 Staging directory

-bash-3.2$ cd /u01
-bash-3.2$ mkdir StageR122
-bash-3.2$ cd StageR122/

 - Downloaded all zip files here

-bash-3.2$ ls
V29764-01.zip V35231-01_1of5.zip  V35231-01_5of5.zip  V35803-01_3of3.zip  
V35805-01_2of2.zip  V35807-01.zip  V35811-01.zip     V46243-01_2of3.zip
V29856-01.zip       V35231-01_2of5.zip  V35802-01.zip       V35804-01_1of2.zip  
V35806-01_1of3.zip  V35808-01.zip  V35812-01.zip       V46243-01_3of3.zip
V35230-01_1of2.zip  V35231-01_3of5.zip  V35803-01_1of3.zip  V35804-01_2of2.zip 
V35806-01_2of3.zip  V35809-01.zip  V35813-01.zip V35230-01_2of2.zip  V35231-01_4of5.zip  V35803-01_2of3.zip  V35805-01_1of2.zip  V35806-01_3of3.zip  V35810-01.zip  
V46243-01_1of3.zip
-bash-3.2$

 - Unzipped below startCD zip files

V46243-01_1of3.zip  
V46243-01_2of3.zip  
V46243-01_3of3.zip

c) Execute bulildStage.sh script for creating Stage:

 - Check rapidwiz version

-bash-3.2$ cd startCD/Disk1/rapidwiz/
-bash-3.2$ ./RapidWizVersion
Oracle E-Business Suite Rapid Install Wizard
Version 12.2.0.48
(c) Copyright 2000-2011 Oracle Corporation.  All rights reserved.
-bash-3.2$

 - This script will be located under startCD > Disk1 > rapidwiz > bin

-bash-3.2$ pwd
/u01/StageR122/startCD/Disk1/rapidwiz/bin
-bash-3.2$

-bash-3.2$ sh buildStage.sh

                Build Stage Menu
------------------------------------------------------
1.     Create new stage area
2.     Copy new patches to current stage area.
3.     Display existing files in stage TechPatches.
4.     Exit menu

Enter your choice [4]: 1

         Rapid Install Platform Menu
------------------------------------------------------
1.    Oracle Solaris SPARC (64-bit)
2.    Linux x86-64
3.    IBM AIX on Power Systems (64-bit)
4.    HP-UX Itanium
5.    Exit Menu

Enter your choice [5]: 2
...................
...................
...................
Press enter to continue...

                Build Stage Menu
------------------------------------------------------
1.     Create new stage area
2.     Copy new patches to current stage area.
3.     Display existing files in stage TechPatches.
4.     Exit menu

Enter your choice [4]:   
-bash-3.2$

Install Oracle E-Business suite R12.2:

 - Make sure proper display is configured.

 Run rapidwiz from the staging directory:

-bash-3.2$ pwd
/u01/StageR122/startCD/Disk1/rapidwiz
-bash-3.2$ ls
bin            driver  File    jlib  oui       RapidWiz.cmd  RapidWizVersion      TechInstallers  unzip
ClientWiz.cmd  etc     images  jre   rapidwiz  RapidWiz.ini  RapidWizVersion.cmd  template        Xpatches
-bash-3.2$
-bash-3.2$ ./rapidwiz

Rapid Install Wizard is validating your file system......
CMDDIR=/u01/StageR122/startCD/Disk1/rapidwiz
Rapid Install Wizard will now launch the Java Interface.....

-bash-3.2$





















Verify installation: 

login to Oracle EBS and check application process. And also perform basic sanity check.

Thanks,
Chowdari.

Some Most Popular Articles