Re: adop fails after cloning
Posted by Roshan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/adop-fails-after-cloning-tp488p495.html
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?