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

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%

Fully Recover Oracle Database from Block Corruption without backup

Disclaimer: The following recovery scenario is for a very specific case. It requires a comprehensive knowledge of the application schema design and the relationship between the different tables. It is not by any means valid for all block corruption cases. It not by any means a replacement for the regular database backups. Having a good … Continue reading Fully Recover Oracle Database from Block Corruption without backup

Oracle Database Security Assessment Sample Report

Highly Confidential Assessment Date & Time Date of Data CollectionDate of ReportReporter VersionSun Apr 25 2021 00:12:00Sun Apr 25 2021 00:22:012.2.1 (May 2020) - f3a1 Database Identity NameContainer (Type:ID)PlatformDatabase RoleLog ModeCreatedORCLCDBPDB1 (PDB:4)Linux x86 64-bitPRIMARYNOARCHIVELOGMon Jan 13 2020 20:12:00 Summary SectionPassEvaluateAdvisoryLowRiskMediumRiskHighRiskTotalFindingsBasic Information0000011User Accounts70222013Privileges and Roles156100022Authorization Control0020002Fine-Grained Access Control0050005Auditing08500013Encryption0110002Database Configuration92010113Network Configuration0110103Operating System2200105Total33201734279 Basic Information Database Version Oracle … Continue reading Oracle Database Security Assessment Sample Report

Installing SH Sample Schema

Preparation: Before running the installation script (sh_main.sql), please edit the following two files:sh_main.sql & sh_olp_c.sqlunder D:\app\db193\WINDOWS.X64_193000_db_home\demo\schema\sales_history and replace "__SUB__CWD__" with "D:\app\db193\WINDOWS.X64_193000_db_home\demo\schema" or the directory where you extracted the sample schema scripts. Here is a live demo about installation: https://www.youtube.com/watch?v=ZRodqYAUxtk ThanksAhmed