After AD.C.Delta 6 and TXK.6 the issue with adop phase=fs_clone

After AD.C.Delta.6 and TXK.6,

when running

$adop phase=fs_clone,

we hit with an issue:

Validating system setup...
Node registry is valid.

Checking for pending adop sessions...
No pending session exists.
Staging new adop session...
[ERROR] Failed to execute SQL statement :
begin
ad_zd_adop.INSERT_ADD_NODE_RECORDS;
end;

[ERROR] Error Message :
[ERROR] ORA-20010: ORA-01403: no data found
[ERROR] ORA-06512: at "APPS.AD_ZD_ADOP", line 2790
[ERROR] ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute)
[UNEXPECTED]Error occurred while adding new node information
[UNEXPECTED]Unrecoverable error occured. Exiting the current session.


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 2 (Fail)


When we open the AD_ZD_ADOP package body and changed the lines

From this
cursor new_nodes is
        select node_name
          from adop_valid_nodes
         where node_name not in (select node_name from ad_adop_sessions
                                  where adop_session_id = (select max(adop_session_id) from
                                                           ad_adop_sessions));

  cursor available_nodes is
        select node_name from ad_adop_sessions
         where adop_session_id = (select max(adop_session_id) from
                                  ad_adop_sessions)
           and node_name in (select node_name from
                             adop_valid_nodes)
         order by node_name;

to
 cursor new_nodes is
        select UPPER(node_name) node_name
          from adop_valid_nodes
         where node_name not in (select node_name from ad_adop_sessions
                                  where adop_session_id = (select max(adop_session_id) from
                                                           ad_adop_sessions));

  cursor available_nodes is
        select node_name from ad_adop_sessions
         where adop_session_id = (select max(adop_session_id) from
                                  ad_adop_sessions)
           and node_name in (select UPPER(node_name) from
                             adop_valid_nodes)
         order by node_name;


and compile the package and package body.



We were able to complete the fs_clone successfully.
 Generating log report...
    Output: /u01/install/APPS/fs_ne/EBSapps/log/adop/26/fs_clone_20150909_040049/PRD12241_LO64BLWPA1/adzdshowlog.out

adop phase=fs_clone - Completed Successfully

Issue identified,

May be because of our hostname all in caps.

ORA-31024: Parser initialization failed with LPX-201 error while parsing a stream to XOB

While running

adop phase=prepare, 


 select node_name from FND_OAM_CONTEXT_FILES
  2      where NAME not in ('TEMPLATE','METADATA','config.txt') and
  3          CTX_TYPE='A' and (status is null or upper(status) in ('S','F'))
  4          and EXTRACTVALUE(XMLType(TEXT),'//file_edition_type') = 'run'
  5          and EXTRACTVALUE(XMLType(TEXT),'//oa_service_group_status[@oa_var=''s_web_admin_status'']')='enabled'
  6          and EXTRACTVALUE(XMLType(TEXT),'//oa_service_list/oa_service[@type=''admin_server'']/oa_service_status')='enabled'
  7  ;


ERROR at line 4:
ORA-31024: Parser initialization failed with LPX-201 error
while parsing a stream to XOB
ORA-06512: at "SYS.XMLTYPE", line 272
ORA-06512: at line 1

While applying the patches for latest AD and TXK patches,

we were told to run

perl $ORACLE_HOME/nls/data/old/cr9idata.pl

Verify $ORA_NLS10 variable

Once, it is completed, we should source the database environment and start the database.

Once it is done, the error is gone.