0 Comments

Oracle Critical Database Patch ID for January 2023 along with enabled Download Link 5 (1)

Oracle Critical Database Patch ID for January 2023 along with enabled Download Link 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 […]

0 Comments

How to Find Current SCN in Oracle 0 (0)

How to Find Current SCN in Oracle In this acrticle, we will demonstrate different ways to find current SCN in Oracle. Follow the below SQLs to find SCN in Oracle. 1. Using V$DATABASE: Find the current SCN in the database using V$DATABASE. 2. Using DBMS_FLASHBACK: Find the current SCN in the database using DBMS_FLASHBACK. 3. […]

0 Comments

Steps to Apply Combo Patch (Oct 2022) on Clusterware in Two Node RAC in Oracle 0 (0)

Steps to Apply Combo Patch (Oct 2022) on Clusterware in Two Node RAC in Oracle In this article, we are going to demonstrate the Steps to Apply combo patch 34449117 (19.17.0.0.221018) of October 2022 on Oracle Clusterware in Two Node RAC version 19c. Here we will apply a combo patch 34449117 that contains two patches 34416665 (GRID) and 34411846 […]

0 Comments

Oracle Critical Database Patch ID for October 2022 along with enabled Download Link 5 (3)

Oracle Critical Database Patch ID for October 2022 along with enabled Download Link 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 […]

0 Comments

Solution for ORA-00600: Internal Error Code, Arguments: [4193] [2206] in Oracle 0 (0)

Solution for ORA-00600: Internal Error Code, Arguments: [4193] [2206} in Oracle In this post we will see How to solve ORA-00600: Internal Error Code, Arguments: [4193] [2206], You can encounter this error in Multitenant Environment (CDB) if your Oracle Database machine was suddenly stopped without proper shutdown command due to some unavoidable problem like Power […]

0 Comments

Oracle Critical Database Patch ID for July 2022 5 (3)

Oracle Critical Database Patch ID for July 2022 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 Update informative. […]

0 Comments

Steps to create a Database Link from Oracle to MSSQL Server 0 (0)

Steps to create a Database Link from Oracle to MSSQL Server Nowadays many companies are using a mix of RDBMS systems, for example, some instances are running on Oracle and other instances are running on MSSQL Server, and if we want to access data we need to do it using a heterogeneous connection. Heterogeneous connections allow us to query data from non-Oracle databases using SQL. In the previous two […]

0 Comments

How to Find Database Properties in Oracle 0 (0)

How to Find Database Properties in Oracle In this article, we will prepare a script for How to Find Database Properties in Oracle. Using the view DATABASE_PROPERTIES, we can fetch the default values of the database like the default permanent & temporary tablespace, dictionary endian type, character set, global database name, etc. Execute the below […]

0 Comments

Oracle Critical Database Patch ID for April 2022 5 (3)

Oracle Critical Database Patch ID for April 2022 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 Update informative. […]

0 Comments

Step by Step Manual Upgrade Container (CDB-PDB) Database from 12c to 19c in Multitenant Architecture 0 (0)

Step by Step Manual Upgrade Container (CDB-PDB) Database from 12c to 19c in Multitenant Architecture In a recent post, we demonstrated Step by Step Manual Upgrade Oracle Database from 12c to 19c, click here to read about it. In this article, we are going to demonstrate Step by Step Manual Upgrade Container (CDB-PDB) Database from 12c […]