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 …
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 …
Jun 20
Installing Oracle Database on ARM small single-board computer
In this article I will describe how to install an Oracle Database in a small single-board computer, making it the smallest Oracle DB server in the world! =] How is it possible? What hardware did I use? What is the performance of it? As there many questions and steps involved, I’ve split this article in the …
Jun 11
Protecting Oracle Database Binaries against malicious changes
Introduction In the live sessions where I talk about Oracle Database security and vulnerabilities, I do always mention rootkits or malwares that can attack a database from either inside (via SQL injection, PL/SQL poisoning, Java leaks, etc) or externally (by changing oracle user files, such as binaries / libs / crontab / etc). To explore …
May 29
How to bypass requirement of WITH GRANT OPTION on views accessing third-party tables
A long time back, Oracle introduced limitations on VIEWS to avoid that some user with access to a given object in the database to pass on its contents to another user, by encapsulating it on views. As it’s always better to show examples than writing theory, let’s say we have 3 users on the database …
About
Rodrigo Jorge
Oracle OCM Database 11g & 12c
Oracle OCM MAA & Cloud
Oracle OCE Data Guard 12c
Oracle OCE RAC and Grid 11gR2 & 12c
Oracle OCE Performance Tuning 11g & 12c
Oracle OCS Security 11g
Oracle OCS Data Warehousing 11g
