Alfa, opgradering 2024

 

Alfa patchning til seneste version af RDBMS 19C.

  1. Patch 35962832 - Windows Database Jan2024 Bundle Patch 19.22.0.0.240116
  2. Installere sidste version af "OPatch" som findes i patch 6880880
  3. Følg README som ses i 
    1. file:///C:/Users/nen800/Downloads/p35962832_190000_MSWIN-x86-64/35962832/README.html
  4. Installere seneste version af 19C patch med følgende :
    1. Prereq:
    2. 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:\app\oracle\product\19.0.0\dbhome_1\cfgtoollogs\opatch\opatch2024-02-13_11-53-02fm_1.log

      Invoking prereq "checkconflictagainstohwithdetail"for

      Prereq "checkConflictAgainstOHWithDetail" passed.

      OPatch succeeded.

      C:\Users\nen800\Downloads\p35962832_190000_MSWIN-x86-64\35962832>
    3.  luk alle databaser, lsnrctl og "net stop msdtc" .. og alle andre Oracle processer!
    4. Installer selve patchen med "opatch apply"  
.........
Patching component oracle.sdo.locator, 19.0.0.0.0...
Patching component oracle.rdbms.scheduler, 19.0.0.0.0...
Patching component oracle.xdk.xquery, 19.0.0.0.0...
Patching component oracle.jdk, 1.8.0.201.0...
Patch 35962832 successfully applied.
Log file location: C:\app\oracle\product\19.0.0\dbhome_1\cfgtoollogs\opatch\opatch2024-02-13_12-24-59em_1.log

OPatch succeeded.

    1.  Anden del af patchen.....
      1. "unset local=" og "set ORACLE_SID=kiaprod3"
      2. datapatch -verbose
      3. logfile: C:\app\oracle\cfgtoollogs\sqlpatch\sqlpatch_9272_2024_02_13_13_09_56\sqlpatch_invocation.log
      4. Tid: ca. 30 minutter !!
  1. Export tager helt vildt lang tid!! knap 10 timer !!!!
  2. "dbca.bat" --- Managing databases
  3. kiaprod PDB: pass: KiaProd_Mgr1252
  4. db_file_create_dest sat for KIAPROD til d:/app/oracle/oradata
  5. table spaces created using "create_tablespaces_new.sql" 
  6. Aha......
    1. "
    2. K:\dbdump>oerr ora 29283
    3. 29283, 00000, "invalid file operation%s"
    4. // *Cause:  An attempt was made to read from a file or directory that does
    5. //          not exist, or file or directory access was denied by the
    6. //          operating system.
    7. // *Action: Verify file and directory access privileges on the file system,
    8. //          and if reading, verify that the file exists.

    10. K:\dbdump>impdp parfile=impdp.par

    12. Import: Release 19.0.0.0.0 - Production on Wed Feb 21 11:23:19 2024
    13. Version 19.22.0.0.0

    15. Copyright (c) 1982, 2024, Oracle and/or its affiliates.  All rights reserved.

    17. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    18. ORA-39002: invalid operation
    19. ORA-39070: Unable to open the log file.
    20. ORA-29283: invalid file operation: unexpected "LFI" error (1509)[29437]
    21. "
    22. Fix:
      1. NONE! ... skal kopiere export filerne over på interne diske!
      2. 2 timer ekstra!
    23. Import ---- cirka 15 timer !!!
    24. tilpasset tnsnames.ora på s-kiaweb

Kommentarer

Send en kommentar

Populære opslag fra denne blog

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