2 Replies Latest reply on Oct 2, 2019 4:44 PM by 2640806

    ERROR at line 1:  ORA-01422: exact fetch returns more than requested number of rows  ORA-06512: at "APPS.AD_ZD_ADOP", line 3062

    2640806

      we are performing Solaris 10 to Solaris 11 migration , as part of it we are performing Rapid clone from source  to target  . we have 3 application nodes where app1 ( Admin, manged services) &app2 (manged services load balenced with app1 node) , db ( concurrent managers and database running).

       

      we have completed app1 rapid clone on run and patch while adding db1 node and autoconfig is failing with below error.

       

      ***************************

      SQL> select ad_zd_Adop.get_node_type('dc1dbuat01') from dual;

      select ad_zd_Adop.get_node_type('dc1dbuat01') 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 3062

       

       

      SQL> select ad_zd_Adop.get_node_type from dual;

      select ad_zd_Adop.get_node_type from dual

      *

      ERROR at line 1:

      ORA-06553: PLS-306: wrong number or types of arguments in call to

      'GET_NODE_TYPE'

       

       

      SQL> COL node_name FORMAT A20

      COL note_type FORMAT A10

       

      SELECT avn.node_name,

      SQL> SQL> SQL> 2 DECODE(EXTRACTVALUE(XMLType(focf.text),'//APPL_TOP_NAME'),

      admin_node.appl_top, DECODE(avn.node_name,admin_node.node_name, 1,3),

      DECODE(ROW_NUMBER() OVER (PARTITION BY EXTRACTVALUE(XMLType(focf.text),'//APPL_TOP_NAME')

      ORDER BY avn.node_name),

      1,2,4)) node_type

      FROM

      3 4 5 6 7 8 fnd_oam_context_files focf,

      adop_valid_nodes avn,

      (SELECT node_name,

      9 10 11 EXTRACTVALUE(XMLType(text),'//APPL_TOP_NAME') appl_top

      FROM fnd_oam_context_files

      WHERE name NOT IN ('TEMPLATE','METADATA','config.txt')

      AND CTX_TYPE='A'

      AND (status IS NULL or UPPER(status) IN ('S','F'))

      AND EXTRACTVALUE(XMLType(text),'//file_edition_type') = 'run'

      AND EXTRACTVALUE(XMLType(text),'//oa_service_group_status[@oa_var=''s_web_admin_status'']')='enabled'

      AND EXTRACTVALUE(XMLType(text),'//oa_service_li

       

      NODE_NAME             NODE_TYPE

      -------------------- ----------

      dc1appuat01                   1

      dc1dbuat01                    3

      dc1dbuat01                    3