Alfa

  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_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCO

 s-kiaweb --- Fusion Middleware : Install 12.2.1.4 Fusion Middleware using the V983368-01 from edelivery.oracle.com unzip V983368-01 java -jar fmw_12.2.1.4.0_infrastructure.jar Logfile: C:\Users\nen800\AppData\Local\Temp\OraInstall2024-02-28_02-11-33PM\install2024-02-28_02-11-33PM.log Install Forms and Reports Follow installation docs:  https://docs.oracle.com/en/middleware/developer-tools/forms/12.2.1.19/install-fnr/installing-and-configuring-oracle-forms1.html#GUID-E3EC8981-780D-4D15-AA01-1FF91CDDCF59 unzip V1033711-01.zip setup_fmw_12.2.1.19.0_fr_win64.exe C:\Users\nen800\AppData\Local\Temp\OraInstall2024-02-28_02-26-55PM\install2024-02-28_02-26-55PM.log cd % ORACLE_HOME% /oracle_common/bin rcu.bat cd % ORACLE_HOME% /oracle_common/common/bin config.cmd http://s-kiaweb:7001/console Follow installation docs:  https://docs.oracle.com/en/middleware/fusion-middleware/12.2.1.4/infin/configuring-oracle-fusion-middleware-infrastructure-domain.html#GUID-AC290245-59B1-4008-9891-2273ED8FE8A1 c

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:\app\oracle\product\19.0.0\dbhome_1\cfgtoollogs\opatch\opatch2024-02-13_11-53-02fm_1.log Invo

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