Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/test/1_hotfix_test/24.87654_CLOUD_370171_install_1_install.sh Client home /u01/app/oracle/product/19.19/PROD You specified version v12 Installation started at: 2024-07-26 16:57:24 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 - File: sql/2487654_4.sql: __________________________ Updating: /opt/cm/v12/test/sql/2487654_4.sql - This is a new file, no information available on disk - size (new file): 13463 bytes - last modified (new file): 2024-07-26 16:20:48.0 - File: sql/2487654_3.sql: __________________________ Updating: /opt/cm/v12/test/sql/2487654_3.sql - This is a new file, no information available on disk - size (new file): 12010 bytes - last modified (new file): 2024-07-26 16:07:58.0 Entryname Update:appospay.pb@sql - File: sql/appospay.pb: ________________________ Updating: /opt/cm/v12/test/sql/appospay.pb - size (on disk): 783178 bytes - last modified (on disk): 2024-06-18 12:14:06.0 -project (on disk): ERPV120192HF-CLD-02_V12 - version (on disk): 183811 - size (new file): 822358 bytes - last modified (new file): 2024-07-26 16:10:02.0 -project (new file): C_GEN_V12 - version (new file): 1.4 Entryname Update:apchqprt.pb@sql - File: sql/apchqprt.pb: ________________________ Updating: /opt/cm/v12/test/sql/apchqprt.pb - size (on disk): 4215662 bytes - last modified (on disk): 2024-06-24 13:04:04.0 -project (on disk): ERPV120192HF-CLD-02_V12 - version (on disk): 184301 - size (new file): 4442854 bytes - last modified (new file): 2024-07-26 16:17:40.0 -project (new file): C_GEN_V12 - version (new file): 1.14 Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-26_16_57_26.923/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/test/1_hotfix_test/install_2024-07-26_16_57_26.923/tempPtfcompx.sql" File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-26_16_57_26.923/PTFCompX.sh Running dir /opt/cm/v12/test/sql The number of groups of SQL scripts 3 The group 0 entry Name Update:2487654_3.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-26_16_57_26.923/2487654_3.sql.sh to run 2487654_3.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-26_16_57_26.923/2487654_3.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-07-26_16_57_26.923/2487654_3.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 26 16:58:35 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.87654, Work Item 3 -- New Bank Setup -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2487654_3.sql Output in 2487654_3.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial state of the database -- ====================================================================== PL/SQL procedure successfully completed. 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 7,627 INDEX 52,452 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,996 TABLE 34,839 TABLE PARTITION 20,837 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,780 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 23 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 23 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 433 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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 6,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 156 INDEX PARTITION 74 LOB 156 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 54 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,875 sum -------- -------- 162,653 46 =================================================== =================================================================================== == 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-07-26 16:59:16 special list (before special recompiling) 2024-07-26 16:59:20 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-26 16:59:30 special list (after special recompiling) 2024-07-26 16:59:33 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 7,627 INDEX 52,452 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,996 TABLE 34,839 TABLE PARTITION 20,837 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,780 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 23 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 23 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 433 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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 6,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 156 INDEX PARTITION 74 LOB 156 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 54 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,875 sum -------- -------- 162,653 46 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ 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_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 26-JUL-24 04.59.40.783665 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j 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 -- ====================================================================== ======================================================= package body dbk_ap_pospay ======================================================= Warning: Package Body created with compilation errors. Errors for PACKAGE BODY DA.DBK_AP_POSPAY: 0/0 ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT -- ====================================================================== -- Install or Update System Data -- ====================================================================== ========================================================================== System Data - Process ========================================================================== ================================================================ Dropping Temporary TABLES ================================================================ drop table TMP_SDCODES * ERROR at line 1: ORA-00942: table or view does not exist drop table TMP_SDDATA * ERROR at line 1: ORA-00942: table or view does not exist ================================================================ Creating Temporary TABLES ================================================================ Table created. Table created. ================================================================ Creating Temporary INDEXES ================================================================ Index created. Index created. ================================================================ PROCESSING table da.SDCODES ================================================================ 1 row created. ====================================================== Update da.SDCODES ====================================================== 0 rows updated. Commit complete. ====================================================== Insert da.SDCODES ====================================================== 1 row created. Commit complete. ================================================================ PROCESSING table da.SDDATA ================================================================ 1 row created. ====================================================== Update da.SDDATA ====================================================== 0 rows updated. Commit complete. ====================================================== Insert da.SDDATA ====================================================== 1 row created. Commit complete. ================================================================ Dropping Temporary TABLES ================================================================ Table dropped. Table dropped. ========================================================================== System Data processed ========================================================================== -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the current State of the Database -- ====================================================================== PL/SQL procedure successfully completed. 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 7,627 INDEX 52,452 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 1 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,996 TABLE 34,839 TABLE PARTITION 20,837 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,780 sum 17 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 23 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 23 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 433 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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 6,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 156 INDEX PARTITION 74 LOB 156 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 54 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,875 sum -------- -------- 162,653 47 =================================================== =================================================================================== == 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-07-26 17:02:20 special list (before special recompiling) 2024-07-26 17:03:00 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-26 17:03:37 special list (after special recompiling) 2024-07-26 17:04:23 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 7,627 INDEX 52,452 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,996 TABLE 34,839 TABLE PARTITION 20,837 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,780 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 23 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 23 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 433 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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 6,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 156 INDEX PARTITION 74 LOB 156 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 54 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,875 sum -------- -------- 162,653 46 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ 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_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 26-JUL-24 05.05.02.849475 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j SVN Release -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- 2487654_3.sql completed. Output in 2487654_3.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 entry Name Update:2487654_4.sql@sql Using the script: /opt/cm/v12/test/1_hotfix_test/install_2024-07-26_16_57_26.923/2487654_4.sql.sh to run 2487654_4.sql File to exec /opt/cm/v12/test/1_hotfix_test/install_2024-07-26_16_57_26.923/2487654_4.sql.sh Running dir /opt/cm/v12/test/sql Start execution of command /opt/cm/v12/test/1_hotfix_test/install_2024-07-26_16_57_26.923/2487654_4.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Fri Jul 26 17:05:06 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.87654, Work Item 4 -- New Bank Setup -- ====================================================================== ERRORtput: No value for $TERM and no -T specified USER is "DA" test USER is "DA" test USER is "DA" test -- ====================================================================== -- Started 2487654_4.sql Output in 2487654_4.lst -- ====================================================================== -- ====================================================================== -- Turn Patch Flag ON -- ====================================================================== PL/SQL procedure successfully completed. -- ====================================================================== -- Get the initial state of the database -- ====================================================================== PL/SQL procedure successfully completed. 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 7,627 INDEX 52,452 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,996 TABLE 34,839 TABLE PARTITION 20,837 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,780 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 23 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 23 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 433 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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 6,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 156 INDEX PARTITION 74 LOB 156 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 54 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,875 sum -------- -------- 162,653 46 =================================================== =================================================================================== == 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-07-26 17:05:59 special list (before special recompiling) 2024-07-26 17:06:08 t_in1p=0 t_in2p=0 t_errp=0 . t_in1d=0 t_in2d=0 t_errd=0 2024-07-26 17:06:21 special list (after special recompiling) 2024-07-26 17:06:33 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 7,627 INDEX 52,452 INDEX PARTITION 56 JOB 259 LOB 1 MATERIALIZED VIEW 3,156 PACKAGE 3,149 PACKAGE BODY 24 1 PROCEDURE 5 QUEUE 176 SEQUENCE 1,551 SYNONYM 7,996 TABLE 34,839 TABLE PARTITION 20,837 15 TRIGGER 266 TYPE 10,377 VIEW -------- ********** -------- 142,780 sum 16 3 DAR INDEX 1 LOB 4 PACKAGE 4 PACKAGE BODY 1 SEQUENCE 1,294 SYNONYM 2 TABLE 391 1 TRIGGER 1,205 VIEW -------- ********** -------- 2,905 sum 1 230 JS80 INDEX 23 INDEX PARTITION 22 LOB 1 SEQUENCE 2 SYNONYM 122 TABLE 23 TABLE PARTITION 5 TRIGGER 5 VIEW -------- ********** -------- 433 sum 6 JSD PACKAGE 6 PACKAGE BODY 1 SYNONYM 124 VIEW -------- ********** -------- 137 sum 798 JSR PACKAGE 798 PACKAGE BODY 2 SYNONYM 2,893 VIEW -------- ********** -------- 4,491 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 6,277 29 VIEW -------- ********** -------- 6,312 sum 29 8 REPORT_WRI INDEX 1 LOB 54 PACKAGE 54 PACKAGE BODY 1 PROCEDURE 7 SYNONYM 18 TABLE 8 TYPE 387 VIEW -------- ********** -------- 538 sum 1 UIG DATABASE LINK 3 EVALUATION CONTEXT 1,140 INDEX 156 INDEX PARTITION 74 LOB 156 LOB PARTITION 322 PACKAGE 320 PACKAGE BODY 6 QUEUE 30 RULE 36 RULE SET 15 SEQUENCE 39 SYNONYM 287 TABLE 54 TABLE PARTITION 800 TRIGGER 21 TYPE 415 VIEW -------- ********** -------- 3,875 sum -------- -------- 162,653 46 ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== DA PROCEDURE GENERATE_EMP_LIST_FOR_LICENSE DA TRIGGER DBTI_UETD_CCP_LOGFHND_OBJSEQ 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_FRMDEL_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_FRMINV_LOGFHND_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATE2ZFP_OBJSE DA TRIGGER DBTI_UETD_JCESTIMATEIMYP_OBJSE DA TRIGGER DBTI_UETD_PM_INFOG7BK_OBJSEQ DA TRIGGER DBTI_UETD_SCPRELIM6FA5_OBJSEQ DA TRIGGER DBTI_UETD_TESTNL1G7BK_OBJSEQ DA TRIGGER DBTI_UETD_TEST_DUMMYFHND_OBJSE DA TRIGGER DBT_AUTO_COLD_STORE_1389320892 DA TRIGGER DBT_AUTO_COLD_STORE_1389363935 DAR TRIGGER DBT_I_IUD_HRAPPLICANTS_ADMS_V =================================================================== DB=test A_TEST01 26-JUL-24 05.06.44.564198 PM -04:00 Flag value=V DBK_patch_flag.show_flag=V.null CMiC CLOUD R12 - V12-019-2-HF-CLD-02j 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 -- ====================================================================== ======================================================= package body dbk_ap_chqprt ======================================================= ERROR: ORA-03114: not connected to ORACLE CREATE OR REPLACE PACKAGE BODY DA.dbk_ap_chqprt AS * ERROR at line 1: ORA-00028: your session has been killed ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE -- ====================================================================== -- Install or Update System Data -- ====================================================================== .========================================================= . Dropping Temporary TABLES .========================================================= ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE .========================================================= . Creating Temporary TABLES .========================================================= ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE .========================================================= . PROCESSING table da.SDCODES .=TMP===================================================== ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE .=UPDATE================================================== ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE .=INSERT================================================== ERROR: ORA-03114: not connected to ORACLE .========================================================= ERROR: ORA-03114: not connected to ORACLE .========================================================= . PROCESSED table DA.SDCODES .========================================================= .========================================================= . PROCESSING table DA.SDDATA .========================================================= ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE .=UPDATE=================================================== ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE .=INSERT=================================================== ERROR: ORA-03114: not connected to ORACLE .========================================================= ERROR: ORA-03114: not connected to ORACLE .========================================================= . PROCESSED table DA.SDDATA .========================================================= .========================================================= . Dropping Temporary TABLES .========================================================= ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE ============================================================== Inserting EFT Header Titles Information For BOA Standard 005 Bank file format ============================================================== ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE ====================================================================== Inserting new EFT Setup field for BOA Standard 005 Bank file format ====================================================================== ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE -- ====================================================================== -- Get the current State of the Database -- ====================================================================== ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE -- ==================================================================================================== -- Started PTFCOMPX.sql (version R12 g) -- ==================================================================================================== =================================================== OBJECT COUNT Before ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== ERROR: ORA-03114: not connected to ORACLE =================================================== =================================================================================== == Recompiling invalid objects for "da" =================================================================================== ERROR: ORA-03114: not connected to ORACLE =================================================================================== == Re-compiling invalid objects for "dar" =================================================================================== ERROR: ORA-03114: not connected to ORACLE =================================================================================== == Re-compiling invalid objects for "owf_mgr" =================================================================================== ERROR: ORA-03114: not connected to ORACLE =================================================================================== == Re-compiling invalid objects for "uig" =================================================================================== ERROR: ORA-03114: not connected to ORACLE =================================================================================== == Re-compiling invalid objects for "js80" =================================================================================== ERROR: ORA-03114: not connected to ORACLE =================================================================================== == Re-compiling invalid objects for "jsr" =================================================================================== ERROR: ORA-03114: not connected to ORACLE =================================================================================== == Re-compiling invalid objects for "jsd" =================================================================================== ERROR: ORA-03114: not connected to ORACLE ====================================================================== == Re-compiling invalid objects for "cmic_bi" ====================================================================== ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE start additional_compx.sql ERROR: ORA-03114: not connected to ORACLE special list (before special recompiling) ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE special list (after special recompiling) ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE end additional_compx.sql =================================================================== OBJECT COUNT ======== ========== ======== ============================== Count Owner Invalid Type ======== ========== ======== ============================== ERROR: ORA-03114: not connected to ORACLE ========================================================================== Objects with errors ========== =================== ============================== Owner Type Object ========== =================== ============================== ERROR: ORA-03114: not connected to ORACLE =================================================================== ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE ERROR: ORA-03114: not connected to ORACLE -- ==================================================================================================== -- Completed PTFCOMPX.sql (version R12 g) -- ==================================================================================================== -- ====================================================================== -- Turn Patch Flag OFF -- ====================================================================== ERROR: ORA-03114: not connected to ORACLE -- ====================================================================== -- 2487654_4.sql completed. Output in 2487654_4.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 2 deployment dir /opt/cm/ias/j2ee/test/deployment/deploy Case 4 Issue 24.87654 was successfully installed. As specified with --no-deploy option, JSPs did not get deployed. Deploy JSPs manually Installation Log Review: ======================== ---------SUMMARY--------- Critical Errors: 57 Warning Errors: 0 Informative Errors: 3 ---------CRITICAL ERRORS--------- 1468 | ======================================================= 1469 | ERROR: 1470 | ORA-03114: not connected to ORACLE 1471 | 1478 | 1479 | ERROR: 1480 | ORA-03114: not connected to ORACLE 1481 | 1482 | 1483 | ERROR: 1484 | ORA-03114: not connected to ORACLE 1485 | 1492 | .========================================================= 1493 | ERROR: 1494 | ORA-03114: not connected to ORACLE 1495 | 1496 | 1497 | ERROR: 1498 | ORA-03114: not connected to ORACLE 1499 | 1503 | .========================================================= 1504 | ERROR: 1505 | ORA-03114: not connected to ORACLE 1506 | 1507 | 1508 | ERROR: 1509 | ORA-03114: not connected to ORACLE 1510 | 1514 | .=TMP===================================================== 1515 | ERROR: 1516 | ORA-03114: not connected to ORACLE 1517 | 1518 | 1519 | ERROR: 1520 | ORA-03114: not connected to ORACLE 1521 | 1523 | .=UPDATE================================================== 1524 | ERROR: 1525 | ORA-03114: not connected to ORACLE 1526 | 1527 | 1528 | ERROR: 1529 | ORA-03114: not connected to ORACLE 1530 | 1532 | .=INSERT================================================== 1533 | ERROR: 1534 | ORA-03114: not connected to ORACLE 1535 | 1537 | .========================================================= 1538 | ERROR: 1539 | ORA-03114: not connected to ORACLE 1540 | 1547 | .========================================================= 1548 | ERROR: 1549 | ORA-03114: not connected to ORACLE 1550 | 1551 | 1552 | ERROR: 1553 | ORA-03114: not connected to ORACLE 1554 | 1555 | 1556 | ERROR: 1557 | ORA-03114: not connected to ORACLE 1558 | 1560 | .=UPDATE=================================================== 1561 | ERROR: 1562 | ORA-03114: not connected to ORACLE 1563 | 1564 | 1565 | ERROR: 1566 | ORA-03114: not connected to ORACLE 1567 | 1569 | .=INSERT=================================================== 1570 | ERROR: 1571 | ORA-03114: not connected to ORACLE 1572 | 1574 | .========================================================= 1575 | ERROR: 1576 | ORA-03114: not connected to ORACLE 1577 | 1584 | .========================================================= 1585 | ERROR: 1586 | ORA-03114: not connected to ORACLE 1587 | 1588 | 1589 | ERROR: 1590 | ORA-03114: not connected to ORACLE 1591 | 1595 | ============================================================== 1596 | ERROR: 1597 | ORA-03114: not connected to ORACLE 1598 | 1599 | 1600 | ERROR: 1601 | ORA-03114: not connected to ORACLE 1602 | 1606 | ====================================================================== 1607 | ERROR: 1608 | ORA-03114: not connected to ORACLE 1609 | 1610 | 1611 | ERROR: 1612 | ORA-03114: not connected to ORACLE 1613 | 1620 | -- ====================================================================== 1621 | ERROR: 1622 | ORA-03114: not connected to ORACLE 1623 | 1624 | 1625 | ERROR: 1626 | ORA-03114: not connected to ORACLE 1627 | 1631 | -- ====================================================================== 1632 | ERROR: 1633 | ORA-03114: not connected to ORACLE 1634 | 1635 | 1636 | ERROR: 1637 | ORA-03114: not connected to ORACLE 1638 | 1647 | ======== ========== ======== ============================== 1648 | ERROR: 1649 | ORA-03114: not connected to ORACLE 1650 | 1655 | =================================================================================== 1656 | ERROR: 1657 | ORA-03114: not connected to ORACLE 1658 | 1663 | =================================================================================== 1664 | ERROR: 1665 | ORA-03114: not connected to ORACLE 1666 | 1671 | =================================================================================== 1672 | ERROR: 1673 | ORA-03114: not connected to ORACLE 1674 | 1679 | =================================================================================== 1680 | ERROR: 1681 | ORA-03114: not connected to ORACLE 1682 | 1687 | =================================================================================== 1688 | ERROR: 1689 | ORA-03114: not connected to ORACLE 1690 | 1695 | =================================================================================== 1696 | ERROR: 1697 | ORA-03114: not connected to ORACLE 1698 | 1703 | =================================================================================== 1704 | ERROR: 1705 | ORA-03114: not connected to ORACLE 1706 | 1711 | ====================================================================== 1712 | ERROR: 1713 | ORA-03114: not connected to ORACLE 1714 | 1716 | 1717 | ERROR: 1718 | ORA-03114: not connected to ORACLE 1719 | 1720 | 1721 | ERROR: 1722 | ORA-03114: not connected to ORACLE 1723 | 1725 | start additional_compx.sql 1726 | ERROR: 1727 | ORA-03114: not connected to ORACLE 1728 | 1730 | special list (before special recompiling) 1731 | ERROR: 1732 | ORA-03114: not connected to ORACLE 1733 | 1734 | 1735 | ERROR: 1736 | ORA-03114: not connected to ORACLE 1737 | 1738 | 1739 | ERROR: 1740 | ORA-03114: not connected to ORACLE 1741 | 1742 | 1743 | ERROR: 1744 | ORA-03114: not connected to ORACLE 1745 | 1747 | special list (after special recompiling) 1748 | ERROR: 1749 | ORA-03114: not connected to ORACLE 1750 | 1751 | 1752 | ERROR: 1753 | ORA-03114: not connected to ORACLE 1754 | 1755 | 1756 | ERROR: 1757 | ORA-03114: not connected to ORACLE 1758 | 1759 | 1760 | ERROR: 1761 | ORA-03114: not connected to ORACLE 1762 | 1769 | ======== ========== ======== ============================== 1770 | ERROR: 1771 | ORA-03114: not connected to ORACLE 1772 | 1778 | ========== =================== ============================== 1779 | ERROR: 1780 | ORA-03114: not connected to ORACLE 1781 | 1783 | =================================================================== 1784 | ERROR: 1785 | ORA-03114: not connected to ORACLE 1786 | 1787 | 1788 | ERROR: 1789 | ORA-03114: not connected to ORACLE 1790 | 1791 | 1792 | ERROR: 1793 | ORA-03114: not connected to ORACLE 1794 | 1801 | -- ====================================================================== 1802 | ERROR: 1803 | ORA-03114: not connected to ORACLE 1804 | 1474 | * 1475 | ERROR at line 1: 1476 | ORA-00028: your session has been killed 1477 | ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- 538 | 539 | Errors for PACKAGE BODY DA.DBK_AP_POSPAY: 540 | 0/0 ORA-04036: PGA memory used by the instance exceeds 541 | PGA_AGGREGATE_LIMIT 553 | * 554 | ERROR at line 1: 555 | ORA-00942: table or view does not exist 556 | 559 | * 560 | ERROR at line 1: 561 | ORA-00942: table or view does not exist 562 | =============================== End of Installation Log Review ===============================