Oracle Application Blog

[ERROR]: The value of s_patch_service_name is not set correctly in atleast one of the context files.

Cause : Query the below parameter in db context file. grep s_patch_service entry $CONTEXT_FILE (This is was not present in my context file, thus the error was tripping) Soultion :…

Read More

adop phase=fs_clone [ERROR]: At least one Oracle inventory check has failed.Provide the location of a valid inventory file.

$adop phase=fs_clone [ERROR]: At least one Oracle inventory check has failed.Provide the location of a valid inventory file. Solution : $cd /oracle/PROD/apps/fs_ne/EBSapps/log/adop/13/fs_clone_<time_cloe>/SID_hostname $vi ADOPValidations_detailed.log look for the ERROR: in the…

Read More

Useful CRSCTL Commands

STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs Enable/Disable auto restart of CRS. $GRID_HOME/bin/crsctl disable crs $GRID_HOME/bin/crsctl enable crs Find the cluster name…

Read More

How to fix INVALID status for RAC component in dba_registry

Before upgrade or after upgrade, database may show INVALID status for component Real Application Clusters in dba_registry as below .   SQL> select comp_name,version,status from dba_registry; … Oracle Real Application…

Read More

adop prepare phase failing with the error [UNEXPECTED]Nodes are listed in the ADOP_VALID_NODES table but not in the FND_NODES table.

In this post we will fix the error ‘[UNEXPECTED]Nodes are listed in the ADOP_VALID_NODES table but not in the FND_NODES table’. [applmgr@ebstest ~]$ adop phase=prepare Enter the APPS password: Enter…

Read More

How to execute empty patching cycle without applying any patch.

n: 12.2 version, we will execute the emptly patching cycle.   Can a cutover be run, from fs1 to fs2 outside of patching cycle? For testing purposes, without applying any…

Read More

txkGenADOPWrapper.pl line 143 ) ERRORCODE = 1 ERRORCODE_END WARNING: [AutoConfig Error Report]

txkGenADOPWrapper.pl line 143 ) ERRORCODE = 1 ERRORCODE_END WARNING: [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution. Errors are grouped by directory…

Read More

How to configure patch file system in R12.2

To re-create or configure the patch file system in ebs. Follow the below step’s to configure the patch file system in R12.2. 1. Run adpreclone.pl on run file system Source…

Read More

ORA-20100: Error: FND_FILE failure. Unable to create file in the directory

Problem details: ————— The Concurrent program is getting completed successfully, able to view output & logfile. But in the log file, it shows below error. Oracle error 20100: java.sql.SQLException: ORA-20100:…

Read More

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 -4063: ORA-04063: package body “APPS.FND_GLOBAL” has errors has been detected in FND_GSM_UTIL.upload_context_file.

Error: 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 -4063: ORA-04063: package body “APPS.FND_GLOBAL” has errors has been…

Read More