Configuring TLS/HTTPS for Oracle EBS Integrated SOA Gateway (ISG) in 12.1By Alexander Pavlik|August 9th, 2023| Introduction 1 References 2 Perform Steps from Doc ID 376700.1, Section 5.3 3 Perform Steps from Doc ID 376700.1, Section 7.3 3.1 Apply Patch 25034687 R12.OWF.B Using adpatch 3.2 Apply Patch 22612527 to the 10.1.3.5 Home 3.3 Update the 32-bit JDK 7 with JCE [...]
Configuring TLS/HTTPS for Oracle EBS Integrated SOA Gateway (ISG) in 12.2By Alexander Pavlik|July 24th, 2023| Introduction 1 References 2 Diagnostic Steps 3 Configuration Steps 3.1 Update the AdminServer and the Managed Server (WLS) Configuration 3.2 Run Autoconfig on the Apps Tier 3.3 Append JVM Parameter to All Managed Servers 3.4 Configure Custom Hostname Verifier 3.5 Update the Truststore with [...]
Configuring Oracle EBS Integrated SOA Gateway (ISG) REST services in 12.2By Alexander Pavlik|July 20th, 2023| Introduction 1 Automated configuration with the Blitz Report script 1.1 What the script does 1.2 Run the configuration script 1.3 After running the script 2 References 3 Video Instructions 4 Check prerequisite patches 4.1 ISG consolidated patch 4.2 EBS release version 4.3 AD and [...]
Configuring Oracle EBS Integrated SOA Gateway (ISG) 12.1.3By Alexander Pavlik|July 20th, 2023| Introduction 1 References 2 Install necessary patches 2.1 Check that Oracle Application Server 10g Release 3 (10.1.3) is on Patch Set 5 (10.1.3.5.0) 2.2 Apply additional Oracle Application Server 10.1.3.5 Oracle Home patches 2.3 Apply ISG Consolidated Patch with the pre-requisites 3 Run the [...]
Find an IP address and geolocation of EBS clients’ loginsBy Alexander Pavlik|October 8th, 2021| Introduction 1 Setup 1.1 Choosing a geolocation API 1.2 Configuring http requests from Oracle Database 1.2.1 Create a new Access Control Entry (ACE) 1.2.2 Obtain the geolocation API website certificate 1.2.3 Import the certificate into an Oracle Wallet 2 Create a geolocation function 3 [...]
Simplifying DBA tasks with Blitz ReportBy Alexander Pavlik|January 11th, 2021| I am an EBS Apps DBA. When I talk with other DBA.s, it is clear that every one of us EBS DBAs has their own set of cool queries helping us complete our day-to-day tasks. I have such a toolkit too. Sometimes I borrow a [...]