postfixups_hongkong.log

2021-03-09 03:40:41.322 INFO Starting log for hongkong - Utilities.createLogger 
2021-03-09 03:40:42.398 INFO Starting - timestamp_mismatch.fixUpCode 
2021-03-09 03:40:42.405 INFO End - timestamp_mismatch.fixUpCode 
2021-03-09 03:40:42.406 INFO Running fixup [TIMESTAMP_MISMATCH][hongkong][PLSQL][DECLARE
v_name VARCHAR2(128) := '';
v_mismatch VARCHAR2(300) := '';
v_statement varchar2(400) := '';
CURSOR c_object_fix
IS
select do.name, to_char(p_timestamp,'DD-MON-YYYY HH24:MI:SS') || ' ->P_Timestamp' || ' '||to_char(po.stime ,'DD-MON-YYYY 
HH24:MI:SS') ||' -->STIME'|| decode(sign(po.stime-p_timestamp),0,'SAME','*DIFFER*') ||';'
from sys.obj$ do, sys.dependency$ d, sys.obj$ po
where P_OBJ#=po.obj#(+)
and D_OBJ#=do.obj#
and do.status=1 /*dependent is valid*/
and po.status=1 /*parent is valid*/
and po.stime!=p_timestamp /*parent timestamp not match*/;
BEGIN
OPEN c_object_fix;
LOOP
FETCH c_object_fix INTO v_name, v_mismatch;
EXIT WHEN c_object_fix%NOTFOUND;
BEGIN
v_statement := 'alter public synonym "' || v_name || '" compile';
DBMS_OUTPUT.PUT_LINE('OBJECT WITH MISMATCH FIX: ' || v_name || ' Mismatch: ' || v_mismatch);
DBMS_OUTPUT.PUT_LINE('Statement: ' || v_statement);
EXECUTE IMMEDIATE v_statement;
EXCEPTION WHEN OTHERS then
DBMS_OUTPUT.PUT_LINE('Unsupported synchronization for ' || v_name);
END;
END LOOP;
CLOSE c_object_fix; 
END;
/
] - FixUpTrigger.executeFixUp 
2021-03-09 03:40:42.406 INFO Starting - timestamp_mismatch.fixUpCode 
2021-03-09 03:40:42.408 INFO End - timestamp_mismatch.fixUpCode 
2021-03-09 03:40:42.409 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:40:42.409 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:40:42.409 INFO [(SQLPATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_SID=hongkong), (ORACLE_UNQNAME=hongkong), (ORACLE_PATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_BASE=/u01/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess 
2021-03-09 03:40:42.409 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:40:42.410 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:40:42.410 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:40:42.410 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:40:42.421 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:40:42.421 INFO Executing SQL [DECLARE
v_name VARCHAR2(128) := '';
v_mismatch VARCHAR2(300) := '';
v_statement varchar2(400) := '';
CURSOR c_object_fix
IS
select do.name, to_char(p_timestamp,'DD-MON-YYYY HH24:MI:SS') || ' ->P_Timestamp' || ' '||to_char(po.stime ,'DD-MON-YYYY 
HH24:MI:SS') ||' -->STIME'|| decode(sign(po.stime-p_timestamp),0,'SAME','*DIFFER*') ||';'
from sys.obj$ do, sys.dependency$ d, sys.obj$ po
where P_OBJ#=po.obj#(+)
and D_OBJ#=do.obj#
and do.status=1 /*dependent is valid*/
and po.status=1 /*parent is valid*/
and po.stime!=p_timestamp /*parent timestamp not match*/;
BEGIN
OPEN c_object_fix;
LOOP
FETCH c_object_fix INTO v_name, v_mismatch;
EXIT WHEN c_object_fix%NOTFOUND;
BEGIN
v_statement := 'alter public synonym "' || v_name || '" compile';
DBMS_OUTPUT.PUT_LINE('OBJECT WITH MISMATCH FIX: ' || v_name || ' Mismatch: ' || v_mismatch);
DBMS_OUTPUT.PUT_LINE('Statement: ' || v_statement);
EXECUTE IMMEDIATE v_statement;
EXCEPTION WHEN OTHERS then
DBMS_OUTPUT.PUT_LINE('Unsupported synchronization for ' || v_name);
END;
END LOOP;
CLOSE c_object_fix; 
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:40:43.445 INFO # TIMESTAMP_MISMATCH
OBJECT WITH MISMATCH FIX: oracle/AWAction/AWAction Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWAction/AWAction" compile
OBJECT WITH MISMATCH FIX: oracle/AWAction/Alter Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWAction/Alter" compile
OBJECT WITH MISMATCH FIX: oracle/AWAction/Attach Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWAction/Attach" compile
OBJECT WITH MISMATCH FIX: oracle/AWAction/BuildDatabase Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWAction/BuildDatabase" compile
OBJECT WITH MISMATCH FIX: oracle/AWAction/Commit Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWAction/Commit" compile
OBJECT WITH MISMATCH FIX: oracle/AWAction/Create Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWAction/Create" compile
OBJECT WITH MISMATCH FIX: oracle/AWAction/Delete Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWAction/Delete" compile
OBJECT WITH MISMATCH FIX: oracle/AWAction/Detach Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWAction/Detach" compile
OBJECT WITH MISMATCH FIX: oracle/AWAction/Driver Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWAction/Driver" compile
OBJECT WITH MISMATCH FIX: oracle/AWAction/Interaction Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWAction/Interaction" compile
OBJECT WITH MISMATCH FIX: oracle/AWAction/JDBCDriver Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWAction/JDBCDriver" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AW Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AW" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AWConnection Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AWConnection" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AWHandlerBase Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AWHandlerBase" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AWObject Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AWObject" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AWParser Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AWParser" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Aggregation Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Aggregation" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AggregationArgument Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AggregationArgument" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AggregationDefinition Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AggregationDefinition" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AggregationHierarchySpecification Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AggregationHierarchySpecification" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AggregationOperator Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AggregationOperator" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AggregationSolve Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AggregationSolve" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Allocation Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Allocation" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AllocationArgument Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AllocationArgument" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AllocationDefinition Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AllocationDefinition" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AllocationHierarchySpecification Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AllocationHierarchySpecification" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AllocationOperator Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AllocationOperator" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AllocationSolve Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AllocationSolve" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Attribute Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Attribute" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AttributeProjection Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AttributeProjection" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/AttributeSourceExpression Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/AttributeSourceExpression" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/BaseObject Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/BaseObject" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/BaseOperator Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/BaseOperator" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/CalculatedMember Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/CalculatedMember" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/CalculatedMemberRef Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/CalculatedMemberRef" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/CalculationSpecification Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/CalculationSpecification" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/ConfigurationParameters Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/ConfigurationParameters" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Cube Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Cube" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/CubeDimRef Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/CubeDimRef" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/CubeDimensionSourceExpression Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/CubeDimensionSourceExpression" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/CubeMapGroup Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/CubeMapGroup" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/DerivedMeasure Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/DerivedMeasure" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Dimension Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Dimension" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/DimensionKeySourceExpression Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/DimensionKeySourceExpression" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/DimensionMapGroup Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/DimensionMapGroup" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/DimensionMemberExpression Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/DimensionMemberExpression" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/DimensionMemberSelection Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/DimensionMemberSelection" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/ExtendedProperty Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/ExtendedProperty" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/ExternalSourceExpression Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/ExternalSourceExpression" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/ForeCastKeyWord Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/ForeCastKeyWord" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/ForecastArgument Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/ForecastArgument" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/ForecastArgumentValue Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/ForecastArgumentValue" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/ForecastDefinition Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:01 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/ForecastDefinition" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/ForecastSolve Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/ForecastSolve" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/HierarchicalParentSourceExpression Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/HierarchicalParentSourceExpression" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Hierarchy Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Hierarchy" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/HierarchyLevelAssociation Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/HierarchyLevelAssociation" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Index Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Index" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Level Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Level" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/MappingGroup Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/MappingGroup" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Measure Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Measure" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/MeasureFolder Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/MeasureFolder" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/MeasureSourceExpression Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/MeasureSourceExpression" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/MemberSelection Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/MemberSelection" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Model Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Model" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/ModelDimRef Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/ModelDimRef" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/ModelRef Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/ModelRef" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/OlapMeasure Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/OlapMeasure" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/OlapMeasureInput Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/OlapMeasureInput" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Operator Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Operator" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/OperatorType Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/OperatorType" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Parameter Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Parameter" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/PermanentCalculatedMember Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/PermanentCalculatedMember" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/PreComputeClause Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/PreComputeClause" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/RestrictedSourceExpression Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/RestrictedSourceExpression" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/SessionCalculatedMember Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/SessionCalculatedMember" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/Solve Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/Solve" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/SolveDefDimRef Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/SolveDefDimRef" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/SolveDefinition Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/SolveDefinition" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/SolveGroup Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/SolveGroup" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/SourceColumn Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/SourceColumn" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/SparseDefinition Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/SparseDefinition" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/UserDefinedArgument Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/UserDefinedArgument" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/UserDefinedOperator Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/UserDefinedOperator" compile
OBJECT WITH MISMATCH FIX: oracle/AWXML/WhereClause Mismatch: 26-JAN-2017 15:12:28 ->P_Timestamp 09-MAR-2021
03:26:02 -->STIME*DIFFER*;
Statement: alter public synonym "oracle/AWXML/WhereClause" compile - Check.runFix 
2021-03-09 03:40:43.446 INFO Finished fixup [TIMESTAMP_MISMATCH][hongkong][SUCCESSFUL] - FixUpTrigger.executeFixUp 
2021-03-09 03:40:43.476 INFO Running fixup [POST_DICTIONARY][hongkong][PLSQL][DECLARE
BEGIN
SYS.DBMS_STATS.GATHER_INDEX_STATS('SYS', 'I_OBJ#');
SYS.DBMS_STATS.GATHER_DICTIONARY_STATS;
END;
/
] - FixUpTrigger.executeFixUp 
2021-03-09 03:40:43.487 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:40:43.488 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:40:43.488 INFO [(SQLPATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_SID=hongkong), (ORACLE_UNQNAME=hongkong), (ORACLE_PATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_BASE=/u01/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess 
2021-03-09 03:40:43.488 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:40:43.488 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:40:43.488 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:40:43.489 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:40:43.510 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:40:43.510 INFO Executing SQL [DECLARE
BEGIN
SYS.DBMS_STATS.GATHER_INDEX_STATS('SYS', 'I_OBJ#');
SYS.DBMS_STATS.GATHER_DICTIONARY_STATS;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:41:48.809 INFO # POST_DICTIONARY - Check.runFix 
2021-03-09 03:41:48.810 INFO Finished fixup [POST_DICTIONARY][hongkong][SUCCESSFUL] - FixUpTrigger.executeFixUp 
2021-03-09 03:41:48.820 INFO Running fixup [OLD_TIME_ZONES_EXIST][hongkong][JAVA][Java based fixup] - FixUpTrigger.executeFixUp 
2021-03-09 03:41:48.820 INFO Starting - old_time_zones_exist.populateScriptsToExecute 
2021-03-09 03:41:48.821 INFO All the scripts were found, using the scripts from /u01/app/oracle/product/19.0.0/dbhome_1 - old_time_zones_exist.populateScriptsToExecute 
2021-03-09 03:41:48.821 INFO Adding script to list [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessstart.sql] - old_time_zones_exist.populateScriptsToExecute 
2021-03-09 03:41:48.821 INFO Adding script to list [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_check.sql] - old_time_zones_exist.populateScriptsToExecute 
2021-03-09 03:41:48.822 INFO Adding script to list [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_apply.sql] - old_time_zones_exist.populateScriptsToExecute 
2021-03-09 03:41:48.822 INFO Adding script to list [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessend.sql] - old_time_zones_exist.populateScriptsToExecute 
2021-03-09 03:41:48.822 INFO End - old_time_zones_exist.populateScriptsToExecute 
2021-03-09 03:41:48.837 INFO TimeZone upgrade log files will be located under /home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong/temp/hongkong/TimeZone - old_time_zones_exist.fixUpCode 
2021-03-09 03:41:48.838 INFO Starting - old_time_zones_exist.NonCDBTimeZoneUpg 
2021-03-09 03:41:48.860 INFO Processing hongkong - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:41:48.861 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:41:48.861 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:41:48.862 INFO [(SQLPATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_SID=hongkong), (ORACLE_UNQNAME=hongkong), (ORACLE_PATH=/home/oracle/u03/app/oracle/autoupgrade/hongkong/hongkong:/home/oracle/u03/app/oracle/autoupgrade/cfgtoollogs/upgrade/auto/sql), (ORACLE_BASE=/u01/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess 
2021-03-09 03:41:48.862 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:41:48.863 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:41:48.863 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:41:48.863 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:41:48.874 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:41:48.877 INFO Executing [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessstart.sql][hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:41:48.877 INFO Executing SQL [@/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessstart.sql
] in [hongkong, container:hongkong] - ExecuteSql.sendSqlCmdToSqlPlus 
2021-03-09 03:41:49.878 INFO Complete [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessstart.sql][hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:41:49.878 INFO Looking for errors in log file after /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessstart.sql execution on [hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:41:49.878 INFO Executing [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_check.sql][hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:41:49.878 INFO Executing SQL [@/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_check.sql
] in [hongkong, container:hongkong] - ExecuteSql.sendSqlCmdToSqlPlus 
2021-03-09 03:41:52.880 INFO Complete [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_check.sql][hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:41:52.880 INFO Looking for errors in log file after /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_check.sql execution on [hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:41:52.881 INFO Executing [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_apply.sql][hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:41:52.881 INFO Executing SQL [@/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_apply.sql
] in [hongkong, container:hongkong] - ExecuteSql.sendSqlCmdToSqlPlus 
2021-03-09 03:43:46.087 INFO Complete [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_apply.sql][hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:43:46.088 INFO Looking for errors in log file after /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/utltz_upg_apply.sql execution on [hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:43:46.088 INFO Executing [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessend.sql][hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:43:46.088 INFO Executing SQL [@/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessend.sql
] in [hongkong, container:hongkong] - ExecuteSql.sendSqlCmdToSqlPlus 
2021-03-09 03:43:48.593 INFO Complete [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessend.sql][hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:43:48.593 INFO Looking for errors in log file after /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/sqlsessend.sql execution on [hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:43:48.593 INFO Closing sqlplus with exitValue 0 [hongkong] - old_time_zones_exist$UpgTarget.call 
2021-03-09 03:43:48.594 INFO The Timezone upgrade has finished for [hongkong] - old_time_zones_exist.NonCDBTimeZoneUpg 
2021-03-09 03:43:48.594 INFO Finished - old_time_zones_exist.NonCDBTimeZoneUpg 
2021-03-09 03:43:48.594 INFO Finished fixup [OLD_TIME_ZONES_EXIST][hongkong][SUCCESSFUL] - FixUpTrigger.executeFixUp
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8
Like this:

One thought on “postfixups_hongkong.log”
