Installing Oracle Database Sample Schemas (21c)

In this post, I’m going to explain how to install Oracle database sample schemas on Oracle database version 21c. Download the Scripts: Starting from Oracle database 12.2 ,the sample schemas setup scripts are now available from GitHub. Pick the release that matches your database release: https://github.com/oracle/db-sample-schemas/releases Extract the files: Extract the file “db-sample-schemas-21.1.zip” directly into $ORACLE_HOME/demo/schema, … Continue reading Installing Oracle Database Sample Schemas (21c)

ORA-01031 when using JSON Data Guide

What is JSON Data Guide? A JSON data guide lets you discover information about the structure and content of JSON documents stored in Oracle Database. Some ways that you can use this information include: Generating a JSON Schema document that describes the set of JSON documents. Creating views that you can use to perform SQL … Continue reading ORA-01031 when using JSON Data Guide

sqlcl java errors under different database homes

When trying to run the sqlcl version 22.1 on my new laptop (Windows 11 with many oracle database homes), I got the following errors: I have many oracle homes on my machine (Oracle Database 12cR1, 12cR2, 18c, 19c & 21c). After long research, it looks like that sqlcl pick the JRE under the environment ORACLE_HOME. … Continue reading sqlcl java errors under different database homes

Auditing Individual Functions/Procedures inside a PL/SQL Package

I got this question from one of my clients:How can I Audit Individual Functions/Procedures inside a PL/SQL Package?. Let us build a quick demo: This is just a sample package Let us try to enable this type of auditing using the following command:audit execute on scott.emp_pack.CreateEmp by access;I got the following error: As per Oracle … Continue reading Auditing Individual Functions/Procedures inside a PL/SQL Package

Oracle Database Performance Issue: High waits for “PX Deq: Slave Session Stats”

I had a customer who complains about performance issues on one of the oracle production database. Environment Oracle Database 12c R1 (12.1.0.2) on Linux with Oracle RAC (two nodes). To start with, I collected some AWR reports around the complain time, and I found the top wait events (most of the time) as follows: So, … Continue reading Oracle Database Performance Issue: High waits for “PX Deq: Slave Session Stats”

Oracle SQL Developer – Unsupported JDK error

Today, I was trying to install the latest version of Oracle SQL Developer on my Laptop.I have Oracle SQL Developer version 20.2 already installed, and I want to install the latest release (version 21.4.3) I downloaded the latest version from:https://www.oracle.com/tools/downloads/sqldev-downloads.html I extracted the downloaded file "sqldeveloper-21.4.3.063.0100-no-jre.zip",and launched the sqldeveloper, but I got the following error: … Continue reading Oracle SQL Developer – Unsupported JDK error

Oracle Exadata Administration Workshop (Jan-2022)

I'm going to run two Exadata Administration workshops during Jan-2022. Both of them will start on 01-Jan till 08-Jan: The first one will start at 2pm till 6pm (Language= English) The second one will start at 7pm till 11pm (Language= English + Arabic). For workshop content, registration and fees, please follow the following link:https://tinyurl.com/mrmbjnku ThanksAhmed

Oracle Database 19c Vault Operations Control

This is an extra layer of protection above the normal Database Vault Realms & Command Rules. In a multitenant database, you can now use Oracle Database Vault to block common users (infrastructure database administrators, for example) from accessing local data in pluggable databases (PDBs), even if you don't have the database vault enabled at the … Continue reading Oracle Database 19c Vault Operations Control

Oracle Database Vault New Features from 12.1 to 21c

Following is a high-level summary of all oracle database vault new features starting from Oracle Database 12R1 till Oracle Database 21c: Oracle Database Vault 12.1.0.1 new features Oracle Database Vault 12.2.0.1 new features Oracle Database Vault 18c new features Oracle Database Vault 19c new features Oracle Database Vault 21c new features