Nov 26

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

Oct 29

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

Oct 11

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

Sep 17

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

Aug 17

Oracle Database causing Linux auditd logs to grow fast

Those days I was having some issues on some of my Oracle Linux 6 servers (VMs in OCI), with some Oracle Databases running still in project phase. I could notice /var/log/audit folder size growing abnormally (around ~80MBs day) [root@ocasxxxt00dbre1 audit]# ls -ltrh | tail -n 30 -r--------. 1 root root 6.1M Aug 15 10:24 audit.log.29 …

Continue reading