In 12.2, adautocfg.sh fails with ORA-20001: Node name visnode1 not found in adop repository tables

 

In 12.2, adautocfg.sh fails with ORA-20001: Node name visnode1 not found in adop repository tables

Script Name    : txkGenADOPWrapper.pl
Script Version : 120.0.12020000.2
ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (/erp/applmgr/fs1/inst/apps/vis1_visnode1/admin/install/txkGenADOPWrapper.pl)
TIME    : Mon Jan 11 09:11:15 2016
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jan 11 09:11:15 2016

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> SQL> Connected.    visnode1
SQL> SELECT ad_zd_adop.get_node_type('visnode1') FROM DUAL
       *
ERROR at line 1:
ORA-20001: Node name visnode1 not found in adop repository tables
ORA-06512: at "APPS.AD_ZD_ADOP", line 3055

Background:

As part of application tier configuration, ADOP tables got cleaned with fnd_conc_clone.setup_clean procedure.
exec FND_CONC_CLONE.SETUP_CLEAN;

Following query will result 0 records or no entries of the node 'visnode1'
select * from APPLSYS.ADOP_VALID_NODES;

Solution:

Add entry into APPLSYS.ADOP_VALID_NODES table manually and retry autoconfig.
Get value of DEFAULT_EDITION from DATABASE_PROPERTIES table which is needed to add entry manually in ADOP_VALID_NODES table.

select property_value from database_properties where property_name = 'DEFAULT_EDITION';
Result was - ORA$BASE.  This may change based on your patching cycles. Take whatever value returned by this query.

insert into APPLSYS.ADOP_VALID_NODES values('visnode1','vis1_visnode1','ORA$BASE');
commit;

Rerun autoconfig.

Oracle error -1400: ORA-01400: cannot insert NULL in to ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") has been detected in FND_GSM_UTIL.upload_context_file.

 

While running Autoconfig failed:

        Attempting upload of Context file and templates to database...ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5)                ; END;: 1; Oracle error -1400: ORA-01400: cannot insert NULL into ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") has been detected in FND_GSM_UTIL.upload_context_file.

oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.upload_context_file(:1,:2,:3,:4,:5); END;: 1; Oracle error -1400: ORA-01400: cannot insert NULL in                to ("APPLSYS"."FND_OAM_CONTEXT_FILES"."NODE_NAME") has been detected in FND_GSM_UTIL.upload_context_file.

        at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:334)

        at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:337)

        at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:762)

        at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:233)

        at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1721)

        at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:787)

FAILED

COMPLETED

Solution:

drop synonym apps.fnd_nodes;
create synonym apps.fnd_nodes for applsys.fnd_nodes;
drop synonym apps.fnd_oam_context_files;
create synonym apps.fnd_oam_context_files for applsys.fnd_oam_context_files;

drop synonym apps.fnd_nodes;
create synonym apps.fnd_nodes for applsys.fnd_nodes;
drop synonym apps.adop_valid_nodes;
create synonym apps.adop_valid_nodes for applsys.adop_valid_nodes;

Upgrade EBS R12.2 To Java 1.8

 1-Apply Patch 21624242

2-Cutover

3-Cleanup

4-Stop the application

5-Download the plugin under

$COMMON_TOP/webapps/oacore/util/javaplugin

6-Run the txkSetPlugin.sh script

 -bash-4.4$ txkSetPlugin.sh 18202

7- Generate the Product jar file with force option using adadmin utility

8- start the application

ADOP failed An error occurred while generating Oracle Forms files

 

ADOP patch session fail form / report compilation

Error log :-

 An error occurred while generating Oracle Forms files.

***
Continue as if it were successful :
***

AutoPatch could not find a response to the above prompt
in the defaults file.

Solution:- 

 abandon=no restart=yes flags=autoskip

example:  adop phase=apply patches=25738975 abandon=no restart=yes flags=autoskip
 
 In addition to the autoskip option creates a new logfile called asautoskip.log 

EBS R12.2 Enable JWS from backend

--SELECT *

--FROM fnd_profile_options_tl

--WHERE user_profile_option_name = 'Enable Java Web Start';

--- FND_ENABLE_JAVA_WEB_START 

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('FND_ENABLE_JAVA_WEB_START', 'Yes', 'SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

---

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('ICX_FORMS_LAUNCHER', 'http://moi-ebs.tahaluf.ae:8000/forms/frmservlet?config=jws', 'SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

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

--ICX: Forms Launcher

SELECT *

FROM fnd_profile_options_tl

WHERE user_profile_option_name = 'ICX: Forms Launcher';

-- ICX_FORMS_LAUNCHER

SELECT po.profile_option_name "NAME", po.user_profile_option_name,

DECODE (TO_CHAR (pov.level_id),

'10001', 'SITE',

'10002', 'APP',

'10003', 'RESP',

'10005', 'SERVER',

'10006', 'ORG',

'10004', 'USER',

'???'

) "LEV",

DECODE (TO_CHAR (pov.level_id),

'10001', '',

'10002', app.application_short_name,

'10003', rsp.responsibility_key,

'10005', svr.node_name,

'10006', org.NAME,

'10004', usr.user_name,

'???'

) "CONTEXT",

pov.profile_option_value "VALUE"

FROM fnd_profile_options_vl po,

fnd_profile_option_values pov,

fnd_user usr,

fnd_application app,

fnd_responsibility rsp,

fnd_nodes svr,

hr_operating_units org

WHERE 1 = 1

AND pov.application_id = po.application_id

AND pov.profile_option_id = po.profile_option_id

AND usr.user_id(+) = pov.level_value

AND rsp.application_id(+) = pov.level_value_application_id

AND rsp.responsibility_id(+) = pov.level_value

AND app.application_id(+) = pov.level_value

AND svr.node_id(+) = pov.level_value

AND org.organization_id(+) = pov.level_value

and po.user_profile_option_name = 'ICX: Forms Launcher'

ORDER BY NAME, pov.level_id, VALUE;

Add

--http://moi-ebs.tahaluf.ae:8000/forms/frmservlet?config=jws

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('ICX_FORMS_LAUNCHER', 'http://moi-ebs.tahaluf.ae:8000/forms/frmservlet?config=jws', 'SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

 Apply Oracle Forms 10g Technology Patch 32960401

Generate JAR files with force option from adadmin

EBS R12 Update profile option from backend script

 SELECT *

FROM fnd_profile_options_tl

WHERE user_profile_option_name = 'Enable Java Web Start';

--- FND_ENABLE_JAVA_WEB_START 

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('FND_ENABLE_JAVA_WEB_START', 'Yes', 'SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

Oracle EBS R12.2 Bounce Script

 . /u02/EBS/ADPF/EBSapps.env run

adstpall.sh apps/apps4adpf<<EOF

Welcome_1

EOF

echo "Waiting for 60 seconds..."

sleep 60

ps aux  |  grep FNDLIB  |  awk '{print $2}'  |  xargs  kill -9

ps aux  |  grep FNDSM  |  awk '{print $2}'  |  xargs  kill -9

ps aux  |  grep FND

. /u02/EBS/ADPF/EBSapps.env run

adstrtal.sh apps/apps4adpf<<EOF

Welcome_1

EOF