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

Aug 15

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

Aug 09

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

Jul 31

ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created

Those days when I was trying to apply the Apr 2018 Release Update Revision 12.2.0.1.180717, I got the error below during datapatch roolback execution of the previous patch: Patch 27013506 rollback (pdb PDB01): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/27013506/21779816/27013506_rollback_ORCL_PDB01_2018Jul31_00_12_34.log (errors) Error at line 32785: ORA-20000: Oracle Text Error: CTXSYS.JSONREST_GENERIC_STOPLIST not created And in logfile there was this …

Continue reading

Jul 24

Export OCI Security Lists rules to csv format

Every time I do create a new subnet, as a best practice I create 5 security lists for each (as for now OCI does not allow me to include/remove SLs dynamically in already created subnets) so I can guarantee I can reach the maximum possible rules if it’s necessary. When you have dozens of security …

Continue reading