Autoconfig failed - ORA-01422: exact fetch returns more than requested number of rows

--------------------------------------------------------------------------
Autoconfig failed - ORA-01422: exact fetch returns more than requested number of rows
------------------------------------------------------------------



ERROR
-----------------------
Script Name : txkGenADOPWrapper.pl
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=
SQL*Plus: Release 10.1.0.5.0 - Production on Fri Nov 18 19:21:46 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> SELECT ad_zd_adop.get_node_type('cloned-node-name') 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 3053
solution: connect to apps schema and run exec
sqlplus apps/apps
sql>exec FND_CONC_CLONE.SETUP_CLEAN;
Run Autocfig Db tier first and Run Autoconfig apps tier
-------------------------------------------------------------------------------------------
appsdbahelp

17+ years of experience in Oracle Database, Oracle Cloud Infrastructure(OCI), Oracle EBS on Cloud, Oracle E-Business Suite, DevOps tools, Oracle WebLogic, Oracle Application Server, Oracle Access Manager and various Operating System flavors including Redhat Linux, UNIX (Solaris, HP-UX) and Windows. Expert in Oracle9i/10g/11g/12c/19c database administration, upgrade, configuration and tuning. Experience in Oracle E-Business Suite technological stack, including architecture, installation, configuration, maintenance, tuning, cloning and patching procedures. Expert in Oracle Cloud Infrastructure(OCI), Oracle EBS On Cloud and Oracle EBS Cloud Manager Experience with Oracle Cloud Solution and Expert of Oracle ERP/Oracle HCM Cloud deployment Experience in Terraform, JSON and chef cloud infrastructure automation framework Knowledge of ASM, Data Guard, Real Application Cluster, Exadata and Exalogic Knowledge of Oracle Enterprise Manager(OEM) Grid Control, Oracle WebLogic, Oracle Internet Directory, Oracle Access Manager and Apache Ability to analyze problem, develops solutions and bring program/project execution to completion.

1 Comments

Previous Post Next Post