2021-03-09 02:51:49.187 INFO Starting log for hongkong - Utilities.createLogger
2021-03-09 02:51:49.308 INFO Running check AMD_EXISTS [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.319 INFO Running check PLUGIN_COMP_COMPATIBILITY [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.320 INFO No database conversion will be performed for database hongkong, Component validation check skipped - plugin_comp_compatibility.checkCode
2021-03-09 02:51:49.321 INFO Finished check [PLUGIN_COMP_COMPATIBILITY][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.321 INFO Running check AUDTAB_ENC_TS [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.338 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.338 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.338 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.338 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.338 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.338 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.338 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.349 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.349 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.349 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.349 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.349 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.349 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.349 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.371 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.371 INFO Executing SQL [DECLARE
n_status NUMBER := -1;
BEGIN
--
-- Is AMD around?
--
BEGIN
EXECUTE IMMEDIATE
'SELECT status FROM sys.registry$ WHERE cid=''AMD''
AND namespace=''SERVER'''
INTO n_status;
EXCEPTION
WHEN OTHERS THEN NULL; -- AMD not in registry
END;
IF (n_status = -1) THEN
-- AMD not in registry
-- or output is XML, return success
DBMS_OUTPUT.PUT_LINE('SUCCESS');
END IF;
--
-- This is a manual only check
--
DBMS_OUTPUT.PUT_LINE('12.2.0.1.0');
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:49.393 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.393 INFO Executing SQL [declare
aud_ts_encrypted NUMBER := 0;
uniaud_ts_encrypted NUMBER := 0;
wallet_open_status NUMBER := 0;
uniaud_is_part NUMBER := 0;
db_version VARCHAR2(5);
BEGIN
-- Get the current db version
SELECT SUBSTR(version,1,4) INTO db_version FROM sys.registry$
WHERE cid = 'CATPROC';
IF db_version IN ('11.2') THEN
-- Bug 23539027:Do not reference WALLET_TYPE column of SYS.V$ENCRYPTION_WALLET
-- view as it does not exist in 11.2* DB vesrions
-- Check if Oracle Encryption Wallet is Open
EXECUTE IMMEDIATE 'SELECT count(*) FROM ' ||
'(SELECT status, wrl_type FROM sys.v$encryption_wallet ORDER BY ' ||
' wrl_type DESC) ks WHERE ROWNUM < 2 and ' ||
'ks.status <> ''OPEN''' INTO wallet_open_status;
ELSE
-- Bug 30178250: Use WALLET_ORDER instead of WALLET_TYPE and remove UNKNOWN
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.v$encryption_wallet WHERE ' ||
'status <> ''OPEN'' AND ' ||
'wallet_order IN (''PRIMARY'', ''SINGLE'') AND ' ||
'con_id = sys_context(''userenv'', ''con_id'')' INTO
wallet_open_status;
END IF;
IF (wallet_open_status > 0) THEN -- Wallet Not Open
-- Check if AUD$/FGA_LOG$ is stored into an Encrypted Tablespace
SELECT count(*) INTO aud_ts_encrypted FROM sys.ts$ t1, sys.tab$ t2
WHERE (t1.ts# = t2.ts#)
AND (bitand(t1.flags, 16384)=16384) -- encrypted tablespace bit check
AND t2.obj# IN (SELECT o.obj# FROM sys.obj$ o WHERE
o.name IN ('AUD$', 'FGA_LOG$') AND (o.type# = 2)
AND o.owner# IN (SELECT u.user# FROM sys.user$ u
WHERE u.name IN ('SYS', 'SYSTEM') AND (u.type# = 1)));
IF (aud_ts_encrypted > 0) THEN
DBMS_OUTPUT.PUT_LINE('PRESENT');
return;
END IF;
-- Check if AUDSYS.AUD$UNIFIED is stored into an Encrypted Tablespace
-- Before that, first check if AUDSYS.AUD$UNIFIED is Partitioned
SELECT count(*) INTO uniaud_is_part FROM
sys.partobj$ p, sys.obj$ o, sys.user$ u WHERE
(p.obj# = o.obj#) AND (o.type# = 2) AND (o.name = 'AUD$UNIFIED') AND
(o.owner# = u.user#) AND (u.name = 'AUDSYS') AND (u.type# = 1);
IF (uniaud_is_part > 0) THEN -- AUDSYS.AUD$UNIFIED is Partitioned
SELECT count(*) INTO uniaud_ts_encrypted FROM
sys.ts$ t1, sys.tabpart$ t2, sys.obj$ o, sys.user$ u
WHERE (t1.ts# = t2.ts#) AND (bitand(t1.flags, 16384)=16384) AND
(t2.bo# = o.obj#) AND (o.type# = 2) AND (o.name = 'AUD$UNIFIED') AND
(o.owner# = u.user#) AND (u.name='AUDSYS') AND (u.type# = 1);
ELSE
SELECT count(*) INTO uniaud_ts_encrypted FROM
sys.ts$ t1, sys.tab$ t2, sys.obj$ o, sys.user$ u
WHERE (t1.ts# = t2.ts#) AND (bitand(t1.flags, 16384)=16384) AND
(t2.obj# = o.obj#) AND (o.type# = 2) AND (o.name = 'AUD$UNIFIED')
AND (o.owner# = u.user#) AND (u.name = 'AUDSYS') AND (u.type# = 1);
END IF;
IF (uniaud_ts_encrypted > 0) THEN
DBMS_OUTPUT.PUT_LINE('PRESENT');
return;
END IF;
END IF;
DBMS_OUTPUT.PUT_LINE('SUCCESS');
EXCEPTION
WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('NOT_PRESENT');
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:49.420 INFO Finished check [AMD_EXISTS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.420 INFO Running check CASE_INSENSITIVE_AUTH [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.450 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.450 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.451 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.451 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.451 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.451 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.451 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.464 INFO Finished check [AUDTAB_ENC_TS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.464 INFO Running check COMPATIBLE_NOT_SET [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.466 INFO Finished check [COMPATIBLE_NOT_SET][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.466 INFO Running check COMPATIBLE_PARAMETER [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.466 INFO Finished check [COMPATIBLE_PARAMETER][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.466 INFO Running check CONC_RES_MGR [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.494 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.494 INFO Executing SQL [DECLARE
sec_case_sensitive_logon number;
BEGIN
--
-- Get the value of the SEC_CASE_SENSITIVE_LOGON initialization parameter.
--
select decode (VALUE, 'FALSE', 0, 1) into sec_case_sensitive_logon
from SYS.V$SYSTEM_PARAMETER
where NAME='sec_case_sensitive_logon';
if (sec_case_sensitive_logon = 1) 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 02:51:49.494 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.494 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.494 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.494 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.495 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.495 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.495 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.497 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.497 INFO Executing SQL [DECLARE
v_is_conc_on_boolean boolean := FALSE;
v_is_res_man_on_boolean boolean := FALSE;
v_conc_on_text varchar2(20);
v_res_man_on_text SYS.V$PARAMETER.VALUE%TYPE;
disable_conc_stats_text varchar2(75);
BEGIN
--
-- is concurrent preference set to on?
--
BEGIN
EXECUTE IMMEDIATE
'SELECT DBMS_STATS.GET_PREFS(''CONCURRENT'') FROM SYS.DUAL'
INTO v_conc_on_text;
--
-- In 11.2 concurrent statistics preference had only two values, TRUE and FALSE.
-- Starting 12.1 It can have four values: MANUAL, AUTOMATIC, ALL and OFF.
-- FALSE or OFF mean that the concurrent preference is disabled
IF (v_conc_on_text not in ('OFF', 'FALSE' )) THEN -- If it is disabled.
v_is_conc_on_boolean := TRUE;
ELSE
DBMS_OUTPUT.PUT_LINE('SUCCESS'); -- CONCURRENT STATS ARE DISABLED so we do not need to check anything further.
RETURN;
END IF;
-- The query should return any value (FALSE OR OFF) if not it means
-- something happened at db level. Raise an exception.
END;
--
-- is Resourcer manager on?
--
BEGIN
EXECUTE IMMEDIATE
'select nvl(value, ''DISABLED'') from sys.v$parameter where name = ''resource_manager_plan'''
INTO v_res_man_on_text;
IF (v_res_man_on_text != 'DISABLED') THEN
v_is_res_man_on_boolean := TRUE;
END IF;
-- IF Resource manager is disabled the query will return no values.
-- If there is any other error then raise an exception.
END;
IF ('12.2' = '11.2') THEN
disable_conc_stats_text := 'DBMS_STATS.SET_GLOBAL_PREFS(''CONCURRENT'',''FALSE'')';
ELSE
disable_conc_stats_text := 'DBMS_STATS.SET_GLOBAL_PREFS(''CONCURRENT'',''OFF'')';
END IF;
--
-- check if the concurrent statistics preferences is on
-- and if Resource Manager is enabled
-- The validation that will trigger the c_failure condition is:
-- is_conc_pref is TRUE and is_res_man is FALSE
--
IF (v_is_conc_on_boolean AND NOT v_is_res_man_on_boolean) THEN
DBMS_OUTPUT.PUT_LINE(v_conc_on_text||'#'||disable_conc_stats_text);
ELSE
DBMS_OUTPUT.PUT_LINE('SUCCESS');
END IF;
EXCEPTION WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('Could not determine the status of Concurrent statistics or Resource manager.');
WHEN OTHERS THEN
RAISE;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:49.524 INFO Finished check [CASE_INSENSITIVE_AUTH][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.524 INFO Running check CYCLE_NUMBER [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.524 INFO Finished check [CYCLE_NUMBER][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.525 INFO Running check CREATE_WINDOWS_SERVICE [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.525 INFO Finished check [CREATE_WINDOWS_SERVICE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.525 INFO Running check DATA_MINING_OBJECT [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.548 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.548 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.548 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.548 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.548 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.550 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.550 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.561 INFO Finished check [CONC_RES_MGR][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.561 INFO Running check FLASH_RECOVERY_AREA_SETUP [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.564 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.564 INFO Executing SQL [DECLARE
rows number;
BEGIN
select count(1) into rows from modeltab$ m, sys.ts$ t, sys_objects s
where m.obj#=s.object_id and s.ts_number=t.ts#
and t.name not in ('SYSTEM','SYSAUX')
and rownum <=1;
IF rows=0 THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
-- There are data mining objects in the database
DBMS_OUTPUT.PUT_LINE('FAILURE');
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:49.572 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.572 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.573 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.573 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.573 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.573 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.573 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.575 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.575 INFO Executing SQL [select count(*) FROM SYS.V$RECOVERY_FILE_DEST WHERE NAME IS NOT NULL;] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:49.600 INFO Finished check [DATA_MINING_OBJECT][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.601 INFO Running check DEPEND_USR_TABLES [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.612 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.612 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.613 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.613 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.613 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.613 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.613 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.626 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.626 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('12.2.0.1.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('12.2.0.1.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('12.2.0.1.0');
RETURN;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:49.635 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.635 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.635 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.636 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.636 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.636 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.636 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.640 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.640 INFO Executing SQL [select VALUE bytes from sys.v$parameter where upper(name)='DB_RECOVERY_FILE_DEST_SIZE';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:49.720 INFO Finished check [FLASH_RECOVERY_AREA_SETUP][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.721 INFO Running check DICTIONARY_STATS [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.735 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.735 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.736 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.736 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.736 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.736 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.736 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.748 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.748 INFO Executing SQL [DECLARE
dictionary_stats_recent NUMBER := 0;
doc_name VARCHAR2(80) := ''; -- holds the name of the doc that
-- points to the section on
-- managing optimizer statistics
BEGIN
select COUNT(operation) into dictionary_stats_recent
from SYS.DBA_OPTSTAT_OPERATIONS doo1
where ((operation = 'gather_dictionary_stats') OR
((operation = 'gather_schema_stats' AND
(TARGET = 'SYS' OR TARGET = 'SYSTEM')))) AND
not exists(select 1
from SYS.DBA_OPTSTAT_OPERATIONS doo2
where doo2.operation = replace(doo1.operation, 'gather', 'delete') AND
nvl(doo2.target, 'D') = nvl(doo1.target, 'D') AND
doo2.start_time > doo1.start_time) AND
start_time > systimestamp - INTERVAL '8' DAY;
-- If recent enough we are good
IF (dictionary_stats_recent != 0) THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
doc_name := '12.2.0.1';
IF ('12.2' = '11.2') THEN
doc_name := doc_name || ' Oracle Database Performance Tuning Guide';
ELSIF ('12.2' = '12.1' OR '12.2.0.1' = '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 IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:49.818 INFO Finished check [DEPEND_USR_TABLES][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.819 INFO Running check DV_SIMULATION [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.832 INFO Finished check [DICTIONARY_STATS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.833 INFO Running check FILES_NEED_RECOVERY [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.841 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.841 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.842 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.842 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.842 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.842 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.842 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.850 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.851 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.851 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.851 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.851 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.851 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.851 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.852 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.852 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 02:51:49.861 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.861 INFO Executing SQL [SELECT count(1) FROM sys.v$recover_file WHERE ((error <> 'OFFLINE NORMAL') or (error is null)) and rownum <=1;] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:49.890 INFO Finished check [DV_SIMULATION][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.891 INFO Running check HIDDEN_PARAMS [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.906 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.906 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.906 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.906 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.907 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.907 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.907 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.912 INFO Finished check [FILES_NEED_RECOVERY][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.912 INFO Running check INVALID_OBJECTS_EXIST [hongkong] - CheckTrigger.call
2021-03-09 02:51:49.915 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.915 INFO Executing SQL [SELECT name FROM sys.v$parameter WHERE name LIKE '\_%' ESCAPE '\' AND name <> '_oracle_script' AND ismodified != 'MODIFIED';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:49.916 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.916 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.917 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:49.917 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.917 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:49.917 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.917 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.931 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:49.931 INFO Executing SQL [DECLARE
t_null CHAR(1);
invalid_objs BOOLEAN := FALSE;
t_invalid_objs NUMBER;
BEGIN
--
-- Check for INVALID objects
-- For 'inplace' upgrades check for invalid objects that can be excluded
-- as they may have changed between releases and don't need to be reported.
--
-- For all other types of upgrades, use the simple query below to
-- eliminate running the intricate queries except when they are needed.
--
BEGIN
IF NOT FALSE THEN
EXECUTE IMMEDIATE 'SELECT NULL FROM sys.dba_objects
WHERE status = ''INVALID'' AND object_name NOT LIKE ''BIN$%'' AND
rownum <=1'
INTO t_null;
-- For patch release - update the objects in the query below
ELSE
-- V_$ROLLNAME special cased because of references to x$ tables
EXECUTE IMMEDIATE 'SELECT NULL FROM SYS.DBA_OBJECTS
WHERE status = ''INVALID'' AND object_name NOT LIKE ''BIN$%'' AND
rownum <=1 AND
object_name NOT IN
(SELECT name FROM SYS.dba_dependencies
START WITH referenced_name IN (
''V$LOGMNR_SESSION'', ''V$ACTIVE_SESSION_HISTORY'',
''V$BUFFERED_SUBSCRIBERS'', ''GV$FLASH_RECOVERY_AREA_USAGE'',
''GV$ACTIVE_SESSION_HISTORY'', ''GV$BUFFERED_SUBSCRIBERS'',
''V$RSRC_PLAN'', ''V$SUBSCR_REGISTRATION_STATS'',
''GV$STREAMS_APPLY_READER'',''GV$ARCHIVE_DEST'',
''GV$LOCK'',''DBMS_STATS_INTERNAL'',''V$STREAMS_MESSAGE_TRACKING'',
''GV$SQL_SHARED_CURSOR'',''V$RMAN_COMPRESSION_ALGORITHM'',
''V$RSRC_CONS_GROUP_HISTORY'',''V$PERSISTENT_SUBSCRIBERS'',''V$RMAN_STATUS'',
''GV$RSRC_CONSUMER_GROUP'',''V$ARCHIVE_DEST'',''GV$RSRCMGRMETRIC'',
''GV$RSRCMGRMETRIC_HISTORY'',''V$PERSISTENT_QUEUES'',''GV$CPOOL_CONN_INFO'',
''GV$RMAN_COMPRESSION_ALGORITHM'',''DBA_BLOCKERS'',''V$STREAMS_TRANSACTION'',
''V$STREAMS_APPLY_READER'',''GV$SGA_DYNAMIC_FREE_MEMORY'',''GV$BUFFERED_QUEUES'',
''GV$RSRC_PLAN_HISTORY'',''GV$ENCRYPTED_TABLESPACES'',''V$ENCRYPTED_TABLESPACES'',
''GV$RSRC_CONS_GROUP_HISTORY'',''GV$RSRC_PLAN'',
''GV$RSRC_SESSION_INFO'',''V$RSRCMGRMETRIC'',''V$STREAMS_CAPTURE'',
''V$RSRCMGRMETRIC_HISTORY'',''GV$STREAMS_TRANSACTION'',''DBMS_LOGREP_UTIL'',
''V$RSRC_SESSION_INFO'',''GV$STREAMS_CAPTURE'',''V$RSRC_PLAN_HISTORY'',
''GV$FLASHBACK_DATABASE_LOGFILE'',''V$BUFFERED_QUEUES'',
''GV$PERSISTENT_SUBSCRIBERS'',''GV$FILESTAT'',''GV$STREAMS_MESSAGE_TRACKING'',
''V$RSRC_CONSUMER_GROUP'',''V$CPOOL_CONN_INFO'',''DBA_DML_LOCKS'',
''V$FLASHBACK_DATABASE_LOGFILE'',''GV$HM_RECOMMENDATION'',
''V$SQL_SHARED_CURSOR'',''GV$PERSISTENT_QUEUES'',''GV$FILE_HISTOGRAM'',
''DBA_WAITERS'',''GV$SUBSCR_REGISTRATION_STATS'')
AND referenced_type in (''VIEW'',''PACKAGE'') OR
name = ''V_$ROLLNAME''
CONNECT BY
PRIOR name = referenced_name and
PRIOR type = referenced_type)'
INTO t_null;
END IF;
invalid_objs := TRUE;
EXCEPTION
WHEN NO_DATA_FOUND THEN NULL;
END;
-- look for invalid objects
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_objects
WHERE status !=''VALID'' ' INTO t_invalid_objs;
--
-- Now get back to reporting the issue if we need to.
--
IF invalid_objs = FALSE THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
DBMS_OUTPUT.PUT_LINE('12.2.0.1.0#'||t_invalid_objs);
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:49.991 INFO Finished check [HIDDEN_PARAMS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:49.992 INFO Running check INVALID_SYS_TABLEDATA [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.009 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.009 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.009 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.009 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.009 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.009 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.009 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.022 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.022 INFO Executing SQL [DECLARE
query VARCHAR2(4000);
rows NUMBER;
BEGIN
-- Use schemas from registry$ tables and from user$ (12.1)
query := 'SELECT count(1)
FROM sys.obj$ o, sys.col$ c, sys.coltype$ t
WHERE BITAND(t.flags, 256) = 256 -- DATA_UPGRADED = NO
AND o.obj# = t.obj# AND c.OBJ# = t.obj#
AND c.COL# = t.col# AND t.intcol# = c.intcol#
AND o.type# = 2 AND o.owner# 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 ROWNUM <=1';
execute immediate query into rows;
IF rows = 0 THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
-- An Oracle-Supplied table needing to be upgraded has been found
DBMS_OUTPUT.PUT_LINE('12.2.0.1.0');
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.026 INFO Finished check [INVALID_OBJECTS_EXIST][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.026 INFO Running check INVALID_USR_TABLEDATA [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.036 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.037 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.037 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.037 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.037 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.037 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.037 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.043 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.043 INFO Executing SQL [DECLARE
t_null NUMBER;
BEGIN
--
-- Include only tables dependent on Oracle-Maintained types
-- by looking through dependency$ for types owned by schemas in
-- registry$ or user$ (12.1) Oracle-Maintained flag.
BEGIN
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.COL$ c, SYS.COLTYPE$ t
WHERE BITAND(t.FLAGS, 256) = 256 -- DATA_UPGRADED = NO
AND o.OBJ# = t.OBJ# AND c.OBJ# = t.OBJ#
AND c.COL# = t.COL# AND t.INTCOL# = c.INTCOL#
AND o.type# = 2 AND o.owner# NOT IN -- Not an Oracle-Supplied user
(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 o.obj# IN --A dependent of an Oracle-maintained type
(SELECT d.obj# from DEPOBJ d
START WITH d.p_obj# IN
(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 user$ WHERE type#=1 AND bitand(spare1,256)=256))
CONNECT BY NOCYCLE PRIOR d.d_obj# = d.p_obj#)
AND ROWNUM <=1;
-- A row found, so the check fails
DBMS_OUTPUT.PUT_LINE('12.2.0.1.0');
EXCEPTION -- No user tables dependent on Oracle-Maintained types need upgrading
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
END;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.069 INFO Finished check [INVALID_SYS_TABLEDATA][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.070 INFO Running check JAVAVM_STATUS [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.081 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.081 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.082 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.082 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.082 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.082 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.082 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.097 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.097 INFO Executing SQL [DECLARE
javavm VARCHAR2(20):='ok';
error VARCHAR2(20);
message VARCHAR2(1000);
BEGIN
IF sys.dbms_registry.is_loaded('JAVAVM') IS NOT NULL THEN
BEGIN
EXECUTE IMMEDIATE 'declare junk varchar2(10):=dbms_java.longname(''foo''); begin null; end;';
EXCEPTION
WHEN OTHERS THEN
javavm := 'notok';
error := SQLCODE;
message := SQLERRM;
END;
END IF;
if (javavm='ok') then
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
DBMS_OUTPUT.PUT_LINE(error||'#'||message);
end if;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.176 INFO Finished check [JAVAVM_STATUS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.176 INFO Running check JVM_MITIGATION_PATCH [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.193 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.193 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.193 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.193 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.193 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.193 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.193 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.210 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.210 INFO Executing SQL [select COUNT(1) from sys.dba_triggers where trigger_name='DBMS_JAVA_DEV_TRG' and owner='SYS' and status='ENABLED';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.244 INFO Finished check [INVALID_USR_TABLEDATA][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.250 INFO Running check ORACLE_RESERVED_USERS [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.250 INFO Finished check [ORACLE_RESERVED_USERS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.251 INFO Running check TRGOWNER_NO_ADMNDBTRG [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.270 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.270 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.270 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.270 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.270 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.270 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.270 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.272 INFO Finished check [JVM_MITIGATION_PATCH][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.272 INFO Running check MV_REFRESH [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.280 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.280 INFO Executing SQL [DECLARE
TRG_EXISTS NUMBER := 0;
TRGADM_QUERY VARCHAR2(300) :='';
BEGIN
TRGADM_QUERY:= 'SELECT COUNT(OWNER) TRG_EXISTS FROM SYS.DBA_TRIGGERS
WHERE TRIM(BASE_OBJECT_TYPE)=''DATABASE'' AND
OWNER NOT IN (SELECT GRANTEE FROM SYS.DBA_SYS_PRIVS
WHERE PRIVILEGE=''ADMINISTER DATABASE TRIGGER'')';
EXECUTE IMMEDIATE TRGADM_QUERY INTO TRG_EXISTS;
IF TRG_EXISTS = 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 02:51:50.281 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.281 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.281 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.282 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.282 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.282 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.282 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.290 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.290 INFO Executing SQL [DECLARE
num_notfresh_mvs NUMBER := 0;
num_sumdelta_rows NUMBER := 0;
num_refinprog_mvs NUMBER := 0;
BEGIN
BEGIN
EXECUTE IMMEDIATE
'select count(*) from (select mview_name from sys.all_mviews where staleness
<> ''FRESH'')' into num_notfresh_mvs;
EXCEPTION
WHEN OTHERS THEN NULL;
END;
BEGIN
EXECUTE IMMEDIATE
'select count(*) from sys.sumdelta$' into num_sumdelta_rows;
EXCEPTION
WHEN OTHERS THEN NULL;
END;
BEGIN
EXECUTE IMMEDIATE
'select count(*) from
(SELECT u.name owner, o.name mview_name
FROM sys.obj$ o, sys.user$ u, sys.sum$ s
WHERE o.type# = 42 AND o.owner# = u.user# and s.obj# = o.obj#
and bitand(s.mflags, 8) = 8)' into num_refinprog_mvs;
EXCEPTION
WHEN OTHERS THEN NULL;
END;
IF (num_notfresh_mvs = 0 AND num_sumdelta_rows = 0 AND num_refinprog_mvs = 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 02:51:50.324 INFO Finished check [TRGOWNER_NO_ADMNDBTRG][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.326 INFO Running check PENDING_DST_SESSION [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.341 INFO Finished check [MV_REFRESH][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.342 INFO Running check POST_DICTIONARY [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.345 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.345 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.345 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.345 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.345 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.345 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.345 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.347 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.348 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.348 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.348 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.348 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.348 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.348 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.358 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.358 INFO Executing SQL [DECLARE
DST_US_VALUE VARCHAR2(4000) :='';
BEGIN
EXECUTE IMMEDIATE 'SELECT property_value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME = ''DST_UPGRADE_STATE'''
INTO DST_US_VALUE;
IF DST_US_VALUE = 'NONE' THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
DBMS_OUTPUT.PUT_LINE(DST_US_VALUE);
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.358 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.358 INFO Executing SQL [DECLARE
dictionary_stats_recent NUMBER;
correct_version boolean := TRUE;
BEGIN
-- check produced for hongkong
IF TRUE 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 02:51:50.388 INFO Finished check [PENDING_DST_SESSION][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.388 INFO Running check POST_FIXED_OBJECTS [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.405 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.405 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.405 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.405 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.405 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.405 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.405 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.419 INFO Finished check [POST_DICTIONARY][hongkong][NOT PASSED] - CheckTrigger.call
2021-03-09 02:51:50.419 INFO Running check POST_JVM_MITIGAT_PATCH [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.423 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.423 INFO Executing SQL [DECLARE
doc_name VARCHAR2(80) := '';
BEGIN
-- this CHECK always fails... it always produces the recommendations.
doc_name := '12.2.0.1';
IF ('12.2' = '11.2') THEN
doc_name := doc_name || ' Oracle Database Performance Tuning Guide';
ELSIF ('12.2' = '12.1' OR '12.2.0.1' = '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 02:51:50.424 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.424 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.424 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.424 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.424 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.424 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.425 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.434 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.434 INFO Executing SQL [select COUNT(1) from sys.dba_triggers where trigger_name='DBMS_JAVA_DEV_TRG' and owner='SYS' and status='ENABLED';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.473 INFO Finished check [POST_FIXED_OBJECTS][hongkong][NOT PASSED] - CheckTrigger.call
2021-03-09 02:51:50.474 INFO Running check PRE_FIXED_OBJECTS [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.497 INFO Finished check [POST_JVM_MITIGAT_PATCH][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.497 INFO Running check PURGE_RECYCLEBIN [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.500 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.500 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.500 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.500 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.500 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.500 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.500 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.501 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.501 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.501 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.501 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.501 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.501 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.501 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.512 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.512 INFO Executing SQL [DECLARE
fixed_objects_stats_recent NUMBER := 0;
has_stats_cnt number := 0; -- # of fixed object tables that have stats
doc_name VARCHAR2(80) := '';
BEGIN
select COUNT(operation) into fixed_objects_stats_recent
from SYS.DBA_OPTSTAT_OPERATIONS
where operation ='gather_fixed_objects_stats'
and start_time > systimestamp - INTERVAL '8' DAY;
-- If recent enough we are good
IF (fixed_objects_stats_recent != 0) THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
RETURN;
END IF;
-- find # of fixed object tables that have had stats collected
execute immediate 'select count(*) from sys.dba_tab_statistics
where owner = ''SYS'' and table_name like ''X$%''
and last_analyzed is not null'
into has_stats_cnt;
-- if none of the fixed obj tables have had stats collected
-- then gather fixed objects stats
-- else do nothing
if has_stats_cnt > 0 then
DBMS_OUTPUT.PUT_LINE('SUCCESS');
else
doc_name := '12.2.0.1';
IF ('12.2' = '11.2') THEN
doc_name := doc_name || ' Oracle Database Performance Tuning Guide';
ELSIF ('12.2' = '12.1' OR '12.2.0.1' = '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 if;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.513 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.513 INFO Executing SQL [DECLARE
obj_count NUMBER;
BEGIN
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM sys.recyclebin$'
INTO obj_count;
IF (obj_count = 0) THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
DBMS_OUTPUT.PUT_LINE(obj_count);
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.542 INFO Finished check [PRE_FIXED_OBJECTS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.543 INFO Running check SYNC_STANDBY_DB [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.560 INFO Finished check [PURGE_RECYCLEBIN][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.560 INFO Running check SYS_DEFAULT_TABLESPACE [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.562 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.562 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.562 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.562 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.562 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.562 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.562 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.564 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.564 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.565 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.565 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.565 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.565 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.565 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.575 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.575 INFO Executing SQL [DECLARE
t_null CHAR(1);
status NUMBER := 0;
unsynch_standby_count NUMBER := 0;
BEGIN
BEGIN
EXECUTE IMMEDIATE 'SELECT NULL FROM sys.v$parameter WHERE
name LIKE ''log_archive_dest%'' AND upper(value) LIKE ''SERVICE%''
AND rownum <=1'
INTO t_null;
EXECUTE IMMEDIATE 'SELECT NULL FROM sys.v$database WHERE
database_role=''PRIMARY'''
INTO t_null;
EXECUTE IMMEDIATE 'SELECT COUNT(*)
FROM SYS.V$ARCHIVE_DEST_STATUS DS, SYS.V$ARCHIVE_DEST D
WHERE DS.DEST_ID = D.DEST_ID
AND D.TARGET = ''STANDBY''
AND NOT (DS.STATUS = ''VALID'' AND DS.GAP_STATUS = ''NO GAP'')'
INTO unsynch_standby_count;
IF (unsynch_standby_count > 0) THEN
status := 1;
END IF;
EXCEPTION
WHEN NO_DATA_FOUND THEN status := 0;
END;
IF (status = 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 02:51:50.575 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.575 INFO Executing SQL [DECLARE
t_ts1 VARCHAR2(30);
t_ts2 VARCHAR2(30);
status NUMBER;
BEGIN
EXECUTE IMMEDIATE 'SELECT default_tablespace FROM sys.dba_users WHERE username = ''SYS'''
INTO t_ts1;
EXECUTE IMMEDIATE 'SELECT default_tablespace FROM sys.dba_users WHERE username = ''SYSTEM'''
INTO t_ts2;
IF (t_ts1 = 'SYSTEM') AND (t_ts2 = 'SYSTEM') THEN
-- Everything is fine.
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
DBMS_OUTPUT.PUT_LINE('19#12.2.0.1.0#'||t_ts1||'#'||t_ts2);
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.608 INFO Finished check [SYNC_STANDBY_DB][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.608 INFO Running check TWO_PC_TXN_EXIST [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.624 INFO Finished check [SYS_DEFAULT_TABLESPACE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.624 INFO Running check UNDERSCORE_EVENTS [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.627 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.627 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.627 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.627 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.627 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.627 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.627 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.628 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.628 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.628 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.628 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.628 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.628 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.628 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.638 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.638 INFO Executing SQL [DECLARE
rows NUMBER;
BEGIN
SELECT count(1) into rows FROM sys.dba_2pc_pending
WHERE rownum <=1;
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 02:51:50.639 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.639 INFO Executing SQL [SELECT name
FROM sys.v$parameter
WHERE UPPER(name) in ('EVENT', '_TRACE_EVENTS') AND
isdefault='FALSE';
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.667 INFO Finished check [TWO_PC_TXN_EXIST][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.668 INFO Running check UNIAUD_TAB [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.685 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.685 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.685 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.685 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.685 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.685 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.685 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.688 INFO Finished check [UNDERSCORE_EVENTS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.688 INFO Running check XBRL_VERSION [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.692 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.692 INFO Executing SQL [DECLARE
ROWS NUMBER;
BEGIN
EXECUTE IMMEDIATE 'SELECT COUNT(1) FROM sys.obj$ o WHERE o.NAME = ''AUD$UNIFIED''
and ((o.namespace = 1 or o.type# = 2) and o.type# != 19) and o.owner# IN
(select u.user# from sys.user$ u where u.name = ''AUDSYS'')
and (bitand(o.flags, 4194304) != 4194304)' 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 02:51:50.694 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.694 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.694 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.694 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.694 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.694 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.694 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.703 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.703 INFO Executing SQL [DECLARE
ROWS NUMBER;
BEGIN
EXECUTE IMMEDIATE 'SELECT COUNT(1) FROM sys.user$ WHERE name=''XBRLSYS'''
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 02:51:50.729 INFO Finished check [UNIAUD_TAB][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.729 INFO Running check XDB_RESOURCE_TYPE [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.746 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.746 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.746 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.746 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.746 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.746 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.746 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.750 INFO Finished check [XBRL_VERSION][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.751 INFO Running check NEW_TIME_ZONES_EXIST [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.754 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.754 INFO Executing SQL [DECLARE
res_obj_cnt number;
res_attr_cnt number;
attr_no_RCL number;
attr_no_COBI number;
attr_no_BV number;
dep_tab_cnt number;
non_null_cnt number;
need_patch boolean;
BEGIN
select count(*) into res_obj_cnt from SYS.DBA_OBJECTS
where owner = 'XDB' and
((object_name = 'XDB$RESOURCE' and object_type = 'TABLE') or
(object_name = 'XDB$RESOURCE_T' and object_type = 'TYPE'));
-- 22744959: XDB is not installed, and hence no wrong-ordered attributes
if (res_obj_cnt <> 2) then
DBMS_OUTPUT.PUT_LINE('SUCCESS');
end if;
select count(*) into res_attr_cnt from SYS.DBA_TYPE_ATTRS
where owner = 'XDB' and type_name = 'XDB$RESOURCE_T' and
attr_name in ('RCLIST', 'CHECKEDOUTBYID', 'BASEVERSION');
-- 22744959: wrong-ordered attributes are not introduced yet
if (res_attr_cnt = 0) then
DBMS_OUTPUT.PUT_LINE('SUCCESS');
RETURN;
elsif (res_attr_cnt = 3) then
select attr_no into attr_no_RCL from SYS.DBA_TYPE_ATTRS
where owner = 'XDB' and type_name = 'XDB$RESOURCE_T' and
attr_name = 'RCLIST';
select attr_no into attr_no_COBI from SYS.DBA_TYPE_ATTRS
where owner = 'XDB' and type_name = 'XDB$RESOURCE_T' and
attr_name = 'CHECKEDOUTBYID';
select attr_no into attr_no_BV from SYS.DBA_TYPE_ATTRS
where owner = 'XDB' and type_name = 'XDB$RESOURCE_T' and
attr_name = 'BASEVERSION';
select count(*) into dep_tab_cnt from SYS.DBA_DEPENDENCIES
where referenced_owner = 'XDB' and referenced_name = 'XDB$RESOURCE_T' and
type = 'TABLE' and (owner != 'XDB' or name != 'XDB$RESOURCE');
execute immediate
'select count(*) from XDB.XDB$RESOURCE R
where R.xmldata.checkedoutbyid is not null or
R.xmldata.baseversion is not null'
into non_null_cnt;
need_patch := (attr_no_RCL > attr_no_COBI) OR (attr_no_COBI > attr_no_BV);
-- wrong-ordered attributes exist and can be repaired during upgrade
if (not need_patch) or (dep_tab_cnt = 0 and non_null_cnt = 0) then
DBMS_OUTPUT.PUT_LINE('SUCCESS');
RETURN;
end if;
end if;
-- wrong-ordered attributes exist but beyond repair
DBMS_OUTPUT.PUT_LINE('FAILURE');
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.755 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.755 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.756 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.756 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.756 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.756 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.756 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.764 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.764 INFO Executing SQL [SELECT version from sys.v$timezone_file;] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.818 INFO Finished check [NEW_TIME_ZONES_EXIST][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.818 INFO Running check OLD_TIME_ZONES_EXIST [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.827 INFO Finished check [XDB_RESOURCE_TYPE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.827 INFO Running check OLS_VERSION [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.831 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.831 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.832 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.832 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.832 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.833 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.833 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.833 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.833 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.833 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.833 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.833 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.833 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.833 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.843 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.843 INFO Executing SQL [SELECT version from sys.v$timezone_file;] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.844 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.844 INFO Executing SQL [SELECT nvl(dbms_registry.is_loaded('OLS'), 0) from sys.dual;] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.893 INFO Finished check [OLD_TIME_ZONES_EXIST][hongkong][NOT PASSED] - CheckTrigger.call
2021-03-09 02:51:50.894 INFO Running check PARAMETER_DEPRECATED [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.894 INFO Finished check [PARAMETER_DEPRECATED][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.913 INFO Running check PARAMETER_MIN_VAL [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.915 INFO Finished check [PARAMETER_MIN_VAL][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.915 INFO Running check PARAMETER_NEW_NAME_VAL [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.919 INFO Finished check [PARAMETER_NEW_NAME_VAL][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.919 INFO Running check PARAMETER_OBSOLETE [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.919 INFO Finished check [PARAMETER_OBSOLETE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.919 INFO Running check PARAMETER_RENAME [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.920 INFO Finished check [PARAMETER_RENAME][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.920 INFO Running check MIN_ARCHIVE_DEST_SIZE [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.920 INFO hongkong log_archive_dest [] destination [] status [INACTIVE] minArchiveGen [4842323968] usableSpaceMB [-1] - min_archive_dest_size.checkCode
2021-03-09 02:51:50.920 INFO Finished check [MIN_ARCHIVE_DEST_SIZE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:50.920 INFO Running check MIN_RECOVERY_AREA_SIZE [hongkong] - CheckTrigger.call
2021-03-09 02:51:50.929 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.929 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.929 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.930 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.930 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.930 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.930 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.930 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.930 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.930 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.930 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.930 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.930 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.930 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.941 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.941 INFO Executing SQL [SELECT LOG_MODE from sys.v$database;] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.941 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.941 INFO Executing SQL [SELECT version FROM sys.registry$ WHERE cid = 'CATPROC';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.988 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.988 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.989 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.989 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.989 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.989 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.989 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.989 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.989 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.989 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:50.989 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.989 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:50.989 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.989 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.999 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.999 INFO Executing SQL [SELECT count(*) FROM sys.v$database WHERE flashback_on = 'NO';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:50.999 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:50.999 INFO Executing SQL [SELECT version FROM sys.registry$ WHERE cid = 'OLS';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.029 INFO Finished check [MIN_RECOVERY_AREA_SIZE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.029 INFO Running check DISK_SPACE_FOR_RECOVERY_AREA [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.045 INFO Finished check [OLS_VERSION][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.045 INFO Running check PA_PROFILE [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.055 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.055 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.056 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.056 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.056 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.056 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.056 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.057 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.057 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.057 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.057 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.057 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.058 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.058 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.060 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.060 INFO Executing SQL [SELECT LOG_MODE from sys.v$database;] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.061 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.061 INFO Executing SQL [DECLARE
c NUMBER;
d NUMBER;
v_tab DBMS_SQL.VARCHAR2_TABLE;
enabled_count NUMBER := 0;
tab_name VARCHAR2(130);
v_count NUMBER := 0;
row_count NUMBER := 0;
issue_found BOOLEAN := FALSE;
pa_view VARCHAR2(128) := 'SYS.DBA_PRIV_CAPTURES';
BEGIN
-- return success if view SYS.DBA_PRIV_CAPTURES does not exist
SELECT COUNT(*) INTO v_count
FROM SYS.DBA_OBJECTS
WHERE OWNER = 'SYS' AND OBJECT_NAME = 'DBA_PRIV_CAPTURES' AND OBJECT_TYPE = 'VIEW';
IF v_count = 0 THEN
dbms_output.put_line('SUCCESS');
return;
END IF;
-- return success if view SYS.DBA_SECUREFILE_LOG_TABLES does not exist
SELECT COUNT(*) INTO v_count
FROM SYS.DBA_OBJECTS
WHERE OWNER = 'SYS' AND OBJECT_NAME = 'DBA_SECUREFILE_LOG_TABLES' AND OBJECT_TYPE = 'VIEW';
IF v_count = 0 THEN
dbms_output.put_line('SUCCESS');
return;
END IF;
BEGIN
EXECUTE IMMEDIATE 'SELECT COUNT(name) FROM ' || pa_view || ' WHERE enabled=''Y''' INTO enabled_count;
EXCEPTION
WHEN OTHERS THEN NULL;
END;
c := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(c, 'SELECT table_name
FROM sys.dba_securefile_log_tables
WHERE log_name LIKE ''ORA$PA_%'' OR log_name LIKE ''ORA$PRIV_CAPTURE_%''',
DBMS_SQL.NATIVE);
DBMS_SQL.DEFINE_ARRAY(c, 1, v_tab, 1, 1);
/* execute SQL statement */
d := DBMS_SQL.EXECUTE(c);
/* retrieve column values to column table */
LOOP
EXIT WHEN DBMS_SQL.FETCH_ROWS(c) = 0;
row_count := row_count + 1;
DBMS_SQL.COLUMN_VALUE(c, 1, v_tab);
END LOOP;
DBMS_SQL.CLOSE_CURSOR(c);
FOR i IN 1..row_count LOOP
tab_name := DBMS_ASSERT.ENQUOTE_NAME(v_tab(i), FALSE);
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM ' || tab_name INTO v_count;
IF v_count > 0 THEN
issue_found := TRUE;
EXIT;
END IF;
END LOOP;
IF (enabled_count > 0 OR issue_found) THEN
dbms_output.put_line('19');
return;
ELSE
dbms_output.put_line('SUCCESS');
return;
END IF;
EXCEPTION
WHEN OTHERS THEN
IF DBMS_SQL.IS_OPEN(c) THEN
DBMS_SQL.CLOSE_CURSOR(c);
END IF;
dbms_output.put_line('19');
return;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.107 INFO Finished check [PA_PROFILE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.108 INFO Running check TEMPTS_NOTEMPFILE [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.111 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.111 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.112 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.112 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.112 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.112 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.112 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.112 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.112 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.112 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.112 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.112 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.112 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.112 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.124 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.124 INFO Executing SQL [SELECT count(*) FROM sys.v$database WHERE flashback_on = 'NO';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.124 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.124 INFO Executing SQL [SELECT TEMPORARY_TABLESPACE FROM SYS.DBA_USERS A WHERE UPPER(USERNAME)='SYS';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.163 INFO Getting usable space of [/home/oracle/u03/app/oracle/fast_recovery_area/hongkong] - Utilities.getUsableSpace
2021-03-09 02:51:51.182 INFO The amount of usable free space available on /home/oracle/u03/app/oracle/fast_recovery_area/hongkong is [127,854,788,608] - Utilities.getUsableSpace
2021-03-09 02:51:51.182 INFO Finished check [DISK_SPACE_FOR_RECOVERY_AREA][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.183 INFO Running check UPG_BY_STD_UPGRD [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.186 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.186 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.186 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.186 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.187 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.187 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.187 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.187 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.187 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.187 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.187 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.187 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.187 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.187 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.197 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.198 INFO Executing SQL [SELECT DECODE(COUNT(1), 0,'NO','YES') FROM SYS.DBA_TABLESPACE_GROUPS WHERE GROUP_NAME='TEMP';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.198 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.198 INFO Executing SQL [SELECT cname FROM sys.registry$ WHERE namespace='SERVER' and cid not in ('APS','OWM','STATS','RUL','EM','CONTEXT','EXF','DV','CATALOG','RAC','CATJAVA','XML','XDB','OLS','ODM','ORDIM','XOQ','JAVAVM','APEX','MGW','CATPROC','SDO')] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.242 INFO Finished check [UPG_BY_STD_UPGRD][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.243 INFO Running check ROLLBACK_SEGMENTS [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.243 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.243 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.243 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.243 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.243 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.243 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.243 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.246 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.246 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.246 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.246 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.246 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.246 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.246 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.256 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.257 INFO Executing SQL [SELECT COUNT(TABLESPACE_NAME) FROM SYS.DBA_TEMP_FILES WHERE TABLESPACE_NAME='TEMP';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.257 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.257 INFO Executing SQL [SELECT value FROM sys.v$parameter WHERE name = 'undo_management';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.296 INFO Finished check [TEMPTS_NOTEMPFILE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.296 INFO Running check TABLESPACES [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.313 INFO Finished check [ROLLBACK_SEGMENTS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.313 INFO Running check MANDATORY_UPGRADE_CHANGES [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.315 INFO Finished check [MANDATORY_UPGRADE_CHANGES][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.315 INFO Running check ARCHIVE_MODE_ON [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.320 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.321 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.321 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.321 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.321 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.321 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.321 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.326 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.326 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.326 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.326 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.326 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.327 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.327 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.337 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.337 INFO Executing SQL [SELECT value FROM sys.v$parameter WHERE name = 'undo_tablespace';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.337 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.338 INFO Executing SQL [select log_mode from sys.v$database;] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.385 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.386 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.386 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.388 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.388 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.388 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.388 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.391 INFO Finished check [ARCHIVE_MODE_ON][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.391 INFO Running check APEX_MANUAL_UPGRADE [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.394 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.394 INFO Executing SQL [SELECT value FROM sys.v$parameter WHERE name = 'undo_tablespace';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.396 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.396 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.396 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.396 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.396 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.396 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.396 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.407 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.407 INFO Executing SQL [SELECT version FROM sys.registry$ WHERE cid = 'APEX' and namespace='SERVER';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.453 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.453 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.453 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.453 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.453 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.453 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.453 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.458 INFO Finished check [APEX_MANUAL_UPGRADE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.459 INFO Running check PGA_AGGREGATE_LIMIT [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.459 INFO Finished check [PGA_AGGREGATE_LIMIT][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.459 INFO Running check TS_FORUPG_STATUS [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.477 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.478 INFO Executing SQL [SELECT value FROM sys.v$parameter WHERE name = 'undo_tablespace';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.482 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.482 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.482 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.482 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.482 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.482 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.483 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.500 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.501 INFO Executing SQL [DECLARE
tablespaces VARCHAR2(4000) := '';
query VARCHAR2(4000);
type cursor_t is ref cursor;
tmp_cursor cursor_t;
tbs_header VARCHAR2(100) := 'Tablespace<br> -----------------------------<br>';
tbs_name SYS.DBA_TABLESPACES.TABLESPACE_NAME%TYPE;
BEGIN
query := 'with pivot_users as
(SELECT username
FROM sys.dba_users
where user_id 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))
SELECT tablespace_name
FROM sys.dba_tablespaces
WHERE status <>''ONLINE'' and tablespace_name IN
(
SELECT property_value
FROM sys.database_properties
WHERE property_name = ''DEFAULT_PERMANENT_TABLESPACE''
UNION
SELECT default_tablespace
FROM sys.dba_users
WHERE username IN (SELECT username FROM pivot_users)
UNION
SELECT tablespace_name
FROM sys.dba_segments
WHERE owner IN (SELECT username FROM pivot_users)
UNION
SELECT t.name
FROM sys.modeltab$ m, sys.ts$ t, sys.sys_objects s
WHERE m.obj#=s.object_id and s.ts_number=t.ts#
)';
--Inspect the database to make sure there are no tablespaces from Oracle owned users
--whose stauts is different than ONLINE
OPEN tmp_cursor FOR query;
LOOP
FETCH tmp_cursor INTO tbs_name;
EXIT WHEN tmp_cursor%NOTFOUND;
tablespaces := tablespaces || ' ' || tbs_name || '<br> ';
END LOOP;
CLOSE tmp_cursor;
IF (tablespaces IS NOT NULL) THEN
tablespaces := SUBSTR(tablespaces, 1, LENGTH(tablespaces) - 5); --Remove last line break
tablespaces := tbs_header || tablespaces;
DBMS_OUTPUT.PUT_LINE(tablespaces);
ELSE
DBMS_OUTPUT.PUT_LINE('SUCCESS');
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.567 INFO Finished check [TS_FORUPG_STATUS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.567 INFO Running check STREAMS_SETUP [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.579 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.579 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.579 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.579 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.579 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.579 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.579 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.583 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.584 INFO Executing SQL [DECLARE
streams_configuration BOOLEAN := FALSE;
oggxstr_configuration BOOLEAN := FALSE;
streams_data NUMBER := 0;
streams_setup NUMBER := 0;
capture_count NUMBER := 0;
apply_count NUMBER := 0;
sync_capture_count NUMBER := 0;
BEGIN
EXECUTE IMMEDIATE 'SELECT count(1) FROM sys.dba_capture where purpose IN (''Streams'', ''XStream Streams'', ''AUDIT VAULT'', ''CHANGE DATA CAPTURE'')' into capture_count;
EXECUTE IMMEDIATE 'SELECT COUNT(1) FROM sys.dba_sync_capture' into sync_capture_count;
EXECUTE IMMEDIATE 'SELECT count(1) FROM sys.dba_apply where purpose IN (''Streams'', ''XStream Streams'', ''AUDIT VAULT'', ''CHANGE DATA CAPTURE'')' into apply_count;
IF (capture_count + sync_capture_count + apply_count) > 0 THEN
streams_configuration := TRUE;
END IF;
EXECUTE IMMEDIATE 'SELECT count(1) FROM sys.dba_capture where purpose NOT IN (''Streams'', ''XStream Streams'', ''AUDIT VAULT'', ''CHANGE DATA CAPTURE'')' into capture_count;
EXECUTE IMMEDIATE 'SELECT count(1) FROM sys.dba_apply where purpose NOT IN (''Streams'', ''XStream Streams'', ''AUDIT VAULT'', ''CHANGE DATA CAPTURE'')' into apply_count;
IF (capture_count + apply_count) > 0 THEN
oggxstr_configuration := TRUE;
END IF;
-- additional checks:
-- even if we dont have any capture/apply, there could be some configuration left behind.
-- skip this checks if we have an ogg/xstream configuration, this data will be retained.
-- skip this checks if we already found a streams only configuration.
IF NOT oggxstr_configuration AND NOT streams_configuration THEN
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_propagation' into streams_data;
streams_setup := streams_setup + streams_data;
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_streams_message_consumers WHERE queue_owner != ''SYS'''
into streams_data;
streams_setup := streams_setup + streams_data;
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_apply_instantiated_objects' into streams_data;
streams_setup := streams_setup + streams_data;
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_apply_instantiated_global' into streams_data;
streams_setup := streams_setup + streams_data;
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_capture_prepared_tables' into streams_data;
streams_setup := streams_setup + streams_data;
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_sync_capture_prepared_tabs' into streams_data;
streams_setup := streams_setup + streams_data;
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_capture_prepared_schemas' into streams_data;
streams_setup := streams_setup + streams_data;
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_capture_prepared_database' into streams_data;
streams_setup := streams_setup + streams_data;
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_apply_conflict_columns' into streams_data;
streams_setup := streams_setup + streams_data;
EXECUTE IMMEDIATE 'SELECT count(*) FROM sys.dba_apply_key_columns' into streams_data;
streams_setup := streams_setup + streams_data;
IF streams_setup != 0 THEN
streams_configuration := TRUE;
END IF;
END IF;
IF not streams_configuration
THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
DBMS_OUTPUT.PUT_LINE('FAILURE');
END IF;
EXCEPTION WHEN OTHERS THEN
IF sqlcode = -942 THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.613 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.613 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.613 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.613 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.613 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.613 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.613 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.628 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.629 INFO Executing SQL [select property_value from database_properties where PROPERTY_NAME='LOCAL_UNDO_ENABLED';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.631 INFO Finished check [STREAMS_SETUP][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.632 INFO Running check RMAN_RECOVERY_VERSION [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.638 INFO Finished check [RMAN_RECOVERY_VERSION][hongkong][NOT PASSED] - CheckTrigger.call
2021-03-09 02:51:51.638 INFO Running check OLAP_PAGE_POOL_SIZE [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.639 INFO Finished check [OLAP_PAGE_POOL_SIZE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.652 INFO Running check TABLESPACES_INFO [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.652 INFO Tablespaces table
TT[Tablespace Name|Allocated|Minimum Required for Upgrade
SYSTEM|820 MB|960 MB
TEMP|32 MB|150 MB
UNDOTBS1|65 MB|400 MB
SYSAUX|470 MB|598 MB] - tablespaces_info.checkCode
2021-03-09 02:51:51.660 INFO Finished check [TABLESPACES_INFO][hongkong][NOT PASSED] - CheckTrigger.call
2021-03-09 02:51:51.660 INFO Running check STANDARD_EDITION [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.660 INFO Finished check [STANDARD_EDITION][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.660 INFO Running check APPL_PRINCIPAL [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.666 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.666 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.666 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.666 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.666 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.666 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.666 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.677 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.677 INFO Executing SQL [DECLARE
t_count_ur NUMBER := 0;
t_count_rm NUMBER := 0;
status NUMBER;
BEGIN
BEGIN
EXECUTE IMMEDIATE
'SELECT COUNT(*) FROM XDB.APP_USERS_AND_ROLES' INTO t_count_ur;
EXECUTE IMMEDIATE
'SELECT COUNT(*) FROM XDB.APP_ROLE_MEMBERSHIP' INTO t_count_rm;
EXCEPTION
WHEN OTHERS THEN NULL;
END;
-- Ignore the AUTHENTICATED record inserted at table creation.
-- Check for records the user may have added.
IF ((t_count_ur < 2) and (t_count_rm = 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 02:51:51.695 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.695 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.695 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.695 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.695 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.695 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.695 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.704 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.704 INFO Executing SQL [SELECT value FROM sys.v$parameter WHERE name = 'undo_tablespace';] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.722 INFO Finished check [APPL_PRINCIPAL][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.722 INFO Running check DIR_SYMLINKS [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.727 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.727 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.728 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.728 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.728 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.728 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.728 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.741 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.742 INFO Executing SQL [declare
symlink_exists NUMBER :=0;
dircnt NUMBER :=0;
dirlist VARCHAR2(4000) := '';
BEGIN
IF '12.2.0.1.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 02:51:51.745 INFO Finished check [TABLESPACES][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.746 INFO Running check EDS_EXISTS [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.756 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.756 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.756 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.756 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.756 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.756 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.756 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.762 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.762 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 02:51:51.784 INFO Finished check [DIR_SYMLINKS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.784 INFO Running check TDE_IN_USE [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.789 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.789 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.789 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.789 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.789 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.789 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.789 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.803 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.804 INFO Executing SQL [DECLARE
enc_cnt NUMBER := 0;
doc_name VARCHAR2(200) := ''; -- holds the name of the doc that points to
-- the section on configuring TDE.
BEGIN
BEGIN
EXECUTE IMMEDIATE
'SELECT (T1.A + T2.B + T3.C)
FROM (SELECT count(*) A
FROM SYS.DBA_TABLESPACES
WHERE UPPER(ENCRYPTED) = ''YES'') T1,
(SELECT count(*) B
FROM SYS.DBA_ENCRYPTED_COLUMNS) T2,
(SELECT count(*) C
FROM SYS.ENC$ WHERE OWNER# IN (100,101)) T3' INTO enc_cnt;
EXCEPTION
WHEN OTHERS THEN NULL;
END;
IF (enc_cnt = 0) THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
doc_name := '12.2';
IF ('12.2' = '11.2') THEN
doc_name := doc_name ||
' Oracle Database Advanced Security Administrator''s Guide,' ||
' Section 8: Securing Stored Data Using Transparent Data Encryption';
ELSE
doc_name := doc_name || ' Oracle Database Advanced Security Guide,' ||
' Section 3: Configuring Transparent Data Encryption';
END IF;
DBMS_OUTPUT.PUT_LINE(doc_name);
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.806 INFO Finished check [EDS_EXISTS][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.807 INFO Running check ORDIM_DESUPPORT [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.817 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.817 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.817 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.817 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.817 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.817 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.818 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.824 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.825 INFO Executing SQL [BEGIN
IF (0 != 0)
THEN
DBMS_OUTPUT.PUT_LINE('19');
ELSE
DBMS_OUTPUT.PUT_LINE('SUCCESS');
END IF;
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.843 INFO Finished check [TDE_IN_USE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.843 INFO Running check UNIAUD_RECORDS_IN_FILE [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.847 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.847 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.847 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.847 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.847 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.848 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.848 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.861 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.862 INFO Executing SQL [DECLARE
aud_recs NUMBER := 0;
db_version VARCHAR2(5);
BEGIN
-- Get the current db version
SELECT SUBSTR(version,1,4) INTO db_version FROM sys.registry$
WHERE cid = 'CATPROC';
-- GV$UNIFIED_AUDIT_TRAIL gets us the number of unified audit records
-- present in the OS spillover audit files starting RDBMS 12.2 release.
-- Thus, this check should be restricted to db version >= 12.2.
-- For other db versions < 12.2, we can recommend it through documentation.
IF db_version >= ('12.2') THEN
-- Get the number of unified audit records present in OS Spillover
-- audit files (.bin format)
SELECT count(*) into aud_recs from gv$unified_audit_trail;
-- Requiring at least 2 records is expected
IF (aud_recs > 1) THEN -- records not yet loaded to DB audit table
DBMS_OUTPUT.PUT_LINE('FAILURE');
return;
END IF;
END IF;
DBMS_OUTPUT.PUT_LINE('SUCCESS');
EXCEPTION
WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('SUCCESS');
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.873 INFO Finished check [ORDIM_DESUPPORT][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.873 INFO Running check JOB_TABLE_INTEGRITY [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.892 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.892 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.892 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.893 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.893 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.893 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.893 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.898 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.899 INFO Executing SQL [DECLARE
next_date int;
invalid_jobs varchar2(4000) := '';
interval_col varchar2(4000) ;
uname VARCHAR2(128);
have_errors NUMBER := 0;
BEGIN
for job in (select job, interval#, what, powner from sys.job$ order by job) loop
if job.what is null then
invalid_jobs := invalid_jobs
|| job.job
|| ' cannot have a null ''what'' field <br>';
have_errors := 1;
end if;
begin
select username into uname from sys.dba_users where username = job.powner;
exception when others then
invalid_jobs := invalid_jobs
|| job.job
|| ' has an invalid powner field: '
|| job.powner || ' <br>';
have_errors := 1;
end;
if job.interval# is not null and upper(job.interval#) <> 'NULL' then
/*
* interval_col is only used to parse a statement, not execute, so this is safe
* only other alternative is to add a sink node, which may not be available for values returned from cursors
*/
interval_col := sys.dbms_assert.noop(job.interval#);
begin
next_date := dbms_sql.open_cursor();
dbms_sql.parse(next_date, 'select cast((' || interval_col || ') as timestamp with time zone) from sys.dual', dbms_sql.native);
dbms_sql.close_cursor(next_date);
exception when others then
invalid_jobs := invalid_jobs
|| job.job
|| ' has invalid interval expression: '
|| interval_col || ' <br>';
have_errors := 1;
end;
end if;
end loop;
if have_errors = 1 then
dbms_output.put_line('FAILURE');
end if;
dbms_output.put_line('SUCCESS');
END;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.920 INFO Finished check [UNIAUD_RECORDS_IN_FILE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.921 INFO Running check UTLRP_RUN_SERIAL [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.921 INFO Finished check [UTLRP_RUN_SERIAL][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.921 INFO Running check DESUPPORT_RAC_ON_SE [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.921 INFO Finished check [DESUPPORT_RAC_ON_SE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.921 INFO Running check COMPATIBLE_GRP [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.921 INFO Finished check [COMPATIBLE_GRP][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.921 INFO Running check INFORM_DROP_GRP [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.927 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.927 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.927 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.927 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.927 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.927 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.927 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.941 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.942 INFO Executing SQL [select name from v$restore_point where name like 'AUTOUPGRADE_9212_%';
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.943 INFO Finished check [JOB_TABLE_INTEGRITY][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:51.943 INFO Running check ORDIM_INFO_DESUPPORT [hongkong] - CheckTrigger.call
2021-03-09 02:51:51.954 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.954 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.954 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:51.954 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.954 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:51.954 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.954 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.960 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:51.960 INFO Executing SQL [DECLARE
ordim_install NUMBER := 0;
BEGIN
IF (0 = 0)
THEN
EXECUTE IMMEDIATE 'select count(*) from registry$ where CID=''ORDIM'' '
into ordim_install;
IF (ordim_install != 0)
THEN
DBMS_OUTPUT.PUT_LINE('19');
return;
END if;
END IF;
DBMS_OUTPUT.PUT_LINE('SUCCESS');
END ordim_info_desupport_check;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:51.993 INFO Finished check [INFORM_DROP_GRP][hongkong][NOT PASSED] - CheckTrigger.call
2021-03-09 02:51:51.993 INFO Running check TEMPTS_ALLOFFLINE [hongkong] - CheckTrigger.call
2021-03-09 02:51:52.012 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:52.012 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:52.012 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:52.012 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:52.013 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:52.013 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:52.013 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:52.034 INFO Finished check [ORDIM_INFO_DESUPPORT][hongkong][NOT PASSED] - CheckTrigger.call
2021-03-09 02:51:52.034 INFO Running check TARGET_CDB_COMPATIBILITY [hongkong] - CheckTrigger.call
2021-03-09 02:51:52.034 INFO Finished check [TARGET_CDB_COMPATIBILITY][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:52.035 INFO Running check DUPLICATE_DB_HASHES [hongkong] - CheckTrigger.call
2021-03-09 02:51:52.035 INFO Finished check [DUPLICATE_DB_HASHES][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:52.035 INFO Running check TIMESTAMP_MISMATCH [hongkong] - CheckTrigger.call
2021-03-09 02:51:52.035 INFO Starting - timestamp_mismatch.checkCode
2021-03-09 02:51:52.042 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:52.043 INFO Executing SQL [DECLARE
deftsisgroup VARCHAR2(5);
valid_scenario boolean := false;
deftmpts VARCHAR2(4000);
t_deftmpts VARCHAR2(4000) := '';
groupts NUMBER:=0;
inv_ts NUMBER:=0;
offline_mode varchar2(15) := ' N/A ';
TYPE number_array_t IS TABLE OF NUMBER;
TYPE string_array_t IS TABLE OF VARCHAR2(32767);
cols number_array_t:= new number_array_t(0,30,0,30,12) ;
FUNCTION column_format(column_sizes number_array_t, column_values string_array_t) RETURN CLOB
IS
column_num NUMBER;
width NUMBER;
align_left BOOLEAN;
value CLOB;
need_another_row BOOLEAN := true;
subsequent_row string_array_t := column_values;
result CLOB := '';
BEGIN
subsequent_row := column_values;
WHILE need_another_row LOOP
need_another_row := false;
FOR column_num IN 1 .. column_sizes.count LOOP
width := column_sizes(column_num);
value := subsequent_row(column_num);
IF (value IS NULL) OR (width = 0) THEN
-- do this case separately so we don't have unexpected string operations on nulls
value := rpad(' ', abs(width)); -- doesn't matter if left/right align, even if width=0
ELSE
-- negative widths mean align output on the right (typical number format.)
-- make width positive and determine which alignment we're using.
align_left := (width > 0);
width := abs(width);
IF length(value) <= width THEN
IF align_left THEN
value := rpad(value, width); -- (align left = pad on right)
ELSE
value := lpad(value, width); -- (align right = pad on left)
END IF;
subsequent_row(column_num) := null;
ELSE
need_another_row := true;
subsequent_row(column_num) := substr(value, width + 1);
value := substr(value, 1, width);
END IF;
END IF;
result := result || value;
END LOOP;
IF need_another_row THEN
result := result || '
';
END IF;
END LOOP;
RETURN result;
END column_format;
BEGIN
-- Get temporary tablespace for SYS.
SELECT TEMPORARY_TABLESPACE INTO deftmpts
FROM SYS.DBA_USERS A
WHERE UPPER(USERNAME) = 'SYS' ;
-- Determine if tablespace is part of a tablespace group?
SELECT DECODE(COUNT(1), 0,'NO','YES') INTO deftsisgroup
FROM SYS.DBA_TABLESPACE_GROUPS
WHERE GROUP_NAME = deftmpts ;
-- Temporary tablespace comes from a TS group
IF deftsisgroup='YES' THEN
-- Determine if any of the tablespaces in the group have an online file
SELECT COUNT(A.TABLESPACE_NAME) INTO groupts
FROM SYS.DBA_TABLESPACE_GROUPS A, SYS.DBA_TEMP_FILES B
where A.GROUP_NAME = deftmpts and
A.TABLESPACE_NAME = B.TABLESPACE_NAME and
B.status in ('ONLINE', offline_mode) ;
-- are there any ts in the group that have an online file
IF groupts = 0 THEN
-- No ts has an online file
valid_scenario := false;
-- Adding headers to table
t_deftmpts := column_format(cols, new string_array_t(' ', 'GROUP_NAME', ' ', 'TABLESPACE_NAME', ' '));
-- Get list of ts whose files are all offline
FOR ts_cur in (SELECT TABLESPACE_NAME
FROM SYS.DBA_TABLESPACE_GROUPS
WHERE GROUP_NAME = deftmpts) loop
t_deftmpts := t_deftmpts || column_format(cols, new string_array_t(' ', deftmpts, ' ', ts_cur.tablespace_name, ' '));
END LOOP;
-- send t_deftmpts to be displayed
deftmpts := t_deftmpts;
ELSE
-- at least one ts has an online file
valid_scenario := true;
END IF;
-- Temporary tablespace is not part of a tablespace group
ELSE
-- Check how many temp files are online
SELECT COUNT(TABLESPACE_NAME) INTO inv_ts
FROM SYS.DBA_TEMP_FILES
WHERE TABLESPACE_NAME = deftmpts and
status in ('ONLINE', offline_mode) ;
-- Does the ts have an online file
IF inv_ts > 0 THEN
-- Yes, it has at least one. OK
valid_scenario := true;
ELSE
-- No, it has 0. ERROR
valid_scenario := false;
END IF;
END IF;
IF valid_scenario THEN
DBMS_OUTPUT.PUT_LINE('SUCCESS');
ELSE
DBMS_OUTPUT.PUT_LINE(deftmpts);
END IF;
END tempts_alloffline_check;
/
] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:52.060 INFO Begin [/home/oracle/u03/app/oracle/product/12.2.0/db_1/bin/sqlplus, -silent, /, as, sysdba] - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:52.061 INFO Begin Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:52.061 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=/home/oracle/u03/app/oracle), (TWO_TASK=N/A), (ORACLE_HOME=/home/oracle/u03/app/oracle/product/12.2.0/db_1), (TNS_ADMIN=N/A), (LDAP_ADMIN=N/A), (PERL5LIB=N/A)] - ExecutionEnv.addEnvToProcess
2021-03-09 02:51:52.061 INFO Starting - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:52.061 INFO Finished - ExecuteProcess.setLibsForSqlplus
2021-03-09 02:51:52.062 INFO End Setting Oracle Environment - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:52.062 INFO Begin Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:52.075 INFO End Creating process - ExecuteProcess.startSqlPlusProcess
2021-03-09 02:51:52.076 INFO Executing SQL [ BEGIN
DBMS_OUTPUT.PUT_LINE('FAILURE');
END;
/] in [hongkong, container:null] - ExecuteSql$SQLClient.run
2021-03-09 02:51:52.119 INFO Finished check [TEMPTS_ALLOFFLINE][hongkong][PASSED] - CheckTrigger.call
2021-03-09 02:51:52.138 INFO Starting - timestamp_mismatch.fixUpCode
2021-03-09 02:51:52.139 INFO End - timestamp_mismatch.fixUpCode
2021-03-09 02:51:52.145 INFO Finished check [TIMESTAMP_MISMATCH][hongkong][NOT 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
