Issues & fixes - 12.2
Clone issue :
below issue happens if the patch file system adcfgclone fails in between and if we are restarting, we should always clean the oraInventory directory by using the following commands:
Error :
Below Oracle Homes are already registered in the global inventory:
/oaph/oracle/oaphappl/fs2/FMW_Home/Oracle_EBS-app1
/oaph/oracle/oaphappl/fs2/FMW_Home/webtier
/oaph/oracle/oaphappl/fs2/FMW_Home/oracle_common
Exiting Cloning...
Ensure that the above Oracle Homes are unregistered from the global inventory "/oaph/oracle/oaphappl/oraInventory/ContentsXML/inventory.xml" and re-run adcfgclone.pl script
Solution :
cd $ORACLE_HOME/oui/bin
./runInstaller -silent -deinstall REMOVE_HOMES={"/oaph/oracle/oaphappl/fs2/FMW_Home/Oracle_EBS-app1"}
./runInstaller -silent -deinstall REMOVE_HOMES={"/oaph/oracle/oaphappl/fs2/FMW_Home/oracle_common"}
./runInstaller -silent -deinstall REMOVE_HOMES={"/oaph/oracle/oaphappl/fs2/FMW_Home/webtier"}
Then restart the adcfgclone.pl appsTier
==============================================
adcfgclone.pl appsTier fails after it run for 20 minutes, when it tries to create the FMW_HOME. this issue happens when the clone session closed abruptly.
Reference Document: 1682612.1
Issue :
Log file located at /local/FDEV/fs2/inst/apps/FDEV_lapdev01/admin/log/clone/ApplyAppsTier_05301531.log
- 50% completed
ERROR while running Apply...
Fri May 30 17:37:39 2014
ERROR: Failed to execute /fs02/app/FDEV/apps/fs2/EBSapps/comn/clone/bin/adclone.pl
Solution :
1. Rename or delete the file:
$ mv /var/tmp/.ovdlock.tmp /var/tmp/.ovdlock.tmp.bak
2. Restart the clone command:
$ perl adcfgclone.pl appsTier
========================================
Issue :
When you run adop phase=prepare and found below errors :
adop phase=prepare failed with the following errors
[STATEMENT] Updating prepare_status=R for session_id : 19
[UNEXPECTED]Dictionary Corrupted:
[START 2014/07/07 07:22:18] Data Dictionary Curruption Details
APPS OE_CREDIT_CHECK_ORDER_PVT V_20140516_0452 APPS OE_CREDIT_CHECK_UTIL V_20140516_0452 P Status: 5
APPS OKL_PAY_CURE_REFUNDS_PVT_W V_20140516_0452 APPS OKL_PAY_CURE_REFUNDS_PVT V_20140516_0452 P Status: 5
APPS OKL_PAY_CURE_REFUNDS_PUB_W V_20140516_0452 APPS OKL_PAY_CURE_REFUNDS_PUB V_20140516_0452 P Status: 5
APPS OKL_PAY_CURE_REFUNDS_PUB_W V_20140516_0452 APPS OKL_PAY_CURE_REFUNDS_PVT V_20140516_0452 P Status: 5
...
APPS INV_OPM_LOT_MIGRATION V_20140516_0452 APPS INV_LOT_API_PUB V_20140516_0452 TS mismatch: 12-JUN-14 16:50:54 29-JUN-14 14:42:12
...
APPS INV_LOT_ATTR_PUB V_20140516_0452 APPS INV_LOT_API_PUB V_20140516_0452 TS mismatch: 12-JUN-14 16:50:54 29-JUN-14 14:42:12
APPS INV_LOT_ATTR_PUB V_20140516_0452 APPS MTL_LOT_UOM_CONV_PVT V_20140516_0452 P Status: 5
APPS CSD_SC_DOMAINS_PVT V_20140516_0452 APPS CSD_GEN_UTILITY_PVT V_20140516_0452 P Status: 5
Solution :
Reference: R12.2 Dictionary Corrupted While Running adop - "TS Mismatch" Error (Doc ID 1576086.1)
login to Database server :
1) sqlplus "/ as sysdba"
shutdown immediate
startup upgrade
2) @utlirp.sql
3) Bounce the database again and open it in normal mode.
From the same sqlplus session
shutdown immediate
startup
4) @?/rdbms/admin/utlrp.sql
5) re-run adop.
==========================================
Issue :
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_REGISTRY_SYS"
ORA-06512: at line 1
Solution:
How To Validate an Invalid SYS.DBMS_REGISTRY_SYS Package (Doc ID 438821.1)
SQL> alter trigger SYSTEM.DROPLOG_TRIGGER DISABLE;
========================================
Error :
[apploaph@oacmph scripts]$ sqlplus apps/rwnb1adr12
SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jul 7 23:18:22 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-04045: errors during recompilation/revalidation of SYSTEM.EBS_LOGON
ORA-01031: insufficient privileges
Enter user-name:
Solution:
SQL> select trigger_name,owner,status from dba_triggers where trigger_name='EBS_LOGON';
TRIGGER_NAME OWNER STATUS
------------------------------ ------------------------------ --------
EBS_LOGON SYSTEM ENABLED
SQL> alter trigger SYSTEM.EBS_LOGON DISABLE;
Trigger altered.
================================================
Issue :
*** Log File = /oaph/oracle/oaphappl/fs_ne/EBSapps/log/adop/19/prepare_20140707_233754/OAPH_oacmph/TXK_SANITY_filesystemcheck_Mon_Jul_7_23_39_23_2014/txkADOPPreparePhaseSanityCheck_Mon_Jul_7_23_39_23_2014.log
[ERROR] Minimum file system space required 25 GB while you have 17.982421875 GB
[UNEXPECTED]Error occurred while executing "perl /oaph/oracle/oaphappl/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSanityCheck.pl -contextfile=/oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/appl/admin/OAPH_oacmph.xml -patchcontextfile=/oaph/oracle/oaphappl/fs2/inst/apps/OAPH_oacmph/appl/admin/OAPH_oacmph.xml -promptmsg=hide -mode=update -console=off -sessionid=19 -timestamp=20140707_233754 -outdir=/oaph/oracle/oaphappl/fs_ne/EBSapps/log/adop/19/prepare_20140707_233754/OAPH_oacmph -action=filesystemcheck"
[UNEXPECTED]Error while runFSSanityValidateConfig sub-routine is called
[ERROR] Prepare phase completed with errors or warnings. Please check logfiles.
Log file: /oaph/oracle/oaphappl/fs_ne/EBSapps/log/adop/19/adop_20140707_233754.log
adop exiting with status = 1 (Fail)
You have new mail in /var/spool/mail/applo
Solution :
Make sure the free space is around 40 GB
=================================================
Issue :
Multiple context files exist in application side . you can view them through OAM.
because of this, you cannot add/modify customizations on your environment file.
Solution:
Remove the inconsistent row from FND_OAM_CONTEXT_FILES
STEPS:
1. Run the following script to clear out FND_OAM_CONTEXT_FILES of all entries. This will also
clear other tables like FND_NODES:
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
2. On the database Node, run autoconfig:
$ORACLE_HOME/appsutil/scripts/<context_name>/adautocfg.sh
3. On All APPS nodes run autoconfig:
$ADMIN_SCRIPTS_HOME/adautocfg.sh
4. Retest the issue.
NOTE: Step 1 will clean out all information from some FND tables, so it is important that
autoconfig is run on ALL nodes in this environment. Must run on DB nodes first.
OR
1> Backup the table: create table applsys.fnd_oam_context_files_bak as select * from
applsys.fnd_oam_context_files;
2> Truncate the table: truncate table applsys.fnd_oam_context_files
3> Run Autoconfig on all nodes to reload the context file information to the database.
4> Re-Run Autoconfig to confirm that the issue does not replicate after the first run.
5> Check the FND_OAM_CONTEXT_FILES table to ensure the data was re-populated.
Create a Custom Parameter Fails With - Customization Is Not Allowed On Different Versions of Configuration Files [ID 762590.1]
CUSTOMIZATIONS NOT ALLOWED ON DIFFERENT VERSIONS OF CONFIGURATION FILES [ID 351969.1]
Clone issue :
below issue happens if the patch file system adcfgclone fails in between and if we are restarting, we should always clean the oraInventory directory by using the following commands:
Error :
Below Oracle Homes are already registered in the global inventory:
/oaph/oracle/oaphappl/fs2/FMW_Home/Oracle_EBS-app1
/oaph/oracle/oaphappl/fs2/FMW_Home/webtier
/oaph/oracle/oaphappl/fs2/FMW_Home/oracle_common
Exiting Cloning...
Ensure that the above Oracle Homes are unregistered from the global inventory "/oaph/oracle/oaphappl/oraInventory/ContentsXML/inventory.xml" and re-run adcfgclone.pl script
Solution :
cd $ORACLE_HOME/oui/bin
./runInstaller -silent -deinstall REMOVE_HOMES={"/oaph/oracle/oaphappl/fs2/FMW_Home/Oracle_EBS-app1"}
./runInstaller -silent -deinstall REMOVE_HOMES={"/oaph/oracle/oaphappl/fs2/FMW_Home/oracle_common"}
./runInstaller -silent -deinstall REMOVE_HOMES={"/oaph/oracle/oaphappl/fs2/FMW_Home/webtier"}
Then restart the adcfgclone.pl appsTier
==============================================
adcfgclone.pl appsTier fails after it run for 20 minutes, when it tries to create the FMW_HOME. this issue happens when the clone session closed abruptly.
Reference Document: 1682612.1
Issue :
Log file located at /local/FDEV/fs2/inst/apps/FDEV_lapdev01/admin/log/clone/ApplyAppsTier_05301531.log
- 50% completed
ERROR while running Apply...
Fri May 30 17:37:39 2014
ERROR: Failed to execute /fs02/app/FDEV/apps/fs2/EBSapps/comn/clone/bin/adclone.pl
Solution :
1. Rename or delete the file:
$ mv /var/tmp/.ovdlock.tmp /var/tmp/.ovdlock.tmp.bak
2. Restart the clone command:
$ perl adcfgclone.pl appsTier
========================================
Issue :
When you run adop phase=prepare and found below errors :
adop phase=prepare failed with the following errors
[STATEMENT] Updating prepare_status=R for session_id : 19
[UNEXPECTED]Dictionary Corrupted:
[START 2014/07/07 07:22:18] Data Dictionary Curruption Details
APPS OE_CREDIT_CHECK_ORDER_PVT V_20140516_0452 APPS OE_CREDIT_CHECK_UTIL V_20140516_0452 P Status: 5
APPS OKL_PAY_CURE_REFUNDS_PVT_W V_20140516_0452 APPS OKL_PAY_CURE_REFUNDS_PVT V_20140516_0452 P Status: 5
APPS OKL_PAY_CURE_REFUNDS_PUB_W V_20140516_0452 APPS OKL_PAY_CURE_REFUNDS_PUB V_20140516_0452 P Status: 5
APPS OKL_PAY_CURE_REFUNDS_PUB_W V_20140516_0452 APPS OKL_PAY_CURE_REFUNDS_PVT V_20140516_0452 P Status: 5
...
APPS INV_OPM_LOT_MIGRATION V_20140516_0452 APPS INV_LOT_API_PUB V_20140516_0452 TS mismatch: 12-JUN-14 16:50:54 29-JUN-14 14:42:12
...
APPS INV_LOT_ATTR_PUB V_20140516_0452 APPS INV_LOT_API_PUB V_20140516_0452 TS mismatch: 12-JUN-14 16:50:54 29-JUN-14 14:42:12
APPS INV_LOT_ATTR_PUB V_20140516_0452 APPS MTL_LOT_UOM_CONV_PVT V_20140516_0452 P Status: 5
APPS CSD_SC_DOMAINS_PVT V_20140516_0452 APPS CSD_GEN_UTILITY_PVT V_20140516_0452 P Status: 5
Solution :
Reference: R12.2 Dictionary Corrupted While Running adop - "TS Mismatch" Error (Doc ID 1576086.1)
login to Database server :
1) sqlplus "/ as sysdba"
shutdown immediate
startup upgrade
2) @utlirp.sql
3) Bounce the database again and open it in normal mode.
From the same sqlplus session
shutdown immediate
startup
4) @?/rdbms/admin/utlrp.sql
5) re-run adop.
==========================================
Issue :
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_REGISTRY_SYS"
ORA-06512: at line 1
Solution:
How To Validate an Invalid SYS.DBMS_REGISTRY_SYS Package (Doc ID 438821.1)
SQL> alter trigger SYSTEM.DROPLOG_TRIGGER DISABLE;
========================================
Error :
[apploaph@oacmph scripts]$ sqlplus apps/rwnb1adr12
SQL*Plus: Release 10.1.0.5.0 - Production on Mon Jul 7 23:18:22 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-04045: errors during recompilation/revalidation of SYSTEM.EBS_LOGON
ORA-01031: insufficient privileges
Enter user-name:
Solution:
SQL> select trigger_name,owner,status from dba_triggers where trigger_name='EBS_LOGON';
TRIGGER_NAME OWNER STATUS
------------------------------ ------------------------------ --------
EBS_LOGON SYSTEM ENABLED
SQL> alter trigger SYSTEM.EBS_LOGON DISABLE;
Trigger altered.
================================================
Issue :
*** Log File = /oaph/oracle/oaphappl/fs_ne/EBSapps/log/adop/19/prepare_20140707_233754/OAPH_oacmph/TXK_SANITY_filesystemcheck_Mon_Jul_7_23_39_23_2014/txkADOPPreparePhaseSanityCheck_Mon_Jul_7_23_39_23_2014.log
[ERROR] Minimum file system space required 25 GB while you have 17.982421875 GB
[UNEXPECTED]Error occurred while executing "perl /oaph/oracle/oaphappl/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSanityCheck.pl -contextfile=/oaph/oracle/oaphappl/fs1/inst/apps/OAPH_oacmph/appl/admin/OAPH_oacmph.xml -patchcontextfile=/oaph/oracle/oaphappl/fs2/inst/apps/OAPH_oacmph/appl/admin/OAPH_oacmph.xml -promptmsg=hide -mode=update -console=off -sessionid=19 -timestamp=20140707_233754 -outdir=/oaph/oracle/oaphappl/fs_ne/EBSapps/log/adop/19/prepare_20140707_233754/OAPH_oacmph -action=filesystemcheck"
[UNEXPECTED]Error while runFSSanityValidateConfig sub-routine is called
[ERROR] Prepare phase completed with errors or warnings. Please check logfiles.
Log file: /oaph/oracle/oaphappl/fs_ne/EBSapps/log/adop/19/adop_20140707_233754.log
adop exiting with status = 1 (Fail)
You have new mail in /var/spool/mail/applo
Solution :
Make sure the free space is around 40 GB
=================================================
Issue :
Multiple context files exist in application side . you can view them through OAM.
because of this, you cannot add/modify customizations on your environment file.
Solution:
Remove the inconsistent row from FND_OAM_CONTEXT_FILES
STEPS:
1. Run the following script to clear out FND_OAM_CONTEXT_FILES of all entries. This will also
clear other tables like FND_NODES:
EXEC FND_CONC_CLONE.SETUP_CLEAN;
COMMIT;
EXIT;
2. On the database Node, run autoconfig:
$ORACLE_HOME/appsutil/scripts/<context_name>/adautocfg.sh
3. On All APPS nodes run autoconfig:
$ADMIN_SCRIPTS_HOME/adautocfg.sh
4. Retest the issue.
NOTE: Step 1 will clean out all information from some FND tables, so it is important that
autoconfig is run on ALL nodes in this environment. Must run on DB nodes first.
OR
1> Backup the table: create table applsys.fnd_oam_context_files_bak as select * from
applsys.fnd_oam_context_files;
2> Truncate the table: truncate table applsys.fnd_oam_context_files
3> Run Autoconfig on all nodes to reload the context file information to the database.
4> Re-Run Autoconfig to confirm that the issue does not replicate after the first run.
5> Check the FND_OAM_CONTEXT_FILES table to ensure the data was re-populated.
Create a Custom Parameter Fails With - Customization Is Not Allowed On Different Versions of Configuration Files [ID 762590.1]
CUSTOMIZATIONS NOT ALLOWED ON DIFFERENT VERSIONS OF CONFIGURATION FILES [ID 351969.1]
