Home

By - rgonzalezpinto
Posted in Oracle

Upgrade PDB 19c 26ai Autoupgrade

In this post explain how to upgrade a database from 19c 26ai. To do this, I’ll walk you through the process using Autoupgrade Oracle Update Advisor to proactively identify and resolve issues before proceeding with the upgrade. On the same machine (oracle19cdb1), we’ll migrate a database

By - rgonzalezpinto
Posted in Oracle

Install Step-by-Step Guide to Installing Oracle AI Database 26ai Linux

In this post explain how Install Oracle Database 26ai Linux 9 in detail, step by step. 1- Download the software download the software, use the following link.software On this page, you will find the software available for download. Download the ZIP file for the Oracle platform

By - rgonzalezpinto
Posted in Oracle

Customize SQL*Plus

You may have occasionally needed to customize your connection to your Oracle database using SQL*Plus. In this post , I’ll walk post through the basics of how to do it. Follow this link: Customizing SQL*Plus The Database Blog

By - rgonzalezpinto
Posted in Oracle

Change the DBID and the name of a database (DB_NAME) with DBNEWID

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

By - rgonzalezpinto
Posted in Oracle

Creating a Virtual Network (VCN) in Oracle OCI

This link an example of how to create a Virtual Network (VCN) in Oracle OCI. Create VCN OCI

By - rgonzalezpinto
Posted in Oracle

Provision Database software Images Oracle OCI

In this post walk through an example of how to provision software in an OCI environment. As an example, we’ll provision a software image software an ExaCC Oracle Exadata on Cloud@Customer) environment. For our test, we’ll create an Oracle Database 26ai image 26ai can then be deployed to

By - rgonzalezpinto
Posted in Oracle

Oracle Data Masking

In this post carry out a practical case study using the Oracle Data Masking and Subsetting Pack. Data masking is the process of permanently replacing confidential data with fictitious data. The aim is to remove confidential data from testing, development, analytics, and other non-production environments. Before

By - rgonzalezpinto
Posted in Oracle

Oracle tables – Avoid drops and deletes (Blockchain Tables)

In version 19c introduced a very interesting feature, giving administrators the ability to create tables where only insert operations are allowed, where row deletion is prohibited or can be restricted for a set period of time, and where it is also possible to restrict table deletion. It is important to note that

By - rgonzalezpinto
Posted in Oracle

Install Autoupgrade by Step on Linux

At this link see how Install or update the Oracle Autoupgrade version. Update Oracle Autoupgrade Linux

By - rgonzalezpinto
Posted in Oracle

Patching Oracle databases with AutoUpgrade

In this post step by step how to patch an Oracle 19c database 19c AutoUpgrade. AutoUpgrade the tool recommended by Oracle to manage database updates more quickly, securely, and easily. We will also demonstrate how to use AutoUpgrade patch a database automatically and