Category: Oracle Database General

Oracle Database General

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

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 …

Continue reading

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 …

Continue reading

May 10

Dissecting 180417 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. So what oracle internal objects were changed in 180417? VERSION PATCH OWNER TYPE TOTAL ——————– ———- —————————— —————————— ———- 12.1.0.2 BP SYS PACKAGE 1 12.1.0.2 BP SYS …

Continue reading