Blog

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

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

For Loop in Oracle Database 21c and before 21c

This is a quick comparison between the "For Loop" in oracle database 21c and pre Oracle 21c.In Oracle Database 19c: set serveroutput ondeclare i number(5,1);begin for i in 1 .. 5 loop dbms_output.put_line (i); end loop;End;/ In Oracle Database 21c: set serveroutput onbeginfor i number(5,1) in 1 .. 6 by 2, reverse 7 .. 14 … Continue reading For Loop in Oracle Database 21c and before 21c

Oracle Database 21c Creation via DBCA hangs at 36%

Background I installed Oracle Database 21c on Windows 10 successfully. See the following video for the detailed installation steps: https://www.youtube.com/watch?v=QFovPSi8FKw After that I tried to create a sample database using the dbca (Database Configuration Assistant), but it hangs at 36%, as indicated in the following screen shot: If we examined the dbca log file: We … Continue reading Oracle Database 21c Creation via DBCA hangs at 36%