Upgraded 12.2.5 Instance Database Tier Cloning Issue Resolution - 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.

Database Tier Cloning Issue

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 into ("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:281)
at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:332)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:757)
at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:228)
at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1721)
at oracle.apps.ad.clone.ApplyDatabase.runCVM(ApplyDatabase.java:3108)
at oracle.apps.ad.clone.ApplyDatabase.runCVMAndAutoConfig(ApplyDatabase.java:3050)
at oracle.apps.ad.clone.ApplyDatabase.doConf(ApplyDatabase.java:678)
at oracle.apps.ad.clone.ApplyDatabase.doApply(ApplyDatabase.java:493)
at oracle.apps.ad.clone.ApplyDatabase.<init>(ApplyDatabase.java:384)
at oracle.apps.ad.clone.ApplyDBTier.<init>(ApplyDBTier.java:116)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at oracle.apps.ad.clone.util.CloneProcessor.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
 
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;

[oraprdcl@r1225td PRDCL_r1225td]$ sh adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/PRDCL/db/tech_st/11.2.0/appsutil/log/PRDCL_r1225td/11140209/adconfig.log

AutoConfig is configuring the Database environment...

AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/PRDCL/db/tech_st/11.2.0
Classpath : :/u01/PRDCL/db/tech_st/11.2.0/jdbc/lib/ojdbc6.jar:/u01/PRDCL/db/tech_st/11.2.0/appsutil/java/xmlparserv2.jar:/u01/PRDCL/db/tech_st/11.2.0/appsutil/java:/u01/PRDCL/db/tech_st/11.2.0/jlib/netcfg.jar:/u01/PRDCL/db/tech_st/11.2.0/jlib/ldapjclnt11.jar

Using Context file : /u01/PRDCL/db/tech_st/11.2.0/appsutil/PRDCL_r1225td.xml

Context Value Management will now update the Context file

Updating Context file...COMPLETED

Attempting upload of Context file and templates to database...COMPLETED

Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.