adop fails after cloning
Locked
12
12
 
|
Hello Erman,
Instance information: Source instance hostname: erpprod.sunresorts.com target instance hostname: erppreprod.sunresorts.com Both have Oracle Linux 6.4, EBSR12.2.4, Oracle database 11gR2 I have cloned my source EBS instance and Oracle Database instance on target single node(erppreprod) Everything is working fine except I am having issue with patch(adop). When I run adop phase=apply apply_mode=downtime patches=PATCH_NUMBER, I get the warning below: Node registry is valid. Application services are down. [ERROR] ETCC not run in the database node erppreprod The EBS Technology Codelevel Checker needs to be run on the database node. It is available as Patch 17537119. Encountered the above errors when performing database validations. Resolve the above errors and restart adop. I did run the ETCC(checkDBpatch script) as RDBMS user. Still same issue. But what I noticed when I run adop -status, it gives me erpprod results about last online patching information I did on the source instance node(erpprod) Regards, Roshan |
Re: adop fails after cloning
Administrator
|
hi,
Run checkDBPatch script again and please send me the logfile located in programdir. checkDBpatch_$$.log , $$ should be your pid, just do an ls -lrt on the folder and send me the last log file. There could be a problem in one of the inserts that checkDB makes. That insert may load data for adop queries and as insert can not be done appropriately, adop can not see the checkdb script is executed. This is an assumption, but there are inserts like this in the checkdb script. InsCmd="INSERT INTO APPLSYS.TXK_TCC_RESULTS (tcc_version,bugfix_xml_version,node_name, database_name,component_name,component_version,component_home,check_date,check_result, check_message) values" tccversion=$progver tccexectime=$execdate tccresult=$TCCresult xmlversion=$xmlver server=`grep s_dbhost ${contextfile} | sed 's/^.*s_dbhost[^>.]*>[ ]*\([^<]*\)<.*/\1/g; s/ *$//g'` dbname=$DBNAME compver=$DB_VERSION compname="RDBMS" comphome=$ORACLE_HOME chkmesg1=`echo ${MissRlbkFix}| tr "\012" "," ` chkmesg=`echo ${chkmesg1}| sed 's/.$//'` So, I would start checking "TXK_TCC_RESULTS" table and the variables used in the insert above. server may be wrong or dbname may be wrong. You name it.. But control this table, compare it with your PROD database at least |
|
|
This post was updated on .
Hello,
the value from txk_tcc_results table is: select node_name from txk_tcc_results; erppreprod.sunresort.local how do I know the variable names? I opened checkDBpatch. How do I compare Regards, Roshan |
Re: adop fails after cloning
|
Administrator
|
Check the full table , the whole row. Do you seee anything inserted wrongly? 24 Oca 2016 09:51 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:
Hello, |
Re: adop fails after cloning
|
Administrator
|
Roshan,
Check this note: It will give you a clue. Error Occurred Performing Database Validations Applying Patch 19330775 (Doc ID 1993838.1) |
|
|
In reply to this post by ErmanArslansOracleBlog
there are other values like ERPDEV02, ERPPROD.these are other instances nodes.
I guess the erplivedb.sunresorts.local should be ERPPREPROD because when running the ETCC checkDBPatch it says ETCC not run on database node ERPPREPROD |
Re: adop fails after cloning
|
Administrator
|
I guess it is the problem.
I would delete them and update the table manually since it is a non critical non prod system. But it is your decision, the risk is yours :) But let's send me the contents of the table and let me take a look. |
|
|
hi,
select * from APPLSYS.TXK_TCC_RESULTS; TCC_VERSION BUGFIX_XML_VERSION -------------------- -------------------- NODE_NAME -------------------------------------------------------------------------------- DATABASE_NAME COMPONENT_NAME ---------------------------------------------------------------- -------------- COMPONENT_VERSION -------------------- COMPONENT_HOME -------------------------------------------------------------------------------- CHECK_DATE CHECK_RESULT ---------- ------------ CHECK_MESSAGE -------------------------------------------------------------------------------- 120.28 120.0.12020000.27 erpprodlivedb PROD RDBMS 11.2.0.3 /u01/oracle/PROD/db/11.2.0 29-DEC-15 MISSING 4189542,11071989,11896575,12646784,12764337,12849688,12913474,12950694,13036331, 13332439,13502183,13506110,13584130,13780816,13786142,13839641,13945708,14162791 ,14163397,14255128,14587310,14751895,15982436,16024441,16101465,16299727,1635975 TCC_VERSION BUGFIX_XML_VERSION -------------------- -------------------- NODE_NAME -------------------------------------------------------------------------------- DATABASE_NAME COMPONENT_NAME ---------------------------------------------------------------- -------------- COMPONENT_VERSION -------------------- COMPONENT_HOME -------------------------------------------------------------------------------- CHECK_DATE CHECK_RESULT ---------- ------------ CHECK_MESSAGE -------------------------------------------------------------------------------- 1,16505333,16710753,16864048,17050888,17174582,17250794,17401353,17478145,176141 34,17781991,17883081,18244962,18282562,18331812,18331850,18436307,18440047,18674 024,18730542,18893947,18964939,19487147,19879144,20245930,20825533,20949558 120.23 120.0.12020000.21 erpuat UAT RDBMS 11.2.0.3 /u01/oracle/DEV/db/11.2.0 TCC_VERSION BUGFIX_XML_VERSION -------------------- -------------------- NODE_NAME -------------------------------------------------------------------------------- DATABASE_NAME COMPONENT_NAME ---------------------------------------------------------------- -------------- COMPONENT_VERSION -------------------- COMPONENT_HOME -------------------------------------------------------------------------------- CHECK_DATE CHECK_RESULT ---------- ------------ CHECK_MESSAGE -------------------------------------------------------------------------------- 24-APR-15 MISSING 18828868,19791273,19949371,20294666 120.28 120.0.12020000.27 erppreprod.sunresort.local PREPROD RDBMS 11.2.0.3 /u01/oracle/PREPROD/db/11.2.0 23-JAN-16 MISSING TCC_VERSION BUGFIX_XML_VERSION -------------------- -------------------- NODE_NAME -------------------------------------------------------------------------------- DATABASE_NAME COMPONENT_NAME ---------------------------------------------------------------- -------------- COMPONENT_VERSION -------------------- COMPONENT_HOME -------------------------------------------------------------------------------- CHECK_DATE CHECK_RESULT ---------- ------------ CHECK_MESSAGE -------------------------------------------------------------------------------- 4189542,11071989,11896575,12646784,12764337,12849688,12913474,12950694,13036331, 13332439,13502183,13506110,13584130,13780816,13786142,13839641,13945708,14162791 ,14163397,14255128,14367567,14587310,14751895,15955538,15982436,16024441,1607560 9,16101465,16288550,16299727,16359751,16505333,16710753,16864048,17050888,171745 82,17250794,17401353,17478145,17614134,17781991,17883081,17901041,18244962,18282 562,18331812,18331850,18436307,18440047,18607546,18674024,18730542,18828868,1889 3947,18964939,18966843,19487147,19791273,19835133,19879144,19949371,20245930,202 94666,20476776,20825533,20949558 TCC_VERSION BUGFIX_XML_VERSION -------------------- -------------------- NODE_NAME -------------------------------------------------------------------------------- DATABASE_NAME COMPONENT_NAME ---------------------------------------------------------------- -------------- COMPONENT_VERSION -------------------- COMPONENT_HOME -------------------------------------------------------------------------------- CHECK_DATE CHECK_RESULT ---------- ------------ CHECK_MESSAGE -------------------------------------------------------------------------------- 120.23 120.18 erpdev02 DEV RDBMS 11.2.0.3 /u01/oracle/DEV/db/11.2.0 23-MAR-15 OK 4 rows selected. how do I proceed? truncate the table? |
Re: adop fails after cloning
|
Administrator
|
I cant see it well , it s not formatted. Lets, Take a backup of that table using CTAS , then truncate table , rerun checkdb and retry adop. 24 Oca 2016 14:46 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:
hi, |
|
|
Do you know change the format it? I backed up and truncated the table. then i changed the node name from erppreprod.sunresorts.local to ERPPREPROD and now i am able to run adop. Thanks.
Do you know why it keeps the node name as erppreprod.sunresorts.local? |
Re: adop fails after cloning
|
Administrator
|
Hi Roshan,
I m glad that the issue got resolved. As for your questions: 1)Node name is coming from the output of the command: grep s_dbhost ${contextfile} | sed 's/^.*s_dbhost[^>.]*>[ ]*\([^<]*\)<.*/\1/g; s/ *$//g' So it is derived from the contextfile. 2)For formatting sqlplus output, please see: https://docs.oracle.com/database/121/SQPUG/ch_six.htm#SQPUG016 SQL*Plus® User's Guide and Reference: Formatting SQL*Plus Reports |
|
|
hi Erman,
i face a similar issue, when i query select node_name from txk_tcc_results; it shows me the production nodes information. after cloning i ran a conc.clean setup and when i query select node_name from fnd_nodes it gives me dev server name, but when i query select node_name from txk_tcc_results; it gives me production instance server names. Please help me to resolve this. thanks |
Re: adop fails after cloning
|
Administrator
|
This post was updated on .
Then, you can consider applying the solution provided above.
|
|
|
This post was updated on .
Hi Erman,
Thank you so much..i ran checkDBpatch.sh and it successfully completed. now the dev server name scchoddbap is showing when i query it, but the problem is the server name scchoddbap is appearing twice. select node_name from txk_tcc_results; NODE_NAME -------------------------------------------------------------------------------- scchopdb2 scchoddbap scchopdb1 scchoddbap SCCHOPDB1 SCCHOPDB2 after this when i tried to run adop phase=fs_clone =========================== START OF VALIDATION REPORT ==================== Validation Results for Node: scchoddbap --------------------------------------- [ERROR]: At least one Oracle inventory check has failed. [WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details. Some validations failed, please check /p06/appleam/fs_ne/EBSapps/log/adop/29/fs_clone_20160203_191509/EAM_scchoddbap/ADOPValidations_Wed_Feb_3_19_15_41_2016.log =========================== END OF VALIDATION REPORT ====================== [UNEXPECTED]Error occurred while executing "perl /p06/appleam/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/p06/appleam/fs2/inst/fs2/inst/apps/EAM_scchoddbap/appl/admin/EAM_scchoddbap.xml -patchctxfile=/p06/appleam/fs2/inst/fs1/inst/apps/EAM_scchoddbap/appl/admin/EAM_scchoddbap.xml -phase=fs_clone -logloc=/p06/appleam/fs_ne/EBSapps/log/adop/29/fs_clone_20160203_191509/EAM_scchoddbap -promptmsg=hide" [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on scchoddbap Log file: /p06/appleam/fs_ne/EBSapps/log/adop/29/adop_20160203_191509.log [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 = 1 (Fail) log file messages ERROR: /p06/appleam/fs2/FMW_Home/Oracle_EBS-app1 is not registered in the invent ory Corrective Action: Provide the location of a valid inventory file. If you believ e the inventory is valid, you may want to attach the /p06/appleam/fs2/FMW_Home/O racle_EBS-app1. cmd : java weblogic.WLST /p06/appleam/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/t xkValidateDomainInRC.py --adminuser=weblogic --verify=domainEditModeEnabled --ad minurl=t3://scchoddbap.mydomain.com.sa:7041>/p06/appleam/fs2/inst/fs2/inst/ap ps/EAM_scchoddbap/logs/appl/rgf/TXK/txkValidateDomainInRCOut.txt Domain is not in edit mode. |
Re: adop fails after cloning
|
Administrator
|
What is the output of adopscanlog -latest=yes command.
Copy and paste it here. |
|
|
adopscanlog -latest=yes
Scanning /p06/appleam/fs_ne/EBSapps/log/adop/29/ directory ... /p06/appleam/fs_ne/EBSapps/log/adop/29/adop_20160203_191509.log: ---------------------------------------------------------------- Lines #(56-60): [EVENT] Calling: /p06/appleam/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl [STATEMENT] Output directory: /p06/appleam/fs_ne/EBSapps/log/adop/29/fs_clone_20160203_191509/EAM_scchoddbap [UNEXPECTED]Error occurred while executing "perl /p06/appleam/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/p06/appleam/fs2/inst/fs2/inst/apps/EAM_scchoddbap/appl/admin/EAM_scchoddbap.xml -patchctxfile=/p06/appleam/fs2/inst/fs1/inst/apps/EAM_scchoddbap/appl/admin/EAM_scchoddbap.xml -phase=fs_clone -logloc=/p06/appleam/fs_ne/EBSapps/log/adop/29/fs_clone_20160203_191509/EAM_scchoddbap -promptmsg=hide" [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on scchoddbap [PROCEDURE] [START 2016/02/03 19:17:36] Unlocking sessions table Lines #(57-61): [STATEMENT] Output directory: /p06/appleam/fs_ne/EBSapps/log/adop/29/fs_clone_20160203_191509/EAM_scchoddbap [UNEXPECTED]Error occurred while executing "perl /p06/appleam/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl -contextfile=/p06/appleam/fs2/inst/fs2/inst/apps/EAM_scchoddbap/appl/admin/EAM_scchoddbap.xml -patchctxfile=/p06/appleam/fs2/inst/fs1/inst/apps/EAM_scchoddbap/appl/admin/EAM_scchoddbap.xml -phase=fs_clone -logloc=/p06/appleam/fs_ne/EBSapps/log/adop/29/fs_clone_20160203_191509/EAM_scchoddbap -promptmsg=hide" [UNEXPECTED]Error 1 occurred while Executing txkADOPValidation script on scchoddbap [PROCEDURE] [START 2016/02/03 19:17:36] Unlocking sessions table [STATEMENT] Unlocking ad_adop_sessions table for scchoddbap with wait interval of 60 seconds and number of tries 2 /p06/appleam/fs_ne/EBSapps/log/adop/29/fs_clone_20160203_191509/EAM_scchoddbap/txkADOPValidations.log: ------------------------------------------------------------------------------------------------------ Lines #(14-18): ValidateInventory: [ERROR]: At least one Oracle inventory check has failed. ValidateAtName: /p06/appleam/fs_ne/EBSapps/log/adop/29/fs_clone_20160203_191509/EAM_scchoddbap/ADOPValidations_Wed_Feb_3_19_15_41_2016.log: --------------------------------------------------------------------------------------------------------------------------- Lines #(191-195): ==================================== ERROR: /p06/appleam/fs2/FMW_Home/Oracle_EBS-app1 is not registered in the inventory Corrective Action: Provide the location of a valid inventory file. If you believe the inventory is valid, you may want to attach the /p06/appleam/fs2/FMW_Home/Oracle_EBS-app1. |
Re: adop fails after cloning
|
Administrator
|
It seems there is a problem with your inventory.
You need to check your inventory to be sure. Also Check this one: E-Business Suite - After Upgrade To 12.2.3 Or 12.2.4 Applying Fs_clone Failed When Checking Oracle Inventory With [ERROR]: At least one Oracle inventory check has failed. (Doc ID 2024269.1) You may consider adding your oracle homes to the inventory, if the inventory is empty or does not contain the oracle home/homes reported by the adop utility. Check this note for this: Script to Diagnose adop and Other AD-TXK Issues in Oracle E-Business Suite Release 12.2 [ Patch 19045166:R12.AD.C ] (Doc ID 1901242.1) If it wont solve your issue; follow the note below and send me the output: Script to Diagnose adop and Other AD-TXK Issues in Oracle E-Business Suite Release 12.2 [ Patch 19045166:R12.AD.C ] (Doc ID 1901242.1) |
|
|
Hi Erman,
Thanks so much for your prompt responses. i have multiple cloned instances running on dev server. i generally # the old ones and it works fine, the inventory location is update in oraInst.loc and how to check if the inventory has not registered my oracle home and if not how to attach it. Thanks again. |
Re: adop fails after cloning
|
Administrator
|
open the file : <directory_specified_by_oraInst.loc/ContentsXML
and review it as it shown in document "R12.2 How To Re-attach Oracle Homes To The Central Inventory (Doc ID 1586607.1)" Please read it carefully. |
|
|
Hi,
currently my run base is fs2. and i checked inventory.xml, it shows below values. it shows fs1 location. more inventory.xml <?xml version="1.0" standalone="yes" ?> <INVENTORY> <COMPOSITEHOME_LIST> </COMPOSITEHOME_LIST> <VERSION_INFO> <SAVED_WITH>10.1.0.6.0</SAVED_WITH> <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER> </VERSION_INFO> <HOME_LIST> <HOME NAME="OH279635917" LOC="/p06/appleam/fs1/FMW_Home/oracle_common" TYPE="O" IDX="1"> <REFHOMELIST> <REFHOME LOC="/p06/appleam/fs1/FMW_Home/webtier"/> </REFHOMELIST> </HOME> <HOME NAME="OH1521542365" LOC="/p06/appleam/fs1/FMW_Home/webtier" TYPE="O" IDX=" 2"> <DEPHOMELIST> <DEPHOME LOC="/p06/appleam/fs1/FMW_Home/oracle_common"/> </DEPHOMELIST> </HOME> <HOME NAME="OH1975731601" LOC="/p06/appleam/fs1/FMW_Home/Oracle_EBS-app1" TYPE=" O" IDX="3"/> <HOME NAME="EAM_TOOLS__p06_appleam_fs1_EBSapps_10_1_2" LOC="/p06/appleam/fs1/EBS apps/10.1.2" TYPE="O" IDX="4"/> </HOME_LIST> </INVENTORY> |
«
Return to EBS 12.2
|
1 view|%1 views
| Free forum by Nabble | Edit this page |