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?
ORA-01017: invalid username/password; logon denied
I have a virtual machine with Oracle Database 19c installed. I downloaded this machine from Oracle. {If you are interested, you can download it from the following url: https://www.oracle.com/downloads/developer-vm/community-downloads.html } I started the virtual machine, login as oracle user, and ensured that the environment is set correctly: Then, I tried to login to the database … Continue reading ORA-01017: invalid username/password; logon denied
Installing Oracle Database Sample Schemas (21c)
In this post, I’m going to explain how to install Oracle database sample schemas on Oracle database version 21c. Download the Scripts: Starting from Oracle database 12.2 ,the sample schemas setup scripts are now available from GitHub. Pick the release that matches your database release: https://github.com/oracle/db-sample-schemas/releases Extract the files: Extract the file “db-sample-schemas-21.1.zip” directly into $ORACLE_HOME/demo/schema, … Continue reading Installing Oracle Database Sample Schemas (21c)
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 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%
Ahmed AbdelFattah Blog ! 