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 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
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
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
RMAN Full Database Backup Scripts in Oracle. In this article, we are going to prepare a script for RMAN full database backup which includes backup of datafiles, control files, spfile along with archives. This RMAN full database script will create a backup in a specified location (local directory) on the database server. Generally, we do
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
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
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
