12.2 Autoconfig Issue/Fixes

you might see the below error when you run adop phase=prepare

Error:

ARNING: [CVM Error Report]
The following report lists errors encountered during CVM Phase
      <filename> <return code where appropriate>
  /oard/oracle/oardappl/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkUpdateEBSDomain.pl -1

 No. of scripts failed in CVM phase: 1

I have taken the below action plan :

1) Run autoconfig manually and verify the issues.

Below are the two scripts got failed and fixes are here as follows:

1) bisdblrp.sql

2) txkappsprf.sql

Issues & Fixes :

==========

Error 1:

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:

<filename> <phase> <return code where appropriate>

[PROFILE PHASE]

AutoConfig could not successfully execute the following scripts:

Directory: /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/bin/perl -I /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /oaph/oracle/oaphappl/fs1/EBSapps/appl/au/12.0.0/perl -I /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/scripts/adexecsql.pl sqlfile=/oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/install

bisdblrp.sql INSTE8_PRF 1

Solution:

Drop the duplicate DB Links and then manually run the bisdblrp.sql script and the re-run autoconfig.

drop database link APPS_TO_APPS.WORLD  (which is owned by obt_aa)

drop database link EDW_APPS_TO_WH.WORLD  (which is owned by obt_aa)

Run the failing script (bisdblrp.sql) manually:

# cd /oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/install/

# sqlplus apps/<passwd>

SQL>@bisdblrp.sql

when prompted define the apps username, apps password and the DBNAME for this instance

Error 2:

adcvmlog.xml renamed to /oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/log/08051619/adcvmlog.xml.08051627

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:

      <filename>  <phase>  <return code where appropriate>

  [PROFILE PHASE]

  AutoConfig could not successfully execute the following scripts:

    Directory: /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/bin/perl -I /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /oaph/oracle/oaphappl/fs1/EBSapps/appl/au/12.0.0/perl -I /oaph/oracle/oaphappl/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/scripts/adexecsql.pl sqlfile=/oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/admin/install

      txkappsprf.sql          INSTE8_PRF         1

AutoConfig is exiting with status 1

AutoConfig execution completed on Tue Aug  5 16:27:42 2014

Time taken for AutoConfig execution to complete : 7 mins  56 secs

Solution:

adop phase=fs_clone -- finished sucessfully

adop phase=prepare Erroring out

I found metalink note 784254.1

 but solution provided there did not worked

SELECT DISTINCT substr(object_name, 1, length(object_name)-2) q_name

FROM dba_objects

WHERE object_type = 'RULE SET'

AND object_name like 'WF%'

AND owner in ('APPLSYS', 'APPS')

AND status = 'INVALID';

still returns

WF_JAVA_ERROR

WF_JAVA_DEFERRED

WF_WS_JMS_OUT

WF_WS_SAMPLE

WF_WS_JMS_IN

WF_JMS_OUT

WF_JMS_JMS_OUT

WF_JMS_IN

Type: ODM Question

How to recreate 'APPLSYS.WF_JAVA_DEFERRED_R' subscriber?

Type: ODM Answer

1. Ensure that you have taken a backup of your system before applying the recommended solution.

2. Run the following scripts in a TEST environment first:

Login as apps user and execute the below two scripts

declare

l_wf_schema varchar2(200);

lagent sys.aq$_agent;

l_new_queue varchar2(30);

begin

l_wf_schema := wf_core.translate('WF_SCHEMA');

l_new_queue := l_wf_schema||'.WF_JAVA_DEFERRED';

lagent := sys.aq$_agent('WF_JAVA_DEFERRED',null,0);

dbms_aqadm.remove_subscriber(queue_name=>l_new_queue, subscriber=>lagent);

end;

/

commit;

declare

l_wf_schema varchar2(200);

lagent sys.aq$_agent;

l_new_queue varchar2(30);

begin

l_wf_schema := wf_core.translate('WF_SCHEMA');

l_new_queue := l_wf_schema||'.WF_JAVA_DEFERRED';

lagent := sys.aq$_agent('WF_JAVA_DEFERRED',null,0);

dbms_aqadm.add_subscriber(queue_name=>l_new_queue, subscriber=>lagent,rule=>'1=1');

end;

/

commit;

3. Once the scripts complete, confirm that the OBJECT is VALID.

You can use the following SQL to confirm:

select object_name, object_type, status from dba_objects where object_name='WF_JAVA_DEFERRED_R' ;