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

May 08

Oracle 12.2.0.1 JAN2018 RUR – 180417 or 180411 ?

After some delay, Oracle finally released in the end of April the First RUR for 12.2.0.1 Jan-2018 RU. The original release date for this RUR was April 17, 2018 but it was only really available around April 30, 2018. The problem is that because of this delay something get internally messed and instead of using …

Continue reading

Apr 25

New DBMS_ASH and DBMS_BDSQL packages – Apr2018 Patch

After applying the 180417 PSU and BP over 12.1.0.2 Database, I’ve noted 2 new packages created on the database: DBMS_ASH and DBMS_BDSQL. VERSION PATCH OWNER TYPE NAME ——————– ———- ——————– ——————– ——————– 12.1.0.2 PSU & BP SYS PACKAGE DBMS_ASH 12.1.0.2 BP ONLY SYS PACKAGE DBMS_BDSQL 12.1.0.2 BP ONLY SYS PACKAGE BODY DBMS_ASH 12.1.0.2 BP ONLY …

Continue reading

Feb 28

Creating Oracle 18c Database in OCI Classic

In this article, I will show you in details how to create the new released 18c Oracle Database on Oracle Cloud Infrastructure Classic. 1. Creating Trial Account Go to cloud.oracle.com and click on right up corner in “Try for Free“. In the new opened page, click on “Create a Free Account“. In this page you …

Continue reading

Feb 27

Creating and running an Oracle 18.0.0.0.0 DB instance on Oracle Linux

In my previous post I showed how to install the Oracle 18c Exadata binaries in a Oracle Linux 7. Next step is to create and run a database in this environment. Note that this is intended for study only and test the amazing new features of 18c, following this article can make you probably face …

Continue reading