2021-03-09 03:44:23.736 INFO Starting log for hongkong - Utilities.createLogger 
2021-03-09 03:44:24.791 INFO Running check AWR_DBIDS_PRESENT [hongkong] - CheckTrigger.call 
2021-03-09 03:44:24.795 INFO Running check CREATE_WINDOWS_SERVICE [hongkong] - CheckTrigger.call 
2021-03-09 03:44:24.795 INFO Finished check [CREATE_WINDOWS_SERVICE][hongkong][PASSED] - CheckTrigger.call 
2021-03-09 03:44:24.795 INFO Running check DEPEND_USR_TABLES [hongkong] - CheckTrigger.call 
2021-03-09 03:44:24.810 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:24.810 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:24.811 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:44:24.811 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:24.811 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:24.811 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:24.811 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:24.823 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:24.823 INFO Executing SQL [DECLARE
rows NUMBER;
BEGIN
EXECUTE IMMEDIATE 'SELECT count(1) FROM sys.wrm$_wr_control
WHERE dbid != (SELECT dbid FROM sys.v$database)' INTO rows;
IF rows = 0 THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
DBMS_OUTPUT.PUT_LINE('FAILURE');
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:44:24.824 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:24.824 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:24.824 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:44:24.824 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:24.824 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:24.824 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:24.824 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:24.850 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:24.850 INFO Executing SQL [DECLARE
t_null varchar2(1);
BEGIN
-- Look for any user tables dependent on Oracle-Maintained types.
-- If there are any, then IF the -T option is used to set user tablespaces to
-- READ ONLY during the upgrade, then a post-upgrade action to run 
-- utluptabdata.sql is required.

IF sys.dbms_registry.release_version = '19.0.0.0.0' THEN
-- Perform post-upgrade check:
-- If -T has NOT been used, then all tables should be already upgraded.
-- If -T was used, and utluptabdata.sql was run successfully, then all
-- tables should already be upgraded. 
-- If -T was used but utluptabdata.sql was NOT run to upgrade all of the
-- remaining tables, then this check will fail post upgrade.
WITH DEPOBJ AS
(SELECT DO.OBJ#, D.D_OBJ#,D.P_OBJ# FROM SYS.DEPENDENCY$ D, SYS.OBJ$ DO
WHERE DO.OBJ# = D.D_OBJ#
AND DO.TYPE# IN (2,13)
)
SELECT NULL into t_null
FROM sys.obj$ o, sys.user$ u, sys.col$ c, sys.coltype$ t
WHERE bitand(t.flags,256) = 256 AND -- UPGRADED = NO
t.intcol# = c.intcol# AND
t.col# = c.col# AND
t.obj# = c.obj# AND
c.obj# = o.obj# AND
o.owner# = u.user# AND
o.owner# NOT IN -- Not an Oracle-Supplied user
(SELECT user# FROM sys.user$
WHERE type#=1 AND bitand(spare1, 256)= 256) AND
o.obj# IN -- A dependent of an Oracle-Maintained type
(SELECT d.d_obj# 
FROM DEPOBJ d
START WITH d.p_obj# IN -- Oracle-Maintained types
(SELECT obj# from sys.obj$ 
WHERE type#=13 AND 
owner# IN -- an Oracle-Supplied user 
(SELECT user# FROM sys.user$
WHERE type#=1 AND 
bitand(spare1, 256)= 256)) 
CONNECT BY NOCYCLE PRIOR d.d_obj# = d.p_obj#);
-- Found a dependent table
DBMS_OUTPUT.PUT_LINE('19.0.0.0.0');
RETURN;

ELSE -- Perform preupgrade check
WITH DEPOBJ AS
(SELECT DO.OBJ#, D.D_OBJ#,D.P_OBJ# FROM SYS.DEPENDENCY$ D, SYS.OBJ$ DO
WHERE DO.OBJ# = D.D_OBJ#
AND DO.TYPE# IN (2,13)
)
SELECT NULL into t_null
FROM sys.obj$
WHERE type# = 2
AND owner# NOT IN 
(SELECT schema# FROM sys.registry$ WHERE namespace = 'SERVER'
UNION
SELECT schema# FROM sys.registry$schemas WHERE namespace = 'SERVER'
UNION
SELECT user# FROM user$ WHERE type#=1 AND bitand(spare1,256)=256)
AND obj# IN
(SELECT d.obj# FROM DEPOBJ d
START WITH d.p_obj# IN -- Oracle-Maintained types
(SELECT obj# from sys.obj$ 
WHERE type#=13 
AND owner# IN
(SELECT schema# FROM sys.registry$ 
WHERE namespace = 'SERVER'
UNION
SELECT schema# FROM sys.registry$schemas 
WHERE namespace = 'SERVER'
UNION
SELECT user# FROM sys.user$
WHERE type#=1 AND bitand(spare1,256)=256))
CONNECT BY NOCYCLE PRIOR d.d_obj# = d.p_obj#)
AND rownum <=1;
-- Found a dependent table
DBMS_OUTPUT.PUT_LINE('19.0.0.0.0');
RETURN; 
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN 
-- No rows found, so no dependent tables
DBMS_OUTPUT.PUT_LINE('SUCCESS');
RETURN;
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('19.0.0.0.0');
RETURN; 
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:44:25.854 INFO Finished check [AWR_DBIDS_PRESENT][hongkong][PASSED] - CheckTrigger.call 
2021-03-09 03:44:25.856 INFO Running check DV_SIMULATION [hongkong] - CheckTrigger.call 
2021-03-09 03:44:25.861 INFO Finished check [DEPEND_USR_TABLES][hongkong][PASSED] - CheckTrigger.call 
2021-03-09 03:44:25.862 INFO Running check POST_DICTIONARY [hongkong] - CheckTrigger.call 
2021-03-09 03:44:25.864 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:25.865 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:25.865 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:44:25.865 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:25.865 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:25.865 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:25.865 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:25.865 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:25.865 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:25.865 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:44:25.865 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:25.865 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:25.865 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:25.865 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:25.888 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:25.889 INFO Executing SQL [DECLARE
BEGIN
IF ((sys.dbms_registry.is_loaded('DV') IS NOT NULL) AND
(sys.dbms_registry.get_progress_value('DV', 'SIMULATION LOGS') =
'The existing simulation logs have been moved to dvsys.old_simulation_log$'))
THEN
DBMS_OUTPUT.PUT_LINE('FAILURE');
ELSE
DBMS_OUTPUT.PUT_LINE('SUCCESS');
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:44:25.889 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:25.889 INFO Executing SQL [DECLARE
dictionary_stats_recent NUMBER;
correct_version boolean := TRUE;
BEGIN
-- check produced for hongkong
IF FALSE THEN
correct_version := FALSE; 
END IF;

select COUNT(1) INTO dictionary_stats_recent from sys.dual where exists(
select distinct operation 
from SYS.DBA_OPTSTAT_OPERATIONS 
where operation ='gather_dictionary_stats' 
and start_time > (select max(OPTIME) from sys.registry$log
where cid ='UPGRD_END'));

IF (dictionary_stats_recent = 1 and correct_version)
THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
-- this CHECK always fails... it always produces the recommendations.
DBMS_OUTPUT.PUT_LINE('FAILURE');
END IF; 
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:44:26.914 INFO Finished check [POST_DICTIONARY][hongkong][PASSED] - CheckTrigger.call 
2021-03-09 03:44:26.914 INFO Running check POST_FIXED_OBJECTS [hongkong] - CheckTrigger.call 
2021-03-09 03:44:26.915 INFO Finished check [DV_SIMULATION][hongkong][PASSED] - CheckTrigger.call 
2021-03-09 03:44:26.915 INFO Running check POST_JVM_MITIGAT_PATCH [hongkong] - CheckTrigger.call 
2021-03-09 03:44:26.915 INFO Finished check [POST_JVM_MITIGAT_PATCH][hongkong][PASSED] - CheckTrigger.call 
2021-03-09 03:44:26.915 INFO Running check OLD_TIME_ZONES_EXIST [hongkong] - CheckTrigger.call 
2021-03-09 03:44:26.916 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:26.916 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:26.916 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:44:26.916 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:26.916 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:26.916 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:26.916 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:26.916 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:26.916 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:26.916 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:44:26.916 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:26.917 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:26.917 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:26.917 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:26.934 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:26.934 INFO Executing SQL [DECLARE
doc_name VARCHAR2(80) := '';
BEGIN
-- this CHECK always fails... it always produces the recommendations.

doc_name := '19.0.0.0';

IF ('19.0' = '11.2') THEN
doc_name := doc_name || ' Oracle Database Performance Tuning Guide';
ELSIF ('19.0' = '12.1' OR '19.0.0.0' = '12.2.0.1') THEN
doc_name := doc_name || ' Oracle Database SQL Tuning Guide';
ELSE
doc_name := doc_name || ' Oracle Database Upgrade Guide';
END IF;
DBMS_OUTPUT.PUT_LINE(doc_name);
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:44:26.934 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:26.934 INFO Executing SQL [SELECT version from sys.v$timezone_file;] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:44:27.965 INFO Finished check [OLD_TIME_ZONES_EXIST][hongkong][PASSED] - CheckTrigger.call 
2021-03-09 03:44:27.965 INFO Running check DIR_SYMLINKS [hongkong] - CheckTrigger.call 
2021-03-09 03:44:27.968 INFO Finished check [POST_FIXED_OBJECTS][hongkong][NOT PASSED] - CheckTrigger.call 
2021-03-09 03:44:27.968 INFO Running check EDS_EXISTS [hongkong] - CheckTrigger.call 
2021-03-09 03:44:27.969 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:27.969 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:27.969 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:44:27.969 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:27.969 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:27.969 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:27.969 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:27.970 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:27.970 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:27.970 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:44:27.970 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:27.970 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:27.970 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:27.970 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:27.988 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:27.988 INFO Executing SQL [declare
symlink_exists NUMBER :=0;
dircnt NUMBER :=0;
dirlist VARCHAR2(4000) := '';
BEGIN
IF '19.0.0.0.0' = '19.0.0.0.0' THEN
-- Perform post-upgrade check with dbms_utility
-- Use execute immediate for pre-12c releases (no oracle_maintained)
EXECUTE IMMEDIATE
q'[DECLARE
link_exists NUMBER;
BEGIN 
FOR dir IN (SELECT directory_name 
FROM sys.dba_directories d, sys.dba_objects o
WHERE o.oracle_maintained = 'N' 
AND o.object_name = d.directory_name
AND o.object_type = 'DIRECTORY'
AND directory_name NOT IN 
-- exclude Oracle directories that may not be tagged OM
('DATA_PUMP_DIR','JAVA$JOX$CUJS$DIRECTORY$',
'OPATCH_INST_DIR','OPATCH_LOG_DIR','OPATCH_SCRIPT_DIR',
'ORACLE_BASE','ORACLE_HOME',
'ORACLE_OCM_CONFIG_DIR','ORACLE_OCM_CONFIG_DIR2',
'ORA_DBMS_FCP_ADMINDIR','ORA_DBMS_FCP_LOGDIR',
'PREUPGRADE_DIR','SDO_DIR_ADMIN','SDO_DIR_WORK',
'XMLDIR','XSDDIR')) LOOP
SELECT sys.dbms_utility.directory_has_symlink(dir.directory_name) 
INTO link_exists FROM sys.dual;
IF link_exists = 1 THEN 
:exists := 1;
EXIT;
END IF;
END LOOP;

END;]' USING IN OUT symlink_exists;
IF symlink_exists = 1 THEN
dbms_output.put_line('dir_symlinks'); -- a directory with symlinks was found
ELSE
dbms_output.put_line('SUCCESS'); -- no directories with symlinks found
END IF;
ELSE
-- Perform pre-upgrade check without dbms_utility
FOR dir IN (SELECT directory_name FROM sys.dba_directories
WHERE directory_name NOT IN -- exclude Oracle directories
('DATA_PUMP_DIR','JAVA$JOX$CUJS$DIRECTORY$',
'OPATCH_INST_DIR','OPATCH_LOG_DIR','OPATCH_SCRIPT_DIR',
'ORACLE_BASE','ORACLE_HOME',
'ORACLE_OCM_CONFIG_DIR','ORACLE_OCM_CONFIG_DIR2',
'ORA_DBMS_FCP_ADMINDIR','ORA_DBMS_FCP_LOGDIR',
'XMLDIR','XSDDIR')
ORDER BY directory_name) LOOP
dircnt:=dircnt+1;
dirlist := dirlist || dir.directory_name || ', ';
END LOOP;

IF dircnt = 0 THEN -- no USER directories
dbms_output.put_line('SUCCESS');
ELSE
dirlist := substr(dirlist,1,length(dirlist) - 2); -- remove last comma
dbms_output.put_line(dircnt||'#'||dirlist);
END IF;
END IF;
EXCEPTION
WHEN VALUE_ERROR THEN -- filled up dirlist string, so just show what is there
dbms_output.put_line(dircnt||'#'||substr(dirlist,length(dirlist)-20)||' (incomplete list)');
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:44:27.988 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:27.988 INFO Executing SQL [DECLARE
t_count NUMBER := 0;
status NUMBER;
BEGIN
BEGIN
EXECUTE IMMEDIATE
'SELECT COUNT(*) FROM sys.dba_logstdby_eds_tables'
INTO t_count;
EXCEPTION
WHEN OTHERS THEN NULL;
END;

IF (t_count = 0) THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
DBMS_OUTPUT.PUT_LINE('19');
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:44:29.015 INFO Finished check [EDS_EXISTS][hongkong][PASSED] - CheckTrigger.call 
2021-03-09 03:44:29.016 INFO Running check INFORM_DROP_GRP [hongkong] - CheckTrigger.call 
2021-03-09 03:44:29.016 INFO Finished check [DIR_SYMLINKS][hongkong][PASSED] - CheckTrigger.call 
2021-03-09 03:44:29.017 INFO Running check TIMESTAMP_MISMATCH [hongkong] - CheckTrigger.call 
2021-03-09 03:44:29.017 INFO Starting - timestamp_mismatch.checkCode 
2021-03-09 03:44:29.018 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:29.018 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:29.019 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:44:29.019 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:29.019 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:29.019 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:29.019 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:29.031 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:29.031 INFO Executing SQL [select name from v$restore_point where name like 'AUTOUPGRADE_9212_%';
] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:44:29.032 INFO Begin [/u01/app/oracle/product/19.0.0/dbhome_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:29.033 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:29.033 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:44:29.033 INFO Starting - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:29.034 INFO Finished - ExecuteProcess.setLibsForSqlplus 
2021-03-09 03:44:29.034 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:29.034 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:29.053 INFO End Creating process - ExecuteProcess.startSqlPlusProcess 
2021-03-09 03:44:29.054 INFO Executing SQL [DECLARE
TS_MISMATCH_COUNT NUMBER := 0;
TS_MISMATCH_QUERY VARCHAR2(300) := 'select count(1)
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 
EXECUTE IMMEDIATE TS_MISMATCH_QUERY INTO TS_MISMATCH_COUNT;
IF TS_MISMATCH_COUNT = 0 THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
DBMS_OUTPUT.PUT_LINE('FAILURE');
END IF;
END;
/] in [hongkong, container:null] - ExecuteSql$SQLClient.run 
2021-03-09 03:44:30.087 INFO Finished check [INFORM_DROP_GRP][hongkong][NOT PASSED] - CheckTrigger.call 
2021-03-09 03:44:30.088 INFO Succeeded - timestamp_mismatch.checkCode 
2021-03-09 03:44:30.088 INFO Finished check [TIMESTAMP_MISMATCH][hongkong][PASSED] - CheckTrigger.call 

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