Alfa

Opatch has a problem: c:\Oracle\Middleware\Oracle_FRHome1\OPatch>opatch lshomes Invoking OPatch 11.1.0.8.3 Oracle Interim Patch Installer version 11.1.0.8.3 Copyright (c) 2010, Oracle Corporation.  All rights reserved. UTIL session Oracle Home       : C:\Oracle\Middleware\Oracle_FRHome1 Central Inventory : C:\Program Files\Oracle\Inventory    from           : n/a OPatch version    : 11.1.0.8.3 OUI version       : 11.1.0.9.0 OUI location      : C:\Oracle\Middleware\Oracle_FRHome1\oui Log file location : C:\Oracle\Middleware\Oracle_FRHome1\cfgtoollogs\opatch\opatch2019-10-14_11-12-42fm.log Patch history file: C:\Oracle\Middleware\Oracle_FRHome1\cfgtoollogs\opatch\opatch_history.txt OPatch detects the Middleware Home as "C:\Oracle\Middleware" Invoking utility "lshomes" UtilSession failed: Internal Error: WebLogic Home 'c:\Oracle\MIDDLE~1\ORACLE~2\OPatch\@WL_HOME' does ...

Looks like that Forms will have to be upgraded as well..... Ahh...... Standard Forms do not either!! http://siskia-krtweb3:9001/forms/frmservlet?form=test.fmx&userid=&otherparams=useSDI=yes&lookAndFeel=oracle&colorScheme=blue (is the standard test Form) So..definitely a Forms issue... not related to Weblogic! Patch to upgrade Forms and Reports to latest Patchlevel: Patch 17882900: ORACLE FORMS AND REPORTS 11G R2 PS2 11.1.2.2 Thursday:c:\Oracle\Middleware\wlserver_10.3\common\bin>upgrade.cmd rerun Domain upgrade.... Log: If not present, set the source WebLogic Configuration to: 9.0 Domain directory selected: C:\Oracle\Middleware\user_projects\domains\ClassicDomain No servers are detected under this directory Current domain version 10.3.5.0 will be upgraded to 10.3.6.0. Preparing to select optional actions Admin Server exists in this directory. Configuration will be written out later. Preparing to backup the domain directory Locating domain fil...

Testing: C:\Oracle\Middleware>java -classpath C:\Oracle\Middleware\wlserver_10.3\server\lib\weblogic.jar utils.dbping ORACLE_THIN system dkpp_validation siskia-krtdb3:1521/kia **** Success!!! **** You can connect to the database in your app using:   java.util.Properties props = new java.util.Properties();   props.put("user", "system");   props.put("password", "dkpp_validation");   java.sql.Driver d =     Class.forName("oracle.jdbc.OracleDriver").newInstance();   java.sql.Connection conn =     Driver.connect("jdbc:oracle:thin:@siskia-krtdb3:1521/kia", props); C:\Oracle\Middleware> and: as mentioned previously in "How To Upgrade OBIEE 11g WebLogic Server From 10.3.5 To 10.3.6? (Doc ID 1934221.1)" : ****P.S : At the end when the Oracle Installer - Weblogic 10.3.6.0 come to the "Installation complete" screen, DO NOT check "Run Quickstart". This will run the Oracle Weblogic...

Do follow the README.HTML for patch 29413116 which is the RDBMS patch use the "batch" scripts: "first.bat"(environment setting) "second.bat" (net stop services) Apply patch using "opatch apply" from the 29413116 directory "third.bat"(net start services) from Patch directory follow the post-installation steps: "datapatch -verbose" KIA is patched correctly  KIAUTV and KIAUTV2 has errors on RMAN scripts. Need to clarify this. Appears that the: "Bug 22757320 - ORA-1427 is raised during the execution of dbmsrmansys.sql on a Multitenant Pluggable Database (Doc ID 22757320.8)" Fix is to adapt the "dbmsrmansys.sql" file from "and t.owner = 'SYS'" to "and t.owner = 'SYS' and rownum = 1" Reason for this: is that the patchlevel is simply too old! and why are there differences between the KIA and the two other databases: KIAUTV and KIAUTV2 ? RMAN CATAL...

Do follow the README.HTML for patch 29447962 which is the  JAVA Component patch Check if patch has conflicts : C:\Users\nieeli\database_upgrade\29447962>%ORACLE_HOME%\OPatch\opatch prereq CheckConflictAgainstOHWithDetail -ph ./ first.bat (set environment) second.bat (stop all Oracle Services) opatch apply ........ (apply running...) Verifying the update... Patch 29447962 successfully applied Log file location: e:\oracle\product\12.1.0\dbhome_1\cfgtoollogs\opatch\29447962_Sep_25_2019_12_51_10\apply2019-09-25_12-51-10em_1.log OPatch succeeded. third.bat (Start up services) KIA database: shutdown && startup upgrade cd %ORACLE_HOME/OPatch datapatch -verbose  "Installation queue:   Nothing to roll back   The following patches will be applied:     29447962 (WINDOWS ORACLE JAVAVM COMPONENT BUNDLE PATCH 12.1.0.2.190416: 294\ 47962) Installing patches... Patch installation complete.  Total patches installed: 1 Validating log...

The installation should follow the following thread: https://community.oracle.com/thread/3543041 1.  Ensure you are using WLS 10.3.6.  If not, apply the WLS patch first. 2.  Stop all running processes related to WLS and FMw 3.  Run the 11.1.2.2 installer.  If the installer prompts you to either "Install and Configure" or "Install - Do Not Configure", choose "Install - Do Not Configure" Started the "setup.exe" for the Patch, and promptly ran into "hpi.dll" been active and cannot be written to... Had to download "Procexp" from Microsoft and find the process "hpi.dll" process and kill it off, before the installation could continue.....