Alfa

Opgradering af Fusion Middleware 11.1.1.7 til 12C 11G (11.1.1.7) Følg dokumentationen af opgraderingsforløbet som beskrevet i : Oracle® Fusion Middleware Planning an Upgrade of Oracle Fusion Middleware 12c (12.2.1) E55675_02 1399670775   = Doc.Id: E55675_02  Lille grant som skulle gøres...  C:\>sqlplus sys/KiaProd_Mgr1252@kiaprod as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 6 12:13:17 2024 Version 19.14.0.0.0 Copyright (c) 1982, 2021, Oracle.  All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.22.0.0.0 SQL> grant select on user$ to sis_owner ; Grant succeeded. SQL>   zip  -x domains/ClassicDomain/servers/AdminServer/tmp* -x domains/ClassicDomain/servers/AdminServer/logs/* -x domains\ClassicDomain\servers\WLS_FORMS\data\store\diagnostics\WLS_DIAGNOSTICS000000.DAT -x *access.log* -x *WLS_FoRMS.log* -x *metricdump-*log.gz -r old *.* Kopiere de apps specifikke filer fra...

  Documentation:   RCU is a utility to create the schemas, not administer the schemas once they are installed and working. There can be differences between schemas because of product differences. In general, Oracle Database steps can be followed for a backup and recovery, but caution should be taken if the goal is to also change the network configuration, such as the hostname and/or ip address. You can backup the database and restore to the new system using standard database options, but the FMW documentation here may help: The 12.2.1.4 documentation can be found here, Administering Oracle Fusion Middleware (12.2.1.4) 15 Changing Oracle Fusion Middleware Network Configurations https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/asadm/changing-network-configurations.html#GUID-EA5612E8-A1E8-4022-821E-44C15559914D tnsnames.ora:  kiaprod,krpdb =  (DESCRIPTION=    (CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)    (ADDRESS_...

RMAN> show all 2> ; RMAN configuration parameters for database with db_unique_name KIAPROD3 are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'n:\backup\oracle\kiaprod\%F'; CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 10; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'n:\backup\oracle\kiaprod\%U'; CONFIGURE MAXSETSIZE TO 35000 M; CONFIGURE ENCRYPTION FOR DATABASE OFF; # default CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD FALSE; CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default CONFIGURE ARCHIVELOG DELETIO...

  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...

 Uppgradering del 2 Typ av server och info: Oracle Certification for Windows 2019: Certification Information for Oracle Database on Microsoft Windows x64 (64-bit) (Doc ID 1307195.1) nerladdet diverse software, och börjat installation av RDBMS 19.3.0 Installaton successful Oracle Enterprise Manager Database Express URL: https://s-kiadb.stat-inst.se:5500/em kan inte nås.... säkerligen Firewall problem ..... Måste köra:  SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500); Import APEX skapas innan! Oracle Spatial ... installeras eller inte ???? REDO logs skal omgöras! "nen800" skal ha " GRANT EXEMPT ACCESS POLICY to nen800;" "Lock Pages in memory"  regedit:  ORA_LPENABLE=1   CAREFUL! mycket mera minne! RMAN Upgrade catalog (twice) "register database" hmmmm.... måste rekonfigurera setup..... ser MYCKET annorlunda ut i 19C !! Infrastruktur: s-kiaweb   C:\Users\nen800\Downloads\middleware>java -jar fmw_12.2.1.4.0_infrastructure.jar Launcher log file is ...

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

 KIAUTB: Översikt: Kopiert över ifrån gamla servran, men bara databas-filarne och init.ora etc. Definiert KIAUTB via "oradim" Startad KIAUTB Kört "create_cntl_kiautb.sql" Anpassad "listener.ora" och "tnsnames.ora" med nya IP-address för KIAUTB. "lsnrctl reload"  up-and-running!

 Oracle upgradering: Se Certificerings-matrixen som ar bifogad. Screenshots 1-4 Det som behövs ar följande : Windows Server 2019 (til båda databas och Fusion Middleware) Databasversion 19.9.x (uppgraderas ifrån 12.1, kräver et mellanstop til 12.2.x annars går uppgraderingen inte) Fusion Middleware : oracle Fusion 12.2.1.4(inklusive Oracle Forms 12.2.1.4), som inte ar den nyaste, men den som säkerligen kräver det minste uppgradering af applikationen ifrån Oracle Forms 11.1.1.7). Denne version kan köra med HTML5 och Java 8. Tidsestimat: Servrar: 1 månad ? Installation av Gamla databas med innehåll (for at få en tidsestimat av uppgradering til 12.2 och sen til 19.9) (her skulle det vara himla bra om där finns några snapshot möjlighet ?) -- 14 dagar (x 8timmar = 104 timmar) Akta för Transparent Gateway (til Sql-Server)... funkar det i 19 ? Måste startas med listener NAMN....... Fusion Middleware install 12.2.1.4: 5 dagar (x 8 timmar = 40 timmar) Sen installation av applikation (Anders/...

Patch 30049606: WINDOWS DB BUNDLE PATCH 12.1.0.2.191015 Joerg.Sobottka User Image 1+ month ago TO ALL THAT ARE NOT ABLE TO DOWNLOAD 12.1.0.2 patches anymore: You DO need for 12.1.0.2 Extended Support (so your CSI number must be linked to PAYED extended support as the free extended support has ended in summer 2019).

Oracle WebLogic Server Patch Set Update 10.3.6.0.191015 ========================================== Stop all Weblogic Services. Update the "\Oracle\Middleware\utils\bsu\bsu.cmd" with the parameters above:  "set MEM_ARGS=-Xms1024m -Xmx3072m" Run the"bsu_patch.cmd" output see below C:\Users\nieeli\weblogic_upg\30109677>more bsu_patch.cmd cd \oracle\middleware\utils\bsu echo "fixa bsu.cmd" echo "set MEM_ARGS=-Xms1024m -Xmx3072m" echo "" \Oracle\Middleware\utils\bsu\bsu.cmd -install -patch_download_dir=\oracle\middleware\utils\bsu\cache_dir -patchlist=3L3H -prod_dir=\oracle\m iddleware\wlserver_10.3 Checking for conflicts................... No conflict(s) detected Installing Patch ID: 3L3H.. Result: Success C:\Users\nieeli\weblogic_upg\30109677>java weblogic.version WebLogic Server 10.3.6.0.191015 PSU Patch for BUG30109677 Thu Oct  3 23:31:07 PDT 2019 WebLogic Server 10.3.6.0  Tue Nov 15 08:...

Patch: Patch 13529623: PLACEHOLDER BUG FOR WEBLOGIC SERVER 11GR1 (10.3.6) UPGRADE INSTALLER Stop all "opmn" and "beasvc" Services Download the patch, and run the following: "java -jar wls1036_upgrade_generic.jar" Presented with: "Next" "Next" You will be presented with: Just remain "uninformed"  ... Have already the information! press "Next" The "WebLogic Server" have already been preselected. press "Next" This is okay, as this is exactly what we are looking to upgrade. All done. As per: https://docs.oracle.com/cd/E23943_01/web.1111/e13754/upgrade_dom.htm#WLUPG170 Run the Upgrade Wizard : cd C:\\Middleware\wlserver_10.3\common\bin upgrade.cmd All done..... Then running "startWeblogic.cmd" throws a lot of missing CLASSPATH errors ....

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.....