Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

apply the latest AD and TXK get issue

3378199Feb 28 2017 — edited Mar 1 2017

Dear 

     I want to upgrade new installation ebs from 12.2.0 to 12.2.6.

     follow the step with  Doc ID 2114016.1 and  Doc ID  1617461.1.

     at 3.1.2 (Doc ID  1617461.1)  Run Installation Steps (before is normal)

     On the run edition application tier file system, apply Patch 21841299 (R12.AD.C.Delta.8) in hotpatch mode.

   $ adop phase=apply patches=21841299 hotpatch=yes

   i got some issues such as

There are now 90 jobs remaining (current phase=A15):

    0 running, 2 ready to run and 88 waiting.

Assigned: file ad_adop_session_patches.xdf on worker  1 for product ad  username APPS.

Time is: Fri Feb 24 2017 17:18:32

  FAILED: file ad_adop_session_patches.xdf on worker  1 for product ad  username APPS.

then I cancel the adop session ,and power off the virtual machine.

the second day, I found the " adop phase=prepare " Can not be executed successfully  after  started OS and database .

SQL> SQL> Connected.

SQL> from fnd_nodes fn, adop_valid_nodes avn

                           *

ERROR at line 3:

ORA-00942: table or view does not exist

Then I tried to solve it manually

grant READ,ALTER,DELETE,INDEX,INSERT,SELECT,UPDATE,REFERENCES,ON COMMIT REFRESH,QUERY

REWRITE,DEBUG,FLASHBACK on APPLSYS.ADOP_VALID_NODES TO APPS;

create synonym apps.ADOP_VALID_NODES for applsys.ADOP_VALID_NODES;

executed "adop phase=prepare" again

ERRORMSG: Cannot identify any valid application tier nodes in

          ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes.

I tried to execute autoconfig

cd $ADMIN_SCRIPTS_HOME

./adautocfg.sh

AutoConfig completed with errors.

vi /u01/oracle/VIS/fs1/inst/apps/VIS_ebssrv/admin/log/02281348/adconfig.log

[APPLY PHASE]

  AutoConfig could not successfully

  txkGenADOPValidNodes.sql    INSTE8_APPLY  

Can you give me some advice on this situation ?

Comments
Post Details
Added on Feb 28 2017
3 comments
3,769 views