Alfa: CPU patch RDBMS April 2019




  • Do follow the README.HTML for patch 29413116 which is the RDBMS patch

    1. use the "batch" scripts:
      1. "first.bat"(environment setting)
      2. "second.bat" (net stop services)
      3. Apply patch using "opatch apply" from the 29413116 directory
      4. "third.bat"(net start services)
      5. from Patch directory follow the post-installation steps:
        1. "datapatch -verbose"
          1. KIA is patched correctly 
          2. KIAUTV and KIAUTV2 has errors on RMAN scripts.
          3. Need to clarify this.
            1. Appears that the: "Bug 22757320 - ORA-1427 is raised during the execution of dbmsrmansys.sql on a Multitenant Pluggable Database (Doc ID 22757320.8)"
            2. Fix is to adapt the "dbmsrmansys.sql" file from
              1. "and t.owner = 'SYS'"
              2. to
              3. "and t.owner = 'SYS' and rownum = 1"
          4. 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 ?
      6. RMAN CATALOG upgrade .... nogo ???????
      7. Run: "@?/rdbms/admin/dpload.sql" (Datapump ....... for all databases)

    Kommentarer

    Send en kommentar

    Populære opslag fra denne blog

    Alfa, opgradering 2024

      Alfa patchning til seneste version af RDBMS 19C. Patch 35962832 - Windows Database Jan2024 Bundle Patch 19.22.0.0.240116 Installere sidste version af "OPatch" som findes i patch 6880880 Følg README som ses i  file:///C:/Users/nen800/Downloads/p35962832_190000_MSWIN-x86-64/35962832/README.html Installere seneste version af 19C patch med følgende : Prereq: C:\Users\nen800\Downloads\p35962832_190000_MSWIN-x86-64>cd 35962832 C:\Users\nen800\Downloads\p35962832_190000_MSWIN-x86-64\35962832>opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.2.0.1.41 Copyright (c) 2024, Oracle Corporation.  All rights reserved. PREREQ session Oracle Home       : C:\app\oracle\product\19.0.0\dbhome_1 Central Inventory : C:\Program Files\Oracle\Inventory    from           : OPatch version    : 12.2.0.1.41 OUI version       : 12.2.0.7.0 Log file location : C...
    Læs mere

    Alfa: Debugging 3

    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 ...
    Læs mere

    Alfa: Forms & Reports Update - Patch 17882900

    Billede
    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.....
    Læs mere