El blog de oracle en Español

Categoría: Oracle

Install 19c step by step on Linux

This post the steps to Install Oracle Database 19c on Oracle Linux on Redhat 9 64-bit. We assume that the SSOO 9 version has already been installed. You can follow this link instructions on how to do this.https://bdconraul.com/instalacion-red-hat/ 1. Download the software on the support available, you can
Read More

Getting started with Oracle Apex

Once Oracle Apex (https://oracleconraul.com/index.php/2025/01/24/instalacion-oracle-apex-sobre-linux/) is installed, the first step is to create a new application. To do this, follow the steps below. The Oracle Apex home page is as follows: Click on the second option: The main screen will appear. To work in Oracle Apex, you need a Workspace. The first time you log in to APEX
Read More

Oracle ASM File System (ACFS) – Oracle Restart

In this post step-by-step post on how to implement Oracle ACFS in an Oracle RAC architecture.https://bdconraul.com/acfs/ Now, we’re going to configure the Oracle ASM File System (ACFS) in Oracle Restart. Although the steps are very similar to those detailed in the link , the configuration for the Oracle Restart architecture has some features that
Read More

Installing Oracle Apex on Linux

Simple guide on how Install Apex and ORDS on Linux systems in standalone format. Versions to Install this guide: APEX 24.1 Java23 ORDS 24.4 You can find the downloads at the following links: Download Required Software ) Download the latest version of Oracle Apex, in this case 24.1.https://www.oracle.com/tools/downloads/apex-241-downloads/Bajamos the file: Oracle APEX 24.1 – All languages 2) Download
Read More

PL/SQL package .DBMS_RCVCAT / CAT.DBMS_RCVMAN version in RCVCAT database is not current error

When you connect to your RMAN catalog and receive the following error, usually after a database upgrade: "RMAN.DBMS_RCVCAT / CAT.DBMS_RCVMAN version in RCVCAT database is not current error." [oracle@localhost ~]$ rman target sys/** catalog cat/**@CAT Recovery Manager: Release 19.0.0.0.0 – Production on Thu Aug 15 18:30:27 2024Version 19.21.0.0.0 Copyright (c) 1982,
Read More

Configure Oracle Transparent Data Encryption (TDE)

What is TDE and why is it important? TDE (Transparent Data Encryption) allows you to encrypt sensitive data stored in tables, tablespaces and even in database backups. This is crucial to protect sensitive information in case of unauthorized access. Important: Before applying TDE make sure you have a license.
Read More

How to apply patch 19.20.0.0 to Oracle Database

In this post describe how to apply a patch to our database. In this example, our database is version 19.3.0.0, and we are going to apply patch 19.20.0.0 (Patch 35320081: DATABASE RELEASE UPDATE 19.20.0.0.0). Although the procedure is usually similar, I always recommend reading the README file for the patches.
Read More

Help portal for Oracle database errors

Oracle has introduced a new, much faster and more interactive Error Portal. In this document, we show you how to configure it so that it can be used with the smart search function of major browsers, such as Chrome. In other words, with this configuration, you will have a mechanism where by typing a predefined shortcut (usually
Read More

Recovering Database on the same Host with Rman

Aunque suele ser menos habitual tener que recuperar una base de datos en la misma máquina que en un host diferente, en esta entrada vamos a indicar los pasos necesarios para poder recuperar una base de datos en el mismo host, en este caso no estamos usando ASM como almacenamiento. La base de datos origen
Read More
Oracle ACE Associate