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

 52 Total Views,  10 Views Today

0 Comments

Upgrade Database (July 2021 Patch Apply 19c) 19.3 to 19.12 in Oracle 4 (1)

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

 355 Total Views,  29 Views Today

0 Comments

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

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

 491 Total Views,  17 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 […]

 99 Total Views,  2 Views Today

0 Comments

How to Rename Database and DBID using DBNEWID in Oracle 0 (0)

Rename Database and DBID using DBNEWID in Oracle In this article, we are going to demonstrate rename of the database along with DBID using utility DBNEWID in Oracle. The question comes in mind why we require to rename DB? Whenever we do clone a database to a target (clone DB) server from the source (production […]

 122 Total Views,  6 Views Today

0 Comments

Step by Step Upgrade Linux 8.2 to 8.4 (Oracle Enterprise Linux) 0 (0)

Step by Step Upgrade Linux 8.2 to 8.4 (Oracle Enterprise Linux) In a recent blog, we demonstrated Step by Step Install Linux 8 (OEL) along with Guest Addition, in this article, we will perform Step by Step Upgrade Linux 8.2 to 8.4 (Oracle Enterprise Linux).  To upgrade OEL 8.2 to 8.4, we will be using […]

 209 Total Views,  8 Views Today

0 Comments

Solution for [INS-08101] Unexpected error ‘supportedOSCheck’ while Oracle 19C Installation 0 (0)

Solution for [INS-08101] Unexpected error ‘supportedOSCheck’ while Oracle 19C Installation In this article we will solve error [INS-08101] Unexpected error while executing the action at state: ‘supportedOSCheck’.  Above error occurred while 19c (19.3) binary installation on server Oracle enterprise Linux version (OEL) 8.2 or greater than version 8.1 i.e Oracle 19c supported up to version […]

 269 Total Views,  3 Views Today

0 Comments

How to Grant READ ONLY Access on Schema Using ROLE in Oracle 0 (0)

How to Grant READ ONLY Access on Schema Using ROLE in Oracle This is a very frequent and common request by developers to grant READ ONLY access to specific application schema. To fulfill this request either we can grant SELECT privileges on all tables to requestor which are owned by specific application schema or create […]

 260 Total Views,  5 Views Today

0 Comments

Solution for ORA-00904: DBMS_FLASHBACK: invalid identifier in Oracle 0 (0)

Solution for ORA-00904: DBMS_FLASHBACK: invalid identifier in Oracle In this article, we will demonstrate a solution for ORA-00904: DBMS_FLASHBACK: invalid identifier in Oracle. This error reflects whenever the user tries to get access current system change number (SCN) without appropriate access.  To eliminate this error ORA-00904, we will grant EXECUTE on package DBMS_FLASHBACK or SELECT access […]

 219 Total Views,  3 Views Today

0 Comments

Step by Step Install Linux 8 (OEL) along with Enable Guest Addition 0 (0)

Step by Step Install Linux 8 (OEL) along with Guest Addition In this article, we are going to perform step by step install Oracle Enterprise Linux 8.3 along with Oracle VM VirtualBox 6.1.22 install, configure require hardware, network, memory, etc. on VM, and enable guest edition. To complete this demonstration, we will perform in the […]

 403 Total Views,  7 Views Today