0 Comments

RMAN Active Duplicate Database in Oracle from ASM to ASM 0 (0)

RMAN Active Duplicate Database in Oracle from ASM to ASM In a recent article, we demonstrated about Step by Step Migrate Database from Non-ASM to ASM in Oracle click here to know more about it. In this article, we will demonstrate step by step RMAN Active Duplicate Database in Oracle from ASM to ASM with […]

 35 Total Views

0 Comments

Free OCI Learnings/Certifications From Oracle along with Enroll steps for Certification 5 (2)

Free OCI Learnings/Certifications From Oracle along with Enroll steps for Certification Here is an exciting opportunity from Oracle to get certified at zero cost. Oracle has announced it will offer Oracle Cloud Infrastructure (OCI) training and OCI certification testing for free worldwide. The new program includes Oracle’s entire range of expert-created OCI learning curriculum for […]

 416 Total Views,  4 Views Today

0 Comments

Step by Step Migrate Database from Non-ASM to ASM in Oracle 5 (1)

Step by Step Migrate Database from Non-ASM to ASM in Oracle This article is a continuation of a recent article where we have demonstrated Offline Restore or Clone Database on the same server or rename database in Oracle click here to go through it. In this article, we will perform a Step by Step Migrate […]

 111 Total Views

0 Comments

Basics Of User Management in Oracle 5 (1)

Basics Of User Management in Oracle When a user logs on to the database, they connect to a user account by specifying an account name followed by an authentication method. Every user account must have a default tablespace. This is the tablespace where any schema objects created by the user will be stored. Permanent objects( […]

 153 Total Views

0 Comments

How to Find ROLE Creation Date in Oracle 5 (1)

How to Find Role Creation Date in Oracle In this article, we will prepare an SQL command for How to Find ROLE Creation Date in Oracle. View DBA_ROLES doesn’t have a column for ROLE creation date however we fetch other information about ROLE after creation. To achieve it we use the base table SYS.USER$ of […]

 177 Total Views,  1 Views Today

0 Comments

Validate Applied Patches in Database Oracle 19c 5 (1)

Validate Applied Patches in Database Oracle 19c In this article, we are going to demonstrate validate applied patches in Oracle 19c and 12c on both ORACLE HOME & DATABASE using various methods/options including container & pluggable database. Validation becomes important before and after the patch apply. Let’s begin practical. 1. Validation in ORACLE HOME First, […]

 214 Total Views

0 Comments

Offline Restore or Clone Database on the same server or rename database in Oracle 0 (0)

Offline Restore or Clone Database on the same server or rename database in Oracle In a recent article, we have demonstrated How to Rename Database using CONTROLFILE in Oracle, click here to go through it. In this article, we will demonstrate Offline Restore or clone Database on the same server with a new name or rename database […]

 266 Total Views

0 Comments

Upgrade Database (July 2021 Patch Apply 19c) 19.3 to 19.12 in Oracle 4.5 (2)

Upgrade Database (July 2021 Patch Apply 19c) 19.3 to 19.12 in Oracle In this article, we are going to demonstrate the upgrade database from 19.3 to 19.12. To achieve it we will apply patch 32904851 of July 2021 (19.12.0.0.210720) on Oracle database version 19.3.0.0.0 which is multitenant architecture (CDB & PDB). Here it’s the current […]

 1,186 Total Views,  2 Views Today

0 Comments

Oracle Critical Database Patch ID for July 2021 5 (2)

Oracle Critical Database Patch ID for July 2021 An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the previous essential Patch […]

 1,404 Total Views,  1 Views Today

0 Comments

How to Rename Database using CONTROLFILE in Oracle 0 (0)

Rename Database using CONTROLFILE in Oracle In a recent article, we have demonstrated How to Rename Database and DBID using DBNEWID in Oracle with all available options, click here to go through it. In this article, we are going to demonstrate How to Rename a Database using CONTROLFILE in Oracle. Existing database rename from source […]

 193 Total Views