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

 56 Total Views,  4 Views Today

0 Comments

Upgrade Oracle Database from 12c to 19c using AutoUpgrade utility 5 (1)

Upgrade Oracle Database from 12c to 19c using AutoUpgrade utility Upgrading a database is always a big task for DBAs in this world but this time Oracle introduces a new feature in 19c for an upgrade which is called “AutoUpgrade Utility” where we will upgrade a database from version 12c to 19c. Supported version for upgrade […]

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

 96 Total Views,  3 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 […]

 119 Total Views,  8 Views Today

0 Comments

Step by Step Oracle 12cR2 Binary Installation and Database Creation On Linux 0 (0)

Step by Step Oracle 12cR2 Binary Installation and Database Creation On Linux In this article, we are going to demonstrate Step by Step Oracle 12cR2 (12.2.0.1) enterprise edition binary Installation and database Creation On Linux 7.9 (OEL) using GUI mode. We will complete this article in three parts. 1.  Prechecks / Prerequisite 2. Oracle 12cR2 binary […]

 287 Total Views,  4 Views Today

0 Comments

Oracle Critical Database Patch IDs for April 2021 5 (1)

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

 1,355 Total Views,  15 Views Today

0 Comments

Add & Drop Standby Redolog Files on Standby (Dataguard) in Oracle 0 (0)

Add & Drop Standby Redolog Files on Standby (Dataguard) in Oracle In this article, we are going to demonstrate add & drop standby redolog files on standby (dataguard) in Oracle. Drop or add standby redolog files require in case we resized/recreate redolog in PRIMARY so need to follow same on STANDBY database or some times […]

 443 Total Views,  2 Views Today

0 Comments

Steps to Create Active Physical Standby Dataguard Using RMAN Duplicate in Oracle 4 (1)

Steps to Create Active Physical Standby Dataguard Using RMAN Duplicate in Oracle In the previous article, we have configured a Physical STANDBYdatabase where we started MRP in mount state. In this article, we are going to demonstrate Steps to Create Active Physical Standby Dataguard Using RMAN Active Duplicate in Oracle database. Active dataguard features introduced […]

 597 Total Views,  20 Views Today

0 Comments

Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle 5 (2)

Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle Here we are going to demonstrate multiplexing of Control Files in Oracle using available options SPFILE, PFILE & RMAN. Before moving ahead first we will have a basic understanding of Control Files in Oracle. Control File is a physical file on OS level and […]

 606 Total Views,  2 Views Today

0 Comments

Step by Step Physical Standby Database Creation in Oracle 5 (3)

Step by Step Physical Standby Database Creation in Oracle Data Guard is used for disaster recovery and high availability. Due to any disaster, if our PRIMARY database got crash so, in that case, our STANDBY may become our PRIMARY database. Here, our client requirement, we need to create a STANDBY database using RMAN backup. Below […]

 760 Total Views,  8 Views Today