Categoria: Oracle Database General

Oracle Database General

fev 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 lendo

fev 22

Installing Oracle Database 18.0.0.0.0 binaries on Oracle Linux 7

In this article I will describe how to install the very first available release of Oracle Database 18c (18.0.0.0.0) binaries on Oracle Linux 7.2. Even though it's not officially released for on-premises yet (only Oracle Cloud), in edelivery it is available an Exadata DB version that is compatible with your local machine running OL. Please note that …

Continue lendo

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 lendo

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 lendo

out 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 lendo