Uppgradering del 1

 Uppgradering del 1

  1. Export ar väldig trög ....... med "parallel=4"
  2. Hittade en del fel i exporten: ORA-39181
    1. Fix kan vara: "GRANT EXEMPT ACCESS POLICY to System"
  3. Kör igen klockan 13
    1. parallel=8
    2. och kört: "GRANT EXEMPT ACCESS POLICY to System"
      1. fixade problemet med export 2.
    3. Enkelt Ora Fel... snapshot too old! ORA-1555
  4. Kör export 3
    1. start 17:30 lördag --- färdig 03:48 söndag
  5. Körde import (bara sqlfile=kiaprod_import.sql) 
    1. så finns alla statements i en fil var dom kan anpassas ......

Kommentarer

Nye kommentarer er ikke tilladt.

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