Tuesday 13 January 2015

EBS : autoconfig fails in dbTier (afdbprf.sh, adcrobj.sh)

Error:

[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:
      <filename>  <phase>  <return code where appropriate>

  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /oradb/oracle/11.2.0.3/appsutil/install/TEST_drebsdb01
      afdbprf.sh              INSTE8_PRF         1

  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /oradb/oracle/11.2.0.3/appsutil/install/TEST_drebsdb01
      adcrobj.sh              INSTE8_APPLY       1


AutoConfig is exiting with status 2

AutoConfig execution completed on Tue Jan 13 10:39:20 2015

Time taken for AutoConfig execution to complete : 0 mins  17 secs


Solution:

Step 1: Create the appsutil on the AP Tier again
perl $AD_TOP/bin/admkappsutil.pl

[applprod@driebsapp01 appl]$ perl $AD_TOP/bin/admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /appl/inst/apps/TEST_driebsapp01/admin/log/MakeAppsUtil_01131144.log
output located at /appl/inst/apps/TEST_driebsapp01/admin/out/appsutil.zip
MakeAppsUtil completed successfully.


Step 2: Copy the above created zip to the DB Tier Oracle Home
scp -pr appsutil.zip dbTier Oracle_Home

Step 3: On DB Tier
cd $ORACLE_HOME
unzip -o appsutil.zip

Step 4: Rerun autoconfig
$ORACLE_HOME/appsutil/bin/adconfig.sh contextfile={$CONFIG_FILE}

3 comments:

  1. Hi,

    Run the below script it's easy.

    FND_CONC_CLONE.SETUP_CLEAN procedure as apps user :
    SQL> conn apps/
    SQL> exec fnd_conc_clone.setup_clean;
    SQL> commit;
    SQL> exit;

    Thanks,
    Dumidu.

    ReplyDelete
  2. I m running on node 2 still it is happening..do we still need to clean and do..clean..it will erase node one entry from.fnd nodes

    ReplyDelete
  3. i am trying to change the IP But getting error autoconfig fails in dbTier (afdbprf.sh, adcrobj.sh) i followed you are procedure but still getting same error.

    ReplyDelete

SQL Developer displaying Junk characters (??????)

Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...