Category: Oracle Database General

Oracle Database General

Jan 23

Dissecting 180116 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 180116? VERSION PATCH OWNER TYPE TOTAL ——————– ———- —————————— —————————— ———- 11.2.0.4 PSU & BP SYS PACKAGE 1 11.2.0.4 …

Continue reading

Jan 22

Implementing Oracle Connection Manager with High Availability

One of the biggest problemas we have in Oracle Cloud Infrastructure Classic is that when you provision an ExaCS you cannot assign “IP Network” addresses (as known as private IPs, eg: 10.x.x.x) to your ExaCS machine. That being said, you have only 2 options if you want to communicate your applications in Compute Classic (as …

Continue reading

Oct 19

Applying 171017 BP (26392124) over 170814 (26609769) returning “out of order” error.

Today I was trying to apply the Oracle Exadata Database 171017 BP (26392124) on top of 170814 (26609769) and I was getting the error below: [oracle@localhost 26392124]$ opatch apply Oracle Interim Patch Installer version 11.2.0.3.15 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version …

Continue reading

Oct 18

v$sga, v$sgainfo and v$sgastat matching bytes challenge

Those days I was challenging myself to make an exact match and correlate all lines returned by a select on v$sga, v$sgainfo and v$sgastat. The biggest problem on those v$ views is that they bring different visions of the same thing (SGA), and I could never make a exact match of the bytes before. Now …

Continue reading

May 25

Oracle 12.1.0.2 CDB creation – catcdb.sql returning ORA-22288 or ORA-29548

Those days I was trying to create an Oracle Database 12.1.0.2 CDB using only sqlplus in a Oracle Linux 6.5 64 bits. So after issuing the CREATE DATABASE command, it was time to create all the dictionary: $ sqlplus / as sysdba @?/rdbms/admin/catcdb.sql However, something was going wrong because both Oracle Java and Oracle Multimedia …

Continue reading