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