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

Fixing OGG-05500 Detected Database Metadata Mismatch Between Current Trail File 5 (1)

Fixing OGG-05500 Detected Database Metadata Mismatch Between Current Trail File In this blog we will perform require steps to resolve ERROR OGG-05500 Detected database metadata mismatch between current trail file OGG Setup – Source (Window Server) OGG Setup – Target (Linux Server) Step 1. Replicat Process Abended in Target: As you will notice Replicat RC232 […]

 282 Total Views,  3 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

Oracle Database 19c RPM Installation On Oracle Linux 7 0 (0)

Oracle Database 19c RPM Installation On Oracle Linux 7 Oracle Database 19c can now be installed on Linux OS using an RPM.This post describes the steps for RPM based installation of Oracle Database 19c 64-bit on OEL 7 64-bit. Step 1. Prerequisite for Installation: Two most important things for rpm based installation is (1) You […]

 347 Total Views,  3 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