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
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
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
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
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
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
How to Fix ORA-10458 & ORA-01196 in Standby 11g (Roll Forward a Physical Standby Database) This post presents a quick and efficient alternative to rebuilding a physical standby database in Oracle Database 11g Release 2 by using RMAN incremental backups to roll forward and resynchronize a physical standby database with the primary database or Fix
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.
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
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
