Etiqueta: oracle database 19c

Oracle 19

Install Oracle 19c – RPM Package Mode

Simple and easy, as it should always be.

For years I wanted to witness this moment, install oracle database in a single, simple and fast method.

With the current CI-CD paradigm, continuous deployments, continuous delivery and continuous integration, Oracle really had to provide such a solution.

Through this methodology, which involves performing the installation and configuration of the database, in a simple and agile way, it can be part of a Jenkins process or TeamCity job.


We are going to review the steps that we are going to execute:

  • Configuration of the Operating System and Download Packages.
  • Installation of the database Software.
  • Install a Database, Oracle 19, Container and a PDB.
  • Install Listener and OS Services.

Hands On

Obtain the RPM file and configure the Operating System

On my case , I use Oracle Linux.

Oracle Linux Server release 7.2

I’m login as root , execute the yum commands.

Seguir leyendo «Install Oracle 19c – RPM Package Mode» →
Oracle 12c, Oracle 19

Oracle Database 19c, Now Available !

Oracle 19c

Hi Friends !

I’m come back to share the last recently news about the Oracle Databases.

Oracle Database 19c is the long-term support version of the Oracle Database 12c and 18c family of products, which is available to Premier and Extended Support customers through March 2023 and March 2026, respectively.

It is available on Linux, Windows, Solaris, HP / UX and AIX platforms, as well as Oracle Cloud.

Oracle Database 19c offers customers the best performance, scalability, reliability and security for all their analytical and operational workloads.

Oracle 19 c : https://docs.oracle.com/en/database/oracle/oracle-database/19/index.html

Oracle 19

How to RU Patch Deinstallation

Hello Guys !

I’m here again, to give an small explanation of why, we need know how to deinstall an Release Update.

Why ?

It’s depends, on my case, the last RU had some issues in the import datapump.

After review all cases and aply some workarounds, and debug and review all logs and traces with the ADRCI tool to stay sure of my desicion, deinstall.

Additional Documentation

I review the oracle document from MOS: Database 19c Release Updates and Revisions Bugs Fixed Lists (Doc ID 2523220.1)

Hands on

The first step is verificate the number of the RU, to start with the procediment:

select CON_ID,
TO_CHAR(action_time, 'YYYY-MM-DD') AS action_time,
PATCH_ID,
PATCH_TYPE,
ACTION,
DESCRIPTION,
SOURCE_VERSION,
TARGET_VERSION
from CDB_REGISTRY_SQLPATCH
order by CON_ID, action_time, patch_id;

This query help us, with the list of the number, to verified the last patch applied.

Seguir leyendo «How to RU Patch Deinstallation» →