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 […]

 417 Total Views,  5 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 […]

 112 Total Views,  1 Views Today

0 Comments

KVM failed to start after ODA upgrade from 18.8 to 19.6 5 (1)

KVM failed to start after ODA upgrade from 18.8 to 19.6 Recent we had patched our ODA X7-2M (Baremetal) machine from 18.8 to 19.6 click here to read more about same both OS and Server patch was successful, But after ODA Server patched when tired to start KVM machine encounter below errors: error: Failed to […]

 70 Total Views,  2 Views Today

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( […]

 154 Total Views,  1 Views Today

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, […]

 215 Total Views,  1 Views Today

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

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,405 Total Views,  2 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