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
Polymorphic Table Functions in Oracle Database 18c
Oracle Database 18c New Features in one Image
The following map contains a high-level summary of the key Oracle Database 18c new features.Compared to Oracle Database 12.2, 18c has 134 new features in different focus areas. [Please zoom in to see the below image clearly] For detailed information about all new features, please refer to the :Oracle Database 18c New Features Guide We … Continue reading Oracle Database 18c New Features in one Image
ORA-28353: failed to open wallet
Problem Description: While configuring TDE, I created a new Keystore for an 18c database on Windows, but when I tried to open it, I received the following error:administer key management set keystore open identified by "oracle" container=all*ERROR at line 1:ORA-28353: failed to open wallet Procedure: Create folder: D:\app\db183\WINDOWS.X64_180000_db_home\network\admin\ORCL\walletEdit sqlnet.ora and add: ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=D:\app\db183\WINDOWS.X64_180000_db_home\network\admin\ORCL\wallet))) -- Create and … Continue reading ORA-28353: failed to open wallet
Ahmed AbdelFattah Blog ! 