Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.89722_CLOUD_213639_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-10-15 20:03:56 The following directories are used: CMiC Home: "/opt/cm", as specified in /home/oracle/.cms/cms.conf. Oracle Home: "D:/as10g2/midtier", default value. JSP Oracle Home: "/u01/app/oracle/midtierjsp", as specified in /home/oracle/.cms/cms.conf. Mobile Oracle Home: "/u01/app/oracle/midtiermobile", as specified in /home/oracle/.cms/cms.conf. Oracle Client Home: "/u01/app/oracle/product/19.19/PROD", as specified in /home/oracle/.cms/cms.conf. /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc7.jar /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc6.jar /u01/app/oracle/product/19.19/PROD/jdbc/lib/ojdbc8.jar Connection string: jdbc:oracle:oci:da/********@test Warning: Issue 24.89722, has been installed 1 times on the application server while it is installed 0 times on the database! - File: sql/hik_CDI_create_rti_link_onpremise.sql: __________________________________________________ The new copy of the file "/opt/cm/v12/test/sql/hik_CDI_create_rti_link_onpremise.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/hik_CDI_create_rti_link_onpremise.sql - size (on disk): 24488 bytes - last modified (on disk): 2024-09-19 15:17:26.0 - size (new file): 24488 bytes - last modified (new file): 2024-09-19 15:17:26.0 Warning: The file was not modified. - File: sql/hik_CDI_create_dx_rti_link_onpremise.sql: _____________________________________________________ The new copy of the file "/opt/cm/v12/test/sql/hik_CDI_create_dx_rti_link_onpremise.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/hik_CDI_create_dx_rti_link_onpremise.sql - size (on disk): 24486 bytes - last modified (on disk): 2024-09-19 15:17:26.0 - size (new file): 24486 bytes - last modified (new file): 2024-09-19 15:17:26.0 Warning: The file was not modified. - File: sql/hik_CDITEST_create_dx_rti_link_onpremise.sql: _________________________________________________________ The new copy of the file "/opt/cm/v12/test/sql/hik_CDITEST_create_dx_rti_link_onpremise.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/hik_CDITEST_create_dx_rti_link_onpremise.sql - size (on disk): 24490 bytes - last modified (on disk): 2024-09-19 15:17:26.0 - size (new file): 24490 bytes - last modified (new file): 2024-09-19 15:17:26.0 Warning: The file was not modified. - File: sql/hik2489722.cst: ___________________________ The new copy of the file "/opt/cm/v12/test/sql/hik2489722.cst", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/hik2489722.cst - size (on disk): 1486 bytes - last modified (on disk): 2024-09-19 15:17:26.0 - size (new file): 1486 bytes - last modified (new file): 2024-09-19 15:17:26.0 Warning: The file was not modified. - File: sql/2489722_1.sql: __________________________ The new copy of the file "/opt/cm/v12/test/sql/2489722_1.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/2489722_1.sql - size (on disk): 7685 bytes - last modified (on disk): 2024-09-19 15:17:26.0 - size (new file): 7685 bytes - last modified (new file): 2024-09-19 15:17:26.0 Warning: The file was not modified. - File: sql/hik_CDITEST_create_rti_link_onpremise.sql: ______________________________________________________ The new copy of the file "/opt/cm/v12/test/sql/hik_CDITEST_create_rti_link_onpremise.sql", shipped with the package, is the same as the current copy on disk, and the timestamps on both files are the same! Updating: /opt/cm/v12/test/sql/hik_CDITEST_create_rti_link_onpremise.sql - size (on disk): 24492 bytes - last modified (on disk): 2024-09-19 15:17:26.0 - size (new file): 24492 bytes - last modified (new file): 2024-09-19 15:17:26.0 Warning: The file was not modified. Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-10-15_20_03_56.975/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-10-15_20_03_56.975/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-10-15_20_03_56.975/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:2489722_1.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-10-15_20_03_56.975/2489722_1.sql.sh to run 2489722_1.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-10-15_20_03_56.975/2489722_1.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-10-15_20_03_56.975/2489722_1.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 15 20:04:05 2024 Version 19.23.0.0.0 Copyright (c) 1982, 2023, Oracle. All rights reserved. ************************* * Start of dbdefine.sql * ************************* *********************** * End of dbdefine.sql * *********************** ************************* * Connect as DA * ************************* Connected. *********************** * Connected * *********************** -- ====================================================================== -- Work Order 24.89722, Work Item 1 -- CMiC Pay Request Setup -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2489722_1.sql Output in 2489722_1.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial state of the database -- ====================================================================== BEGIN sys.UTL_RECOMP.recomp_parallel; END; * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 40083 ORA-01654: unable to extend index SYS.I_OPTSTAT_SNAPSHOT$ by 1024 in tablespace SYSTEM ORA-06512: at "SYS.DBMS_STATS", line 1872 ORA-06512: at "SYS.DBMS_STATS", line 39988 ORA-06512: at "SYS.DBMS_STATS", line 40231 ORA-06512: at "SYS.DBMS_STATS", line 40780 ORA-06512: at "SYS.UTL_RECOMP", line 348 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at line 1 Session altered. -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 11,775 INDEX 58,685 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 12,150 TABLE 38,899 TABLE PARTITION 37,625 41 TRIGGER 270 TYPE 22,850 81 VIEW -------- ********** -------- 190,647 sum 123 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 5,438 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 7,047 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 799 JSR PACKAGE 799 PACKAGE BODY 2 SYNONYM 2,901 VIEW -------- ********** -------- 4,501 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 17,686 83 VIEW -------- ********** -------- 17,721 sum 83 8 REPORT_WRI INDEX 1 LOB 55 PACKAGE 55 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 390 9 VIEW -------- ********** -------- 543 sum 9 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 226,057 216 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-10-15 20:04:10 special list (before special recompiling) 2024-10-15 20:04:10 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-10-15 20:04:11 special list (after special recompiling) 2024-10-15 20:04:12 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 11,775 INDEX 58,685 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 12,150 TABLE 38,899 TABLE PARTITION 37,625 41 TRIGGER 270 TYPE 22,850 81 VIEW -------- ********** -------- 190,647 sum 123 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 5,438 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 7,047 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 799 JSR PACKAGE 799 PACKAGE BODY 2 SYNONYM 2,901 VIEW -------- ********** -------- 4,501 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 17,686 83 VIEW -------- ********** -------- 17,721 sum 83 8 REPORT_WRI INDEX 1 LOB 55 PACKAGE 55 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 390 9 VIEW -------- ********** -------- 543 sum 9 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 226,057 216 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DA TRIGGER DBT_AUTO_COLD_STORE_2456605959 DA TRIGGER DBT_I_IUD_ACTIONCODEHATI_FATVI DA TRIGGER DBT_I_IUD_AGIJOBINFOSUTK_FATVI DA TRIGGER DBT_I_IUD_ATABLETESTYHEO_FATVI DA TRIGGER DBT_I_IUD_BIGDATAMARNQZA_FATVI DA TRIGGER DBT_I_IUD_BIGHISTORYNQZA_FATVI DA TRIGGER DBT_I_IUD_BILLINGKPINYLY_FATVI DA TRIGGER DBT_I_IUD_DEFG7BK_FATVIEW DA TRIGGER DBT_I_IUD_DISCOUNTSKN4_FATVIEW DA TRIGGER DBT_I_IUD_EMP401K7JYA_FATVIEW DA TRIGGER DBT_I_IUD_EMPNOTE94IU_FATVIEW DA TRIGGER DBT_I_IUD_EMP_AVAILFLT3_FATVIE DA TRIGGER DBT_I_IUD_EMP_AVAILKOFX_FATVIE DA TRIGGER DBT_I_IUD_FRMINV_LOGFHND_FATVI DA TRIGGER DBT_I_IUD_FRMSOV_LOGFHND_FATVI DA TRIGGER DBT_I_IUD_FULLNAMEP42V_FATVIEW DA TRIGGER DBT_I_IUD_INVRGCODED7JYA_FATVI DA TRIGGER DBT_I_IUD_INVRGCODEDFLT3_FATVI DA TRIGGER DBT_I_IUD_JCCSTTBLP42V_FATVIEW DA TRIGGER DBT_I_IUD_JCESTIMATE2ZFP_FATVI DA TRIGGER DBT_I_IUD_JCESTIMATE7JYA_FATVI DA TRIGGER DBT_I_IUD_JCESTIMATEIMYP_FATVI DA TRIGGER DBT_I_IUD_JCPCNE3J_FATVIEW DA TRIGGER DBT_I_IUD_JCPEOPLEYAL1_FATVIEW DA TRIGGER DBT_I_IUD_MARKETINGNQZA_FATVIE DA TRIGGER DBT_I_IUD_MECTIMENPZ4_FATVIEW DA TRIGGER DBT_I_IUD_MEETINGGP26_FATVIEW DA TRIGGER DBT_I_IUD_NMCPROJYOQ3_FATVIEW DA TRIGGER DBT_I_IUD_SCAINFOSKN4_FATVIEW DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI DA TRIGGER DBT_I_IUD_SUBCONTRCTGP26_FATVI DA TRIGGER DBT_I_IUD_TEST_DUMMYFHND_FATVI DA TRIGGER DBT_I_IUD_TITLE0DKF_FATVIEW DA VIEW UETD_ACTIONCODEHATI_FATVIEW DA VIEW UETD_ACTIONCODEHATI_OUTER_VIEW DA VIEW UETD_ACTIONCODEHATI_VIEW DA VIEW UETD_AGIJOBINFOSUTK_FATVIEW DA VIEW UETD_AGIJOBINFOSUTK_OUTER_VIEW DA VIEW UETD_AGIJOBINFOSUTK_VIEW DA VIEW UETD_ATABLETESTYHEO_FATVIEW DA VIEW UETD_ATABLETESTYHEO_OUTER_VIEW DA VIEW UETD_ATABLETESTYHEO_VIEW DA VIEW UETD_BIGDATAMARNQZA_FATVIEW DA VIEW UETD_BIGDATAMARNQZA_OUTER_VIEW DA VIEW UETD_BIGDATAMARNQZA_VIEW DA VIEW UETD_BIGHISTORYNQZA_FATVIEW DA VIEW UETD_BIGHISTORYNQZA_OUTER_VIEW DA VIEW UETD_BIGHISTORYNQZA_VIEW DA VIEW UETD_BILLINGKPINYLY_FATVIEW DA VIEW UETD_BILLINGKPINYLY_OUTER_VIEW DA VIEW UETD_BILLINGKPINYLY_VIEW DA VIEW UETD_DEFG7BK_FATVIEW DA VIEW UETD_DEFG7BK_OUTER_VIEW DA VIEW UETD_DEFG7BK_VIEW DA VIEW UETD_DISCOUNTSKN4_FATVIEW DA VIEW UETD_DISCOUNTSKN4_OUTER_VIEW DA VIEW UETD_DISCOUNTSKN4_VIEW DA VIEW UETD_EMP401K7JYA_FATVIEW DA VIEW UETD_EMPNOTE94IU_FATVIEW DA VIEW UETD_EMPNOTE94IU_OUTER_VIEW DA VIEW UETD_EMPNOTE94IU_VIEW DA VIEW UETD_EMP_AVAILFLT3_FATVIEW DA VIEW UETD_EMP_AVAILKOFX_FATVIEW DA VIEW UETD_EMP_AVAILKOFX_OUTER_VIEW DA VIEW UETD_EMP_AVAILKOFX_VIEW DA VIEW UETD_FRMINV_LOGFHND_FATVIEW DA VIEW UETD_FRMSOV_LOGFHND_FATVIEW DA VIEW UETD_FRMSOV_LOGFHND_OUTER_VIEW DA VIEW UETD_FRMSOV_LOGFHND_VIEW DA VIEW UETD_FULLNAMEP42V_FATVIEW DA VIEW UETD_FULLNAMEP42V_OUTER_VIEW DA VIEW UETD_FULLNAMEP42V_VIEW DA VIEW UETD_INVRGCODED7JYA_FATVIEW DA VIEW UETD_INVRGCODEDFLT3_FATVIEW DA VIEW UETD_JCCSTTBLP42V_FATVIEW DA VIEW UETD_JCCSTTBLP42V_OUTER_VIEW DA VIEW UETD_JCCSTTBLP42V_VIEW DA VIEW UETD_JCESTIMATE2ZFP_FATVIEW DA VIEW UETD_JCESTIMATE7JYA_FATVIEW DA VIEW UETD_JCESTIMATEIMYP_FATVIEW DA VIEW UETD_JCPCNE3J_FATVIEW DA VIEW UETD_JCPCNE3J_OUTER_VIEW DA VIEW UETD_JCPCNE3J_VIEW DA VIEW UETD_JCPEOPLEYAL1_FATVIEW DA VIEW UETD_JCPEOPLEYAL1_OUTER_VIEW DA VIEW UETD_JCPEOPLEYAL1_VIEW DA VIEW UETD_MARKETINGNQZA_FATVIEW DA VIEW UETD_MARKETINGNQZA_OUTER_VIEW DA VIEW UETD_MARKETINGNQZA_VIEW DA VIEW UETD_MECTIMENPZ4_FATVIEW DA VIEW UETD_MECTIMENPZ4_OUTER_VIEW DA VIEW UETD_MECTIMENPZ4_VIEW DA VIEW UETD_MEETINGGP26_FATVIEW DA VIEW UETD_MEETINGGP26_OUTER_VIEW DA VIEW UETD_MEETINGGP26_VIEW DA VIEW UETD_NMCPROJYOQ3_FATVIEW DA VIEW UETD_NMCPROJYOQ3_OUTER_VIEW DA VIEW UETD_NMCPROJYOQ3_VIEW DA VIEW UETD_SCAINFOSKN4_FATVIEW DA VIEW UETD_SCAINFOSKN4_OUTER_VIEW DA VIEW UETD_SCAINFOSKN4_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_VIEW DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW DA VIEW UETD_SLC_TAXREFDKRE_VIEW DA VIEW UETD_SUBCONTRCTGP26_FATVIEW DA VIEW UETD_SUBCONTRCTGP26_OUTER_VIEW DA VIEW UETD_SUBCONTRCTGP26_VIEW DA VIEW UETD_TEST_DUMMYFHND_FATVIEW DA VIEW UETD_TITLE0DKF_FATVIEW DA VIEW UETD_TITLE0DKF_OUTER_VIEW DA VIEW UETD_TITLE0DKF_VIEW DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V REPORT_WRI VIEW FIL_JBBACKUP_TOP_UP_DETAIL REPORT_WRI VIEW FIL_JBBACKUP_TRANS_GROUPS REPORT_WRI VIEW FIL_JBBACKUP_TRANS_GROUPS_X REPORT_WRI VIEW FIL_JBBACKUP_TRANS_VENDORS REPORT_WRI VIEW FIL_JBBACKUP_TRANS_VENDORS_X REPORT_WRI VIEW FIL_JBBU_JBBACKUP_TRANS_VENDS REPORT_WRI VIEW FIL_JBBU_JBBACKUP_TRAN_GROUPS REPORT_WRI VIEW JSR_JBBU_LNK_CONTRACT_FIL REPORT_WRI VIEW JSR_JBBU_LNK_VENDOR_FIL =================================================================== DB=test A_TEST01 15-OCT-24 08.04.13.653843 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-05 SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Create Sequences -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== -- ====================================================================== -- Install Indexes -- ====================================================================== -- ====================================================================== -- Install VWT files or Create Synonyms for TN tables -- ====================================================================== -- ====================================================================== -- Register Table-Packages and Rebuild Automatically Created Packages -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- Install or Update System Data -- ====================================================================== old 1: select lower('&&client_code') || '_create_op_gcs_' || lower('&&rti_softwaresystem') || '_rti_link.lst' spool_file new 1: select lower('CDI') || '_create_op_gcs_' || lower('DX') || '_rti_link.lst' spool_file old 162: t_ss_name varchar2(10) := upper('&&rti_softwaresystem'); new 162: t_ss_name varchar2(10) := upper('DX'); old 177: if upper('&&client_code') is null and upper('&&setup_all_clients') = 'Y' then new 177: if upper('CDI') is null and upper('N') = 'Y' then old 181: elsif upper('&&client_code') is null and upper('&&setup_all_clients') = 'N' then new 181: elsif upper('CDI') is null and upper('N') = 'N' then old 184: t_client_code := upper('&&client_code'); new 184: t_client_code := upper('CDI'); Querying client with no RTI link old 1: select lower('&&client_code') || '_create_op_gcs_' || lower('&&rti_softwaresystem') || '_rti_link.lst' spool_file new 1: select lower('CDI') || '_create_op_gcs_' || lower('GCS') || '_rti_link.lst' spool_file old 162: t_ss_name varchar2(10) := upper('&&rti_softwaresystem'); new 162: t_ss_name varchar2(10) := upper('GCS'); old 177: if upper('&&client_code') is null and upper('&&setup_all_clients') = 'Y' then new 177: if upper('CDI') is null and upper('N') = 'Y' then old 181: elsif upper('&&client_code') is null and upper('&&setup_all_clients') = 'N' then new 181: elsif upper('CDI') is null and upper('N') = 'N' then old 184: t_client_code := upper('&&client_code'); new 184: t_client_code := upper('CDI'); Querying client with no RTI link old 1: select lower('&&client_code') || '_create_op_gcs_' || lower('&&rti_softwaresystem') || '_rti_link.lst' spool_file new 1: select lower('CDITEST') || '_create_op_gcs_' || lower('DX') || '_rti_link.lst' spool_file old 162: t_ss_name varchar2(10) := upper('&&rti_softwaresystem'); new 162: t_ss_name varchar2(10) := upper('DX'); old 177: if upper('&&client_code') is null and upper('&&setup_all_clients') = 'Y' then new 177: if upper('CDITEST') is null and upper('N') = 'Y' then old 181: elsif upper('&&client_code') is null and upper('&&setup_all_clients') = 'N' then new 181: elsif upper('CDITEST') is null and upper('N') = 'N' then old 184: t_client_code := upper('&&client_code'); new 184: t_client_code := upper('CDITEST'); Querying client with no RTI link old 1: select lower('&&client_code') || '_create_op_gcs_' || lower('&&rti_softwaresystem') || '_rti_link.lst' spool_file new 1: select lower('CDITEST') || '_create_op_gcs_' || lower('GCS') || '_rti_link.lst' spool_file old 162: t_ss_name varchar2(10) := upper('&&rti_softwaresystem'); new 162: t_ss_name varchar2(10) := upper('GCS'); old 177: if upper('&&client_code') is null and upper('&&setup_all_clients') = 'Y' then new 177: if upper('CDITEST') is null and upper('N') = 'Y' then old 181: elsif upper('&&client_code') is null and upper('&&setup_all_clients') = 'N' then new 181: elsif upper('CDITEST') is null and upper('N') = 'N' then old 184: t_client_code := upper('&&client_code'); new 184: t_client_code := upper('CDITEST'); Querying client with no RTI link -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== -- ====================================================================== -- Get the current State of the Database -- ====================================================================== BEGIN sys.UTL_RECOMP.recomp_parallel; END; * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-06512: at "SYS.UTL_RECOMP", line 927 ORA-06512: at "SYS.DBMS_STATS", line 40799 ORA-06512: at "SYS.DBMS_STATS", line 40083 ORA-01654: unable to extend index SYS.I_OPTSTAT_SNAPSHOT$ by 1024 in tablespace SYSTEM ORA-06512: at "SYS.DBMS_STATS", line 1872 ORA-06512: at "SYS.DBMS_STATS", line 39988 ORA-06512: at "SYS.DBMS_STATS", line 40231 ORA-06512: at "SYS.DBMS_STATS", line 40780 ORA-06512: at "SYS.UTL_RECOMP", line 348 ORA-06512: at "SYS.UTL_RECOMP", line 830 ORA-06512: at line 1 -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 11,775 INDEX 58,685 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 12,150 TABLE 38,899 TABLE PARTITION 37,625 41 TRIGGER 270 TYPE 22,850 81 VIEW -------- ********** -------- 190,647 sum 123 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 5,438 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 7,047 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 799 JSR PACKAGE 799 PACKAGE BODY 2 SYNONYM 2,901 VIEW -------- ********** -------- 4,501 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 17,686 83 VIEW -------- ********** -------- 17,721 sum 83 8 REPORT_WRI INDEX 1 LOB 55 PACKAGE 55 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 390 9 VIEW -------- ********** -------- 543 sum 9 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 226,057 216 =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ====================================================================== == Re-compiling invalid objects for "FMWW" ====================================================================== start additional_compx.sql 2024-10-15 20:04:18 special list (before special recompiling) 2024-10-15 20:04:18 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-10-15 20:04:19 special list (after special recompiling) 2024-10-15 20:04:19 end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== 2 CMIC_BI PACKAGE 2 PACKAGE BODY 1 SYNONYM 123 VIEW -------- ********** -------- 128 sum 9 DA FUNCTION 11,775 INDEX 58,685 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,161 PACKAGE 3,154 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,548 SYNONYM 12,150 TABLE 38,899 TABLE PARTITION 37,625 41 TRIGGER 270 TYPE 22,850 81 VIEW -------- ********** -------- 190,647 sum 123 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 5,438 SYNONYM 2 TABLE 390 1 TRIGGER 1,204 VIEW -------- ********** -------- 7,047 sum 1 230 JS80 INDEX 19 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 19 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 425 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 799 JSR PACKAGE 799 PACKAGE BODY 2 SYNONYM 2,901 VIEW -------- ********** -------- 4,501 sum 14 OWF_MGR EVALUATION CONTEXT 276 INDEX 52 LOB 151 PACKAGE 146 PACKAGE BODY 1 PROCEDURE 34 QUEUE 11 RULE 39 RULE SET 30 SEQUENCE 193 TABLE 4 TYPE 3 TYPE BODY 100 VIEW -------- ********** -------- 1,054 sum 1 REPORT_VIE PACKAGE 1 PACKAGE BODY 33 SYNONYM 17,686 83 VIEW -------- ********** -------- 17,721 sum 83 8 REPORT_WRI INDEX 1 LOB 55 PACKAGE 55 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 390 9 VIEW -------- ********** -------- 543 sum 9 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 147 INDEX PARTITION 74 LOB 147 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 51 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,854 sum -------- -------- 226,057 216 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTI_UETD_CHKDIST24RM_OBJSEQ DA TRIGGER DBTI_UETD_CHKDIST39KQ_OBJSEQ DA TRIGGER DBTI_UETD_CHKDISTYOQ3_OBJSEQ DA TRIGGER DBTI_UETD_EMP401KG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DA TRIGGER DBT_AUTO_COLD_STORE_2456605959 DA TRIGGER DBT_I_IUD_ACTIONCODEHATI_FATVI DA TRIGGER DBT_I_IUD_AGIJOBINFOSUTK_FATVI DA TRIGGER DBT_I_IUD_ATABLETESTYHEO_FATVI DA TRIGGER DBT_I_IUD_BIGDATAMARNQZA_FATVI DA TRIGGER DBT_I_IUD_BIGHISTORYNQZA_FATVI DA TRIGGER DBT_I_IUD_BILLINGKPINYLY_FATVI DA TRIGGER DBT_I_IUD_DEFG7BK_FATVIEW DA TRIGGER DBT_I_IUD_DISCOUNTSKN4_FATVIEW DA TRIGGER DBT_I_IUD_EMP401K7JYA_FATVIEW DA TRIGGER DBT_I_IUD_EMPNOTE94IU_FATVIEW DA TRIGGER DBT_I_IUD_EMP_AVAILFLT3_FATVIE DA TRIGGER DBT_I_IUD_EMP_AVAILKOFX_FATVIE DA TRIGGER DBT_I_IUD_FRMINV_LOGFHND_FATVI DA TRIGGER DBT_I_IUD_FRMSOV_LOGFHND_FATVI DA TRIGGER DBT_I_IUD_FULLNAMEP42V_FATVIEW DA TRIGGER DBT_I_IUD_INVRGCODED7JYA_FATVI DA TRIGGER DBT_I_IUD_INVRGCODEDFLT3_FATVI DA TRIGGER DBT_I_IUD_JCCSTTBLP42V_FATVIEW DA TRIGGER DBT_I_IUD_JCESTIMATE2ZFP_FATVI DA TRIGGER DBT_I_IUD_JCESTIMATE7JYA_FATVI DA TRIGGER DBT_I_IUD_JCESTIMATEIMYP_FATVI DA TRIGGER DBT_I_IUD_JCPCNE3J_FATVIEW DA TRIGGER DBT_I_IUD_JCPEOPLEYAL1_FATVIEW DA TRIGGER DBT_I_IUD_MARKETINGNQZA_FATVIE DA TRIGGER DBT_I_IUD_MECTIMENPZ4_FATVIEW DA TRIGGER DBT_I_IUD_MEETINGGP26_FATVIEW DA TRIGGER DBT_I_IUD_NMCPROJYOQ3_FATVIEW DA TRIGGER DBT_I_IUD_SCAINFOSKN4_FATVIEW DA TRIGGER DBT_I_IUD_SLC_ARTAXRDKRE_FATVI DA TRIGGER DBT_I_IUD_SLC_TAXREFDKRE_FATVI DA TRIGGER DBT_I_IUD_SUBCONTRCTGP26_FATVI DA TRIGGER DBT_I_IUD_TEST_DUMMYFHND_FATVI DA TRIGGER DBT_I_IUD_TITLE0DKF_FATVIEW DA VIEW UETD_ACTIONCODEHATI_FATVIEW DA VIEW UETD_ACTIONCODEHATI_OUTER_VIEW DA VIEW UETD_ACTIONCODEHATI_VIEW DA VIEW UETD_AGIJOBINFOSUTK_FATVIEW DA VIEW UETD_AGIJOBINFOSUTK_OUTER_VIEW DA VIEW UETD_AGIJOBINFOSUTK_VIEW DA VIEW UETD_ATABLETESTYHEO_FATVIEW DA VIEW UETD_ATABLETESTYHEO_OUTER_VIEW DA VIEW UETD_ATABLETESTYHEO_VIEW DA VIEW UETD_BIGDATAMARNQZA_FATVIEW DA VIEW UETD_BIGDATAMARNQZA_OUTER_VIEW DA VIEW UETD_BIGDATAMARNQZA_VIEW DA VIEW UETD_BIGHISTORYNQZA_FATVIEW DA VIEW UETD_BIGHISTORYNQZA_OUTER_VIEW DA VIEW UETD_BIGHISTORYNQZA_VIEW DA VIEW UETD_BILLINGKPINYLY_FATVIEW DA VIEW UETD_BILLINGKPINYLY_OUTER_VIEW DA VIEW UETD_BILLINGKPINYLY_VIEW DA VIEW UETD_DEFG7BK_FATVIEW DA VIEW UETD_DEFG7BK_OUTER_VIEW DA VIEW UETD_DEFG7BK_VIEW DA VIEW UETD_DISCOUNTSKN4_FATVIEW DA VIEW UETD_DISCOUNTSKN4_OUTER_VIEW DA VIEW UETD_DISCOUNTSKN4_VIEW DA VIEW UETD_EMP401K7JYA_FATVIEW DA VIEW UETD_EMPNOTE94IU_FATVIEW DA VIEW UETD_EMPNOTE94IU_OUTER_VIEW DA VIEW UETD_EMPNOTE94IU_VIEW DA VIEW UETD_EMP_AVAILFLT3_FATVIEW DA VIEW UETD_EMP_AVAILKOFX_FATVIEW DA VIEW UETD_EMP_AVAILKOFX_OUTER_VIEW DA VIEW UETD_EMP_AVAILKOFX_VIEW DA VIEW UETD_FRMINV_LOGFHND_FATVIEW DA VIEW UETD_FRMSOV_LOGFHND_FATVIEW DA VIEW UETD_FRMSOV_LOGFHND_OUTER_VIEW DA VIEW UETD_FRMSOV_LOGFHND_VIEW DA VIEW UETD_FULLNAMEP42V_FATVIEW DA VIEW UETD_FULLNAMEP42V_OUTER_VIEW DA VIEW UETD_FULLNAMEP42V_VIEW DA VIEW UETD_INVRGCODED7JYA_FATVIEW DA VIEW UETD_INVRGCODEDFLT3_FATVIEW DA VIEW UETD_JCCSTTBLP42V_FATVIEW DA VIEW UETD_JCCSTTBLP42V_OUTER_VIEW DA VIEW UETD_JCCSTTBLP42V_VIEW DA VIEW UETD_JCESTIMATE2ZFP_FATVIEW DA VIEW UETD_JCESTIMATE7JYA_FATVIEW DA VIEW UETD_JCESTIMATEIMYP_FATVIEW DA VIEW UETD_JCPCNE3J_FATVIEW DA VIEW UETD_JCPCNE3J_OUTER_VIEW DA VIEW UETD_JCPCNE3J_VIEW DA VIEW UETD_JCPEOPLEYAL1_FATVIEW DA VIEW UETD_JCPEOPLEYAL1_OUTER_VIEW DA VIEW UETD_JCPEOPLEYAL1_VIEW DA VIEW UETD_MARKETINGNQZA_FATVIEW DA VIEW UETD_MARKETINGNQZA_OUTER_VIEW DA VIEW UETD_MARKETINGNQZA_VIEW DA VIEW UETD_MECTIMENPZ4_FATVIEW DA VIEW UETD_MECTIMENPZ4_OUTER_VIEW DA VIEW UETD_MECTIMENPZ4_VIEW DA VIEW UETD_MEETINGGP26_FATVIEW DA VIEW UETD_MEETINGGP26_OUTER_VIEW DA VIEW UETD_MEETINGGP26_VIEW DA VIEW UETD_NMCPROJYOQ3_FATVIEW DA VIEW UETD_NMCPROJYOQ3_OUTER_VIEW DA VIEW UETD_NMCPROJYOQ3_VIEW DA VIEW UETD_SCAINFOSKN4_FATVIEW DA VIEW UETD_SCAINFOSKN4_OUTER_VIEW DA VIEW UETD_SCAINFOSKN4_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_FATVIEW DA VIEW UETD_SLC_ARTAXRDKRE_OUTER_VIEW DA VIEW UETD_SLC_ARTAXRDKRE_VIEW DA VIEW UETD_SLC_TAXREFDKRE_FATVIEW DA VIEW UETD_SLC_TAXREFDKRE_OUTER_VIEW DA VIEW UETD_SLC_TAXREFDKRE_VIEW DA VIEW UETD_SUBCONTRCTGP26_FATVIEW DA VIEW UETD_SUBCONTRCTGP26_OUTER_VIEW DA VIEW UETD_SUBCONTRCTGP26_VIEW DA VIEW UETD_TEST_DUMMYFHND_FATVIEW DA VIEW UETD_TITLE0DKF_FATVIEW DA VIEW UETD_TITLE0DKF_OUTER_VIEW DA VIEW UETD_TITLE0DKF_VIEW DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V REPORT_WRI VIEW FIL_JBBACKUP_TOP_UP_DETAIL REPORT_WRI VIEW FIL_JBBACKUP_TRANS_GROUPS REPORT_WRI VIEW FIL_JBBACKUP_TRANS_GROUPS_X REPORT_WRI VIEW FIL_JBBACKUP_TRANS_VENDORS REPORT_WRI VIEW FIL_JBBACKUP_TRANS_VENDORS_X REPORT_WRI VIEW FIL_JBBU_JBBACKUP_TRANS_VENDS REPORT_WRI VIEW FIL_JBBU_JBBACKUP_TRAN_GROUPS REPORT_WRI VIEW JSR_JBBU_LNK_CONTRACT_FIL REPORT_WRI VIEW JSR_JBBU_LNK_VENDOR_FIL =================================================================== DB=test A_TEST01 15-OCT-24 08.04.21.338489 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-05 SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2489722_1.sql completed. Output in 2489722_1.LST -- ====================================================================== not spooling currently Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.89722 was successfully installed, but with warnings. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 0 Warning Errors: 0 Informative Errors: 24 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 186 | * 187 | ERROR at line 1: 188 | ORA-00604: error occurred at recursive SQL level 1 189 | ORA-06512: at "SYS.UTL_RECOMP", line 927 187 | ERROR at line 1: 188 | ORA-00604: error occurred at recursive SQL level 1 189 | ORA-06512: at "SYS.UTL_RECOMP", line 927 190 | ORA-06512: at "SYS.DBMS_STATS", line 40799 188 | ORA-00604: error occurred at recursive SQL level 1 189 | ORA-06512: at "SYS.UTL_RECOMP", line 927 190 | ORA-06512: at "SYS.DBMS_STATS", line 40799 191 | ORA-06512: at "SYS.DBMS_STATS", line 40083 189 | ORA-06512: at "SYS.UTL_RECOMP", line 927 190 | ORA-06512: at "SYS.DBMS_STATS", line 40799 191 | ORA-06512: at "SYS.DBMS_STATS", line 40083 192 | ORA-01654: unable to extend index SYS.I_OPTSTAT_SNAPSHOT$ by 1024 in tablespace SYSTEM 190 | ORA-06512: at "SYS.DBMS_STATS", line 40799 191 | ORA-06512: at "SYS.DBMS_STATS", line 40083 192 | ORA-01654: unable to extend index SYS.I_OPTSTAT_SNAPSHOT$ by 1024 in tablespace SYSTEM 193 | ORA-06512: at "SYS.DBMS_STATS", line 1872 191 | ORA-06512: at "SYS.DBMS_STATS", line 40083 192 | ORA-01654: unable to extend index SYS.I_OPTSTAT_SNAPSHOT$ by 1024 in tablespace SYSTEM 193 | ORA-06512: at "SYS.DBMS_STATS", line 1872 194 | ORA-06512: at "SYS.DBMS_STATS", line 39988 192 | ORA-01654: unable to extend index SYS.I_OPTSTAT_SNAPSHOT$ by 1024 in tablespace SYSTEM 193 | ORA-06512: at "SYS.DBMS_STATS", line 1872 194 | ORA-06512: at "SYS.DBMS_STATS", line 39988 195 | ORA-06512: at "SYS.DBMS_STATS", line 40231 193 | ORA-06512: at "SYS.DBMS_STATS", line 1872 194 | ORA-06512: at "SYS.DBMS_STATS", line 39988 195 | ORA-06512: at "SYS.DBMS_STATS", line 40231 196 | ORA-06512: at "SYS.DBMS_STATS", line 40780 194 | ORA-06512: at "SYS.DBMS_STATS", line 39988 195 | ORA-06512: at "SYS.DBMS_STATS", line 40231 196 | ORA-06512: at "SYS.DBMS_STATS", line 40780 197 | ORA-06512: at "SYS.UTL_RECOMP", line 348 195 | ORA-06512: at "SYS.DBMS_STATS", line 40231 196 | ORA-06512: at "SYS.DBMS_STATS", line 40780 197 | ORA-06512: at "SYS.UTL_RECOMP", line 348 198 | ORA-06512: at "SYS.UTL_RECOMP", line 830 196 | ORA-06512: at "SYS.DBMS_STATS", line 40780 197 | ORA-06512: at "SYS.UTL_RECOMP", line 348 198 | ORA-06512: at "SYS.UTL_RECOMP", line 830 199 | ORA-06512: at line 1 197 | ORA-06512: at "SYS.UTL_RECOMP", line 348 198 | ORA-06512: at "SYS.UTL_RECOMP", line 830 199 | ORA-06512: at line 1 200 | 778 | * 779 | ERROR at line 1: 780 | ORA-00604: error occurred at recursive SQL level 1 781 | ORA-06512: at "SYS.UTL_RECOMP", line 927 779 | ERROR at line 1: 780 | ORA-00604: error occurred at recursive SQL level 1 781 | ORA-06512: at "SYS.UTL_RECOMP", line 927 782 | ORA-06512: at "SYS.DBMS_STATS", line 40799 780 | ORA-00604: error occurred at recursive SQL level 1 781 | ORA-06512: at "SYS.UTL_RECOMP", line 927 782 | ORA-06512: at "SYS.DBMS_STATS", line 40799 783 | ORA-06512: at "SYS.DBMS_STATS", line 40083 781 | ORA-06512: at "SYS.UTL_RECOMP", line 927 782 | ORA-06512: at "SYS.DBMS_STATS", line 40799 783 | ORA-06512: at "SYS.DBMS_STATS", line 40083 784 | ORA-01654: unable to extend index SYS.I_OPTSTAT_SNAPSHOT$ by 1024 in tablespace SYSTEM 782 | ORA-06512: at "SYS.DBMS_STATS", line 40799 783 | ORA-06512: at "SYS.DBMS_STATS", line 40083 784 | ORA-01654: unable to extend index SYS.I_OPTSTAT_SNAPSHOT$ by 1024 in tablespace SYSTEM 785 | ORA-06512: at "SYS.DBMS_STATS", line 1872 783 | ORA-06512: at "SYS.DBMS_STATS", line 40083 784 | ORA-01654: unable to extend index SYS.I_OPTSTAT_SNAPSHOT$ by 1024 in tablespace SYSTEM 785 | ORA-06512: at "SYS.DBMS_STATS", line 1872 786 | ORA-06512: at "SYS.DBMS_STATS", line 39988 784 | ORA-01654: unable to extend index SYS.I_OPTSTAT_SNAPSHOT$ by 1024 in tablespace SYSTEM 785 | ORA-06512: at "SYS.DBMS_STATS", line 1872 786 | ORA-06512: at "SYS.DBMS_STATS", line 39988 787 | ORA-06512: at "SYS.DBMS_STATS", line 40231 785 | ORA-06512: at "SYS.DBMS_STATS", line 1872 786 | ORA-06512: at "SYS.DBMS_STATS", line 39988 787 | ORA-06512: at "SYS.DBMS_STATS", line 40231 788 | ORA-06512: at "SYS.DBMS_STATS", line 40780 786 | ORA-06512: at "SYS.DBMS_STATS", line 39988 787 | ORA-06512: at "SYS.DBMS_STATS", line 40231 788 | ORA-06512: at "SYS.DBMS_STATS", line 40780 789 | ORA-06512: at "SYS.UTL_RECOMP", line 348 787 | ORA-06512: at "SYS.DBMS_STATS", line 40231 788 | ORA-06512: at "SYS.DBMS_STATS", line 40780 789 | ORA-06512: at "SYS.UTL_RECOMP", line 348 790 | ORA-06512: at "SYS.UTL_RECOMP", line 830 788 | ORA-06512: at "SYS.DBMS_STATS", line 40780 789 | ORA-06512: at "SYS.UTL_RECOMP", line 348 790 | ORA-06512: at "SYS.UTL_RECOMP", line 830 791 | ORA-06512: at line 1 789 | ORA-06512: at "SYS.UTL_RECOMP", line 348 790 | ORA-06512: at "SYS.UTL_RECOMP", line 830 791 | ORA-06512: at line 1 792 | =============================== End of Installation Log Review ===============================