Category: Oracle Database General

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

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

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

Oracle 12.2 database is already available for more than 3 months. As expected, the first Patch Set for a given Release comes with a lot of bugs and we want as soon as possible a PSU to close all those gaps. However, I couldn’t find the PSU for the 12.2 version on the quarterly April 2017 …

Continue reading