Apr 10

Force a private IP during Load Balancer creation in OCI

Those days, I needed to recreate a Load Balancer in Oracle Cloud Infrastructure for a specific reason. It was a private Load Balancer. The problem is that when you create a Load Balancer, you can't specify the Private IP address in the Subnet that you want to use.. Oracle will pick automatically 3 IPs from …

Continue reading

Feb 14

Installing and running Oracle Database 19.2.0.0 on Oracle Linux 7

In this article I will describe how to install the very first available release of Oracle Database 19c (19.2.0.0) binaries on Oracle Linux 7.6. Even though it's not officially released for Oracle Linux non-Exadata yet, in edelivery it is available an Exadata DB version that is compatible with your local machine running OL. Use it for test …

Continue reading

Feb 06

"Verify Access Signing Certificate in Settings" in OCI when running curl REST calls

Those days I was trying to retrieve some OCI Json data using REST calls via curl. However, even though I've set up an application and Client ID and Secret accordingly, I was getting the error below: { "httpStatusCode" : 401, "httpMessage" : "Unauthorized", "executionContextId" : "005WAjCLgER1FgyN06YBUF0003so0000FI,0:1:1", "errorCode" : "urn:oracle:cloud:errorcode:tas:unauthorized", "errorMessage" : "Invalid Bearer Token: java.lang.Exception: …

Continue reading

Feb 01

Dissecting 190115 BP, PSU, RU and RUR

I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. To check previous changes, follow the links below: Dissecting 181016 BP, PSU, RU and RUR Dissecting 180717 BP, PSU, RU and RUR Dissecting 180417 BP, PSU, RU and RUR …

Continue reading

Dec 05

Injecting a simple dbakit (or rootkit) in Oracle PL/SQL objects

In this article, I will show how it is extremely simple to inject a hidden rootkit inside an Oracle database PL/SQL object (like a procedure) making it very hard to detect for almost all DBA's and Security Admins. It's important to understand and know how those virus works so we can always be prepared to …

Continue reading