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

Dissecting 181016 BP, PSU, RU and RUR

Since 2017 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 171017 BP, PSU, RU and RUR Dissecting 180116 BP, PSU, RU and RUR Dissecting 180417 BP, PSU, RU …

Continue reading

The best upcoming features in Oracle Database 19c

In the Oracle Open World 2018 event that happened in San Francisco last week, from October 22nd to 25th, much has been said about the trends and strategy paths that Oracle is taking in both OCI and in Oracle Database. As we DBA’s are always excited about the upcoming features, I will share below some …

Continue reading

Howto backup Oracle Cloud Infrastructure metadata

As of today (October 2018), there is still no internal capability in Oracle Cloud Infrastructure to backup the metadata of all the objects you have (like computes, volumes, network, users, etc). This would be indeed a great feature and prefer to believe that Oracle is working to deploy it. Meanwhile, I have some customers that …

Continue reading

Creating a read-only user in Oracle Cloud Infrastructure

Creating a read-only user for OCI access is useful if you want to give your auditors or external providers only read privileges on all your Infrastructure resources or if you want to run oci-cli tool in a secure mode, with guarantee that no changes will happen in your Oracle Cloud Infrastructure. In this article I …

Continue reading