Client home /u01/app/oracle/product/19.19/PROD Start execution of command /opt/cm/v12/prtn/1_hotfix_prtn/24.87863_CLOUD_294342_install_1_install.sh ** Note ** Setting TNS_ADMIN to /u01/app/oracle/product/19.19/PROD/network/admin If you need TNS_ADMIN to be different, then set it before running this program. ** Note ** Client home /u01/app/oracle/product/19.19/PROD Installation started at: 2024-08-21 10:34:16 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/********@prtn Warning: Issue 24.87863, has been installed 2 times on the application server while it is installed 0 times on the database! Entryname Update:uig#targetoption.vw@uig/sql - File: uig/sql/uig#targetoption.vw: ____________________________________ Updating: /opt/cm/v12/prtn/uig/sql/uig#targetoption.vw - size (on disk): 29511 bytes - last modified (on disk): 2022-07-18 00:51:45.0 -project (on disk): - version (on disk): - size (new file): 29644 bytes - last modified (new file): 2024-07-23 12:32:08.0 - File: uig/sql/UIG_2487863_1.sql: __________________________________ Updating: /opt/cm/v12/prtn/uig/sql/UIG_2487863_1.sql - This is a new file, no information available on disk - size (new file): 9221 bytes - last modified (new file): 2024-07-23 12:01:02.0 db=prtn Using the script: /opt/cm/v12/prtn/1_hotfix_prtn/install_2024-08-21_10_34_17.238/PTFCompX.sh to run /u01/app/oracle/product/19.19/PROD/bin/sqlplus /nolog @"/opt/cm/v12/prtn/1_hotfix_prtn/install_2024-08-21_10_34_17.238/tempPtfcompx.sql" File to exec /opt/cm/v12/prtn/1_hotfix_prtn/install_2024-08-21_10_34_17.238/PTFCompX.sh Running dir /opt/cm/v12/prtn/sql The number of groups of SQL scripts 2 The group 0 entry Name Update:UIG_2487863_1.sql@uig/sql Using the script: /opt/cm/v12/prtn/1_hotfix_prtn/install_2024-08-21_10_34_17.238/UIG_2487863_1.sql.sh to run UIG_2487863_1.sql File to exec /opt/cm/v12/prtn/1_hotfix_prtn/install_2024-08-21_10_34_17.238/UIG_2487863_1.sql.sh Running dir /opt/cm/v12/prtn/sql Start execution of command /opt/cm/v12/prtn/1_hotfix_prtn/install_2024-08-21_10_34_17.238/UIG_2487863_1.sql.sh Wait for procedure starts SQL*Plus: Release 19.0.0.0.0 - Production on Wed Aug 21 10:34:21 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.87863, Work Item 1 -- Tenant creation issue post Patch 19 -- ====================================================================== USER is "DA" prtn USER is "DA" prtn USER is "DA" prtn Connected. -- ====================================================================== -- Started UIG_2487863_1.sql Output in UIG_2487863_1.lst -- ====================================================================== -- ====================================================================== -- Drop Obsolete Database Objects -- ====================================================================== -- ====================================================================== -- Create Types -- ====================================================================== -- ====================================================================== -- Create Tables -- ====================================================================== -- ====================================================================== -- Add Columns -- ====================================================================== -- ====================================================================== -- Install Table and Column Comments -- ====================================================================== -- ====================================================================== -- Create Sequences -- ====================================================================== -- ====================================================================== -- Install VWT files or Create Synonyms for TN tables -- ====================================================================== -- ====================================================================== -- Register Table-Packages and Rebuild Automatically Created Packages -- ====================================================================== -- ====================================================================== -- Install Automatically Generated Package Headers -- ====================================================================== -- ====================================================================== -- Install Automatically Generated Wrapping Views -- ====================================================================== -- ====================================================================== -- Install Automatically Generated Package Bodies -- ====================================================================== -- ====================================================================== -- Update Data, Modify Table/Column Definitions -- ====================================================================== -- ====================================================================== -- Install Keys and Constraints -- ====================================================================== -- ====================================================================== -- Install Indexes -- ====================================================================== -- ====================================================================== -- Install Standard Oraseq Populating Triggers -- ====================================================================== -- ====================================================================== -- Install Package Headers -- ====================================================================== -- ====================================================================== -- Install Views -- ====================================================================== ===================================================================== View UIG#TARGETOPTION ===================================================================== No errors. ===================================================================== UIG#TARGETOPTION Instead of Triggers ===================================================================== No errors. -- ====================================================================== -- Install Triggers -- ====================================================================== -- ====================================================================== -- Install Package Bodies -- ====================================================================== -- ====================================================================== -- Install or Update System Data -- ====================================================================== -- ====================================================================== -- Data Correction Statements -- ====================================================================== PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. -- ====================================================================== -- Install UI Runtime Program Definitions -- ====================================================================== -- ====================================================================== -- ====================================================================== -- Update Menu Items in Treeview -- ====================================================================== -- ====================================================================== -- UIG_2487863_1.sql completed. Output in UIG_2487863_1.LST -- ====================================================================== Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.23.0.0.0 The group 1 Issue 24.87863 was successfully installed. 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: 0 ---------CRITICAL ERRORS--------- ---------WARNINGS--------- ---------INFORMATIONAL ISSUES--------- =============================== End of Installation Log Review ===============================