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