Couple of days back, I started to get the following error, whenever I tried to connect to any Oracle Autonomous Database Cloud Service from SQL*Plus on my laptop (which was usually working fine for years):ORA-29003: SSL transport detected mismatched server certificate So, I reviewed the sqlnet.ora file under the working Oracle Home, and I found … Continue reading Getting ORA-29003 Connecting to Oracle Autonomous Database Cloud Service
How to find Top Hard Parsing SQL Statements?
Background:A hard parse occurs when a SQL statement has to be loaded into the shared pool. In this case, the Oracle Server has to allocate memory in the shared pool and parse the statement.A hard parse is a heavy process in terms of resources (CPU & Memory), and we should avoid whenever possible.Excessive hard parsing … Continue reading How to find Top Hard Parsing SQL Statements?
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%
Creating Oracle Database 21c on Windows
Oracle Database 21c Installation on Windows
Oracle Database 12.2.0.1 Release Updates (RUs) and Release Update Revisions (RURs)
Following is a list of all RU (Release Updates) and RUR (Release Update Revisions) issued for the Oracle Database 12cR2 (12.2.0.1) since Jul-2017 till today 20-Jun-2021. Please zoom-in to see the above picture clearly, or see it partitioned below: Please note that: - Both RU & RUR are released quarterly (Jan, April , Jul & … Continue reading Oracle Database 12.2.0.1 Release Updates (RUs) and Release Update Revisions (RURs)
Oracle Database 12c: Performance Management – Question 20
Oracle Database 12c: Performance Management – Question 13
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 Oracle OE Sample Schema
If you are interested in installing all oracle database sample schemas, please refer to my post:Installing Oracle Sample Schemas (19.3) If you want to install the scott demo schema, please refer to:https://ahmedfattah.com/2019/12/25/how-to-create-the-scott-oracle-database-demo-schema/ Here is a live demo about Order Entry (OE) schema installation: https://www.youtube.com/watch?v=c8dxF-1rGZo Please note that before installing the OE schema, you should first install … Continue reading Installing Oracle OE Sample Schema
Ahmed AbdelFattah Blog ! 