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.0 - Production on Thu Aug 15 18:30:27 2024Version 19.21.0.0.0.0 Copyright (c) 1982, [...]
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.
Configuring Oracle Transparent Data Encryption (TDE) Read more "
In this post we are going to perform a case study using the Oracle Data Masking and Subsetting Pack, the process of permanently replacing sensitive data with dummy data to remove sensitive data from test, development, analytics and other non-production environments. Before
Oracle Data Masking Read more "
In this entry we are going to describe how to apply a patch to our database. In this example, our database is in version 19.3.0.0.0 and we are going to apply the patch 19.20.0.0 (Patch 35320081: DATABASE RELEASE UPDATE 19.20.0.0.0.0), although the procedure is usually similar I always recommend to read the README of the patches.
How to apply patch 19.20.0.0 in Oracle Database Read more "
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 intelligent search function of the main browsers, such as Chrome. That is to say, with this configuration you will have a mechanism where typing a predefined shortcut (normally
Oracle Database Error Help Portal Read more "
In version 19c Oracle introduced a very interesting feature, giving the administrator the possibility to create tables where only insert operations are allowed, where the deletion of rows is forbidden or can be restricted for a set time, as well as it is possible to restrict the deletion of a table. It is also possible to restrict the deletion of a table.
Oracle tables - Avoid drop and deletes (Blockchain Tables) Read more "
DBNEWID is a database utility that allows you to change the internal identifier of a database (DBID) and the database name (DBNAME). You can change only the DBID, the DBNAME, or you can change both the DBID and the DBNAME. This action before the appearance of the
Change the DBID and the name of a database (DB_NAME) with DBNEWID Read more "
Although it is less common to have to recover a database on the same machine than on a different host, in this entry we are going to indicate the necessary steps to be able to recover a database on the same host, in this case we are not using ASM as storage. The source database
Recover Database on the same Host with Rman Read more "
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
Hide / obfuscate PL/SQL code (WRAP) Read more "
With the Grid environment variables, we execute the following command: ./u01/app/oracle/21.0.0/grid/bin/asmca The ASM configuration graphical screen will appear, click on the "Disk groups" option and choose the disks that are going to belong to the diskgroup that we are going to create. They are disks that appear as "candidates" in the second column. Choose disks of the same size.
