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

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

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