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

6 comments:

  1. Hi Chowsary, i want disable forms_c4ws and ofam , i will update the context file and run autoconfig on run file system .Do we need propagate the same change to patch file system manually. If yes how could we do that.

    TIA

    ReplyDelete
    Replies
    1. Chowdari'S Oracle Dba Blog / Weblog: Run Autoconfig On Db Tier And Apps Tier >>>>> Download Now

      >>>>> Download Full

      Chowdari'S Oracle Dba Blog / Weblog: Run Autoconfig On Db Tier And Apps Tier >>>>> Download LINK

      >>>>> Download Now

      Chowdari'S Oracle Dba Blog / Weblog: Run Autoconfig On Db Tier And Apps Tier >>>>> Download Full

      >>>>> Download LINK ps

      Delete
  2. WARNING: [CVM Error Report]
    The following report lists errors encountered during CVM Phase

    /u01/app/oracle/db/tech_st/12.1.0/appsutil/bin/txkSetUnicodeCharSet.pl 1
    /u01/app/oracle/db/tech_st/12.1.0/appsutil/bin/txkCfgUtlfileDir.sh 1

    No. of scripts failed in CVM phase: 2



    WARNING: [AutoConfig Error Report]
    The following report lists errors AutoConfig encountered during each
    phase of its execution. Errors are grouped by directory and phase.
    The report format is:


    [PROFILE PHASE]
    AutoConfig could not successfully execute the following scripts:
    Directory: /u01/app/oracle/db/tech_st/12.1.0/appsutil/install/PROD_prodr122
    afdbprf.sh INSTE8_PRF 1

    [APPLY PHASE]
    AutoConfig could not successfully execute the following scripts:
    Directory: /u01/app/oracle/db/tech_st/12.1.0/appsutil/install/PROD_prodr122
    adcrobj.sh INSTE8_APPLY 1



    AutoConfig is exiting with status 2

    ReplyDelete
  3. Do you have to Oracle Doc ID which talks about the above steps ?

    ReplyDelete

Some Most Popular Articles