Issue : Autoconfig was failing in EBS R12.2 during cloning
Error Faced :
Directory: <EBS_BASE>/fs#/FMW_Home/webtier/perl/bin/perl -I <EBS_BASE>/fs#/FMW_Home/webtier/perl/lib/5.10.0 -I <EBS_BASE>/fs#/FMW_Home/webtier/perl/lib/site_perl/5.10.0 -I <EBS_BASE>/fs#/EBSapps/appl/au/12.0.0/perl -I <EBS_BASE>/fs#/FMW_Home/webtier/ohs/mod_perl/lib/site_perl/5.10.0/x86_64-linux-thread-multi /<EBS_BASE>/fs#/inst/apps/<SID_hostname>/admin/install
txkGenADOPWrapper.pl INSTE8_APPLY 1
SQL> SQL> Connected.
SQL> SELECT ad_zd_adop.get_node_type(‘<hostname>’) FROM DUAL
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at “APPS.AD_ZD_ADOP”, line 3049
Solution :
- Backup the below tables :
sqlplus applsys/<pwd>
SQLPlus#> create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files;
SQLPlus#> create table fnd_nodes_bk as select * from fnd_nodes;
SQLPlus#> create table adop_valid_nodes_bk as select * from adop_valid_nodes;
If on AD/TXK 8 or higher:
SQLPlus#> create table ad_nodes_config_status_bk as select * from ad_nodes_config_status;
2. Truncate the following tables :
SQLPlus#> truncate table fnd_oam_context_files;
SQLPlus#> truncate table fnd_nodes;
SQLPlus#> truncate table adop_valid_nodes;
If on AD/TXK 8 or higher:
SQLPlus#> truncate table ad_nodes_config_status;
3. Run autoconfig on the database tier
4. Run autoconfig on the RUN file system.
Linux#> source <EBS_BASE>/EBSapps.env run
Linux#> cd $ADMIN_SCRIPTS_HOME
Linux#> ./adautocfg.sh
Ensure it has completed successfully.
5. Run Autoconfig on the patch file system :
a. Disable the ebs_login trigger using the following SQL.
Linux#> sqlplus system/<pwd>
SQLPlus#> alter trigger ebs_logon disable;
b. At this time Run autoconfig with the patch env sourced .
Linux#> source <EBS_BASE>/EBSapps.env patch
Linux#> cd $ADMIN_SCRIPTS_HOME
Linux#> ./adautocfg.sh
Confirm Autoconfig completed successfully
c. Enable the ebs_login trigger using the following SQL.
Linux#> sqlplus system/<pwd>
SQLPlus#> alter trigger ebs_logon enable;