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

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

Oracle OCI compute instance change shape script

As of today (August 2018), there is still no internal capability in Oracle Cloud Infrastructure to change the shape of a given compute instance but manually removing and creating the whole machine. This would be indeed a great feature and really believe that Oracle is working to deploy it very soon. Meanwhile, I have some …

Continue reading

Dissecting 180717 BP, PSU, RU and RUR

Since Oct-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. This is the first one to include change on 18c version. So what oracle internal objects were changed in 180717? VERSION PATCH OWNER TYPE TOTAL ———- ————— …

Continue reading