txkGenADOPWrapper.pl INSTE8_APPLY 1 AutoConfig is exiting with status 1 - Autoconfig Error: ORA-01422


During cloning when running autoconfig on application node in R12.2.5:

[APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /appclone/r12crp2/fs1/FMW_Home/webtier/perl/bin/perl -I /appclone/r12crp2/fs1/FMW_Home/webtier/perl/lib/5.10.0 -I /appclone/r12crp2/fs1/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I /appclone/r12crp2/fs1/EBSapps/appl/au/12.0.0/perl -I /appclone/r12crp2/fs1/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/aix-thread-multi-64all /appclone/r12crp2/fs1/inst/apps/infrcrp2_cndarupgdbop01/admin/install
      txkGenADOPWrapper.pl    INSTE8_APPLY       1



AutoConfig is exiting with status 1

AutoConfig execution completed on Wed Apr 17 16:11:48 2019

Time taken for AutoConfig execution to complete : 4 mins  16 secs


Cause: This happens occasionally when old nodes are left in 12.2 tables and might be "fnd_conc_clone.setup_clean" was not executed.

Solution 1:


This should be resolved by running:

fnd_conc_clone.setup_clean;
Autoconfig on DB
Autoconfig on Patch fs --ignore errors
Autoconfig on Run fs --Should complete successfully now


Solution 2:

If above does not work then follow following document:


Autoconfig Error: ORA-01422: Exact Fetch Returns More Than Requested Number Of Rows (Doc ID 2212698.1)

Disable the "s_web_admin_status" parameter on the application context file of the recently cloned node and
Rerun autoconfig and confirm the issue is solved.

Comments

Bhushan said…
This comment has been removed by the author.
February 10, 2021 at 7:52 AM
Bhushan said…
Please comment if it's helpful or not.
February 10, 2021 at 7:53 AM
broseMK said…
was very helpful thanks Bhushan
March 11, 2021 at 4:56 AM
Post a Comment

Popular posts from this blog

ORA-46697: Keystore password required - create pluggable database pdb1clone from pdb1

  select con_id,name,open_mode from v$pdbs;     CON_ID NAME     OPEN_MODE ---------- -------------------------------------------------------------------------------------------------------------------------------- ---------- 2 PDB$SEED     READ ONLY 3 PDB1     READ WRITE SQL> create pluggable database pdb1clone from pdb1; create pluggable database pdb1clone from pdb1 * ERROR at line 1: ORA-46697: Keystore password required. Solution: If  TDE is configured, you have to supply the keystore password  SQL> CREATE PLUGGABLE DATABASE PDB1clone FROM PDB1  KEYSTORE IDENTIFIED BY password;
Read more

OAM 11.1.2.3 - Bad Oracle Access Manager Request Error After Applying OAM Patch 27373151 + Webgate Patch 27393427 BP 11.1.2.3.180717

After Applying OAM Patch 27373151 + Webgate Patch 27393427 BP 11.1.2.3.180717, when accessing the http resource then it was giving Bad Oracle Access Manager Like when accessing "http://hostname.domain:7779/index.html" we get following message in the logfile "diagnostics/logs/OHS/ohs1/oblog.log" 2018/10/26@15:29:46.68427       1890    1950    WEB     ERROR   0x0000151F      /ade/aime_ngamac_748106/ngamac/src/palantir/commonlib/src/apache2_req_info.cpp:294     ecid^005UIDZfNp87U8ups^h8iX0000SX00001w  rid^0   "WebGate Error Report"  Message^Unable to process the request due to unexpected error.  ReqReq^GET /public/index.html HTTP/1.1  ReqProto^HTTP/1.1       ReqHost^bdrvl-pd-oid01  ReqStatLine^    ReqStatus^200   ReqRawUri^/public/index.html    ReqUri^/public/index.html       ReqFilename^...
Read more