This article explains about applying latest 19c Release update patch. The environment which is used in this article is as below. Operating system: Oracle Linux 7 Database version: 19.0.0.0.0 Application Version: 12.2.10 Database Release update:19.8.0.0.0 Current Patch set: 12.2.0.1.21 The high level process for applying Database Release update patch Download latest RUP Pre Checks Apply RUP Post-installation Download latest RUP Download the latest RUP (Patch 32218454) from MOS as shown below. For applying this patch the minimum OPatch utility version is 12.2.0.1.23 or higher. In this env ..read more

This article explains how to apply the latest ETCC Patches on the E-Business Suite. The current environment which is used in this article is as below. Operating system: Linux7.9 Database version:12.1.0.2 Current Patchset:12.2.0.1.24 Application version:12.2.8 The high level process for applying ETCC Patches Download latest ETCC patch Run DB ETCC on Database Tier and apply recommended patches Run MT ETCC on Application Tier and apply recommended patches Download latest ETCC Patch Download the latest ETCC patch from MOS using wget option and then unzip the patch. Run DB ETCC on DB Tier R ..read more

Oracle EBS Technology Team have just announced the new tool ETPAT-AT. This will help the E-Business Suite customers to automate the patching of the Technology Stack components i.e., FMW WebTier 11.1.1.9 Oracle WebLogic Server 10.3.6 Smart Update Patch Oracle WebLogic Server 10.3.6.0 FMW oracle_common 11.1.1.9 Forms and Reports 10.1.2.3 Till now the Oracle EBS DBAs apply these manually using opatch or bsu utilities but now this is automated. Remember that the patches need to be still downloaded into a stage area. ETPAT-AT is available from My Oracle Support as Patch 32208510. I will provide a ..read more

Typically Oracle Apps DBAs spend several hours or even more than a day to setup environments. With Oracle E-Business Suite Cloud Manager, it is now extremely to launch EBS instances. You can launch: Oracle EBS 12.2 with 19c DB Oracle EBS 12.2 with 12c DB Oracle EBS 12.1 with 12c DB With the latest E-Business Suite Cloud Manager 20.2.1, you have even option for Multiple Zones (e.g. DMZ), Logical Hostnames and more. Check new features here: https://blogs.oracle.com/ebsandoraclecloud/get-ebs-cloud-manager-2021 Database Tier can be configured in Compute, VM DB System or even Exadata DB System. C ..read more

Oracle released the Oracle E-Business Suite 12.2.10 Vision Instance VM Appliance. This is the first Vision Instance VM Appliance with 19c Database released in E-Delivery site. Previously released 12.2.9 has 12c Database. However, in OCI if you are using Oracle EBS Cloud Manager you can launch Fresh Database or Vision Instance with different combinations of EBS versions and Database version including 12c, 19c. It is a good time to get hands on with 19c Database in Oracle EBS 12.2. https://blogs.oracle.com/ebstech/ebs-12210-with-database-19c-vm-virtual-appliance-for-on-premises ..read more

We know that the VirtualBox VMs when using Dynamically Allocated Disks will only consume the space from the Physical Host when used inside the VM irrespective of the disk size in VM. However, if you delete large files in the VM foe e.g. like Database Backups, you still won’t see the free space in the Windows Host. In order to release this space, you need to do below: First connect to Linux VM and navigate to any mount with enough space to store temporary files: su - root cd /u01 dd if=/dev/zero of=zero.tmp bs=10M; rm -f zero.tmp This basically is to zero out all unused disk blocks. Now shutd ..read more

Sometimes applying Tech Stack patches lead to bugs or issues which we know. This is one such instance where the OPMN was failing to start after applying latest ETCC patches. So let us see in detail: I have applied latest ETCC patches which includes patches for WebTier, 10.1.2.3, WLS etc. Once they are applied, opmn was failing to start and when I checked the OPMN log file, I have found the below error in it: [opmn] [ERROR:1] [] [ons-secure] Connection server SSL set credentials failed (43084) [opmn] [ERROR:1] [222] [ons-secure] SSL initialization failed Oh! But wait.. I don’t have SSL or TLS c ..read more

Oracle released update to the AD/TXK on 7th Aug, 2020. The previous version for R12.AD.C.Delta.11 was one of the major updates and there has not been a update to AD/TXK since a long time. Oracle now released for R12.AD.C.Delta.12 and R12.TXK.C.Delta.12. There are no enhancements for any of the AD utilities and mostly its the bug fixes. Check the documents below for more details: Oracle E-Business Suite Applications DBA and Technology Stack Release Notes for R12.AD.C.Delta.12 and R12.TXK.C.Delta.12 (Doc ID 2649885.1) Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite ..read more

So! During EBS pre-upgrade steps, we need to configure UTL_FILE_DIR replacement values using txkCfgUtlfileDir.pl using MOS Document ID: Using UTL_FILE_DIR or Database Directories for PL/SQL File I/O in Oracle E-Business Suite Releases 12.1 and 12.2 (Doc ID 2525754.1). We need to run it 2 times actually. One is getUtlFileDir and then followed by setUtlFileDir. What happens if you forgot to do it? Two scenarios: You have run getUtlFileDir but didn’t do setUtlFileDir You have not done both 1st Case: So you have run getUtlFileDir but not setUtlFileDir. In this case, when you run the getUtlFileDi ..read more

I have just launched the EBS vision 12.2.9 image in Oracle Cloud and I have observed that it now comes with 19c (19.6) DB. [oracle@apps OPatch]$ ./opatch lsinventory|grep 'Release' Patch description: "Database Release Update : 19.6.0.0.200114 (30557433)" [oracle@apps scripts]$ sqlplus '/as sysdba' SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 24 16:29:11 2020 Version 19.6.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.6.0.0.0 You can also check the latest RU applied which is ..read more