Page 3

By - rgonzalezpinto
Published on Oracle

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.

By - rgonzalezpinto
Published on Oracle

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

By - rgonzalezpinto
Published on Oracle

Recovering Database on the same Host with Rman

Although it is generally less common to restore a database on the same machine than on a different host, in this post outline the steps required to restore a database on the same host; in this case, we are not using ASM storage. The source database

By - rgonzalezpinto
Published on Oracle

Hide / obfuscate PL/SQL code (WRAP)

Sometimes it is necessary to hide (obfuscate) our PL/SQL source code. This utility should be used judiciously, it is not about hiding all the available code, but only that which for security reasons, should not be shared with third parties. The method used has been traditionally performed with the WRAP tool, which we detail below

By - rgonzalezpinto
Published on Oracle

Add disks to ASM

With the Grid environment variables set, run the following command: ./u01/app/oracle/21.0.0/grid/bin/asmca The ASM graphical configuration screen will appear; click on the "Disk Groups" option. Select the disks that will belong to the disk group you are creating. These are the disks listed as "candidates" in the second column. Select disks of the same size.

By - rgonzalezpinto
Published on Oracle

Secure External Password Store

In many cases, it is necessary or advisable to connect to the database quickly and, above all, securely, without the database connection details being visible. One example, as indicated on the Oracle website, is when we connect to the database from scripts.

By - rgonzalezpinto
Published on Oracle

Restore a table with RMAN

In version 12c, many very useful new features were introduced. Among them is the ability to recover a table using RMAN. This feature applies to both Multitenant Multitenant architectures, allowing you to recover a table from a PDB necessary. The official note link be found at the following link : RMAN

By - rgonzalezpinto
Published on Linux

Adding Disks to ASM Linux UDEV Systems

In this post show you how to manually add disks to the Linux operating system. We will also explain how to set them up so that they can be used to store data from our Oracle database. First, we will list the disks we have in our virtual machine. There are two ways to do this:

By - rgonzalezpinto
Published on Oracle

Installing Oracle Restart 21c (Oracle Grid Infrastructure) on Oracle Linux 8

On this page, we will explain how to install a Grid infrastructure, specifically Oracle Restart 21c on Oracle Linux 8 with ASM udev). The installation is performed on a single server. In this case, we are starting with the following configuration: Memory: 9 GB Operating system: Linux 8.1 software disk: software GB 2 disks

By - rgonzalezpinto
Published on Oracle

How to Create a PDB

CREATING AN APPLICATION PDB "Application containers" are a feature of Oracle Database version 12.2. An "application container" is an CDB component used to store data and metadata for an application. A CDB zero or more application containers. Each application consists of a configuration, metadata, and shared objects.