How to Identify the Plan Hash Value With the Shortest Average Execution Time for Each SQL_ID in the Cursor Cache and Create SPM Baselines
Introduction In this blog post I’m sharing a query and a PL/SQL script that I created to identify all SQL_ID…
gridSetup.sh -switchGridHome fails with PRVG-2031 : Owner of file “<GRID_HOME>/bin/oradism” did not match the expected value on node
Problem While trying to switch to a Grid Home, the process failed with the following error: This issue can occur…
How to Change the ADMIN Password in the Exadata RoCE Switches
Introduction This is short blog post with quick demonstration in how to change the password for the ADMIN user in…
How to Clone a Non-CDB as a PDB in a CDB with Data Guard Configuration
Introduction I have provided help for some people from GUOB community a few times with questions about “how to clone…
Oracle Linux Error – qemu-kvm: unable to map backing store for guest RAM: Cannot allocate memory
Introduction I found this note about a issue I faced some time ago and noticed I forgot to post here…
How to Upgrade the Database Timezone File for a Specific PDB in Oracle RAC
Introduction A client has reported na issue while trying to execute a impdp against a PDB that failed with the…
RMAN Can Fail on Windows when Using SBT_LIBRARY Under “C:\Program Files”
Introduction A few weeks ago one client reached out to me asking to help him to configure a RMAN script…
How to Manually Import a ISO image in the OLVM host
Introduction I have been using OLVM for home lab purposes since 2021, and in this blog post I will show…
Grid Startup Fails with “WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libafd19.so” After Grid Infrastructure Patching
Introduction In this blog post I will share a example of issue that I faced sometime ago. This post was…
How to Convert Oracle TDE from Oracle Key Vault (OKV) to Local Wallet (FILE)
Introduction In this blog post I will show you a step by step for revert the TDE configuration from Oracle…