BackgroundI asked one of my colleagues to download the latest opatch patch, in preparation to patching one oracle database 19c home on Oracle Linux platform (8.8).The old utility has version: 12.2.0.1.17 The latest downloaded utility has version: OPATCH_VERSION:12.2.0.1.40 Usually, I start by renaming the old OPatch directory, then extracting the new version under Oracle Home.This … Continue reading opatch version failed with error: Java (1.7) could not be located. OPatch cannot proceed!
VirtualBox: Not Able to Start my Important Virtual Machine
I have a couple of old (but important) virtual machines, that I run from time to time when I deliver a specific workshop.I didn't run these machines since couple of months. During this time I got my new laptop, which is more powerful than the old one. My Old Laptop specs: My New Laptop specs: … Continue reading VirtualBox: Not Able to Start my Important Virtual Machine
ORA-16778 and ORA-12514 while adding a standby database to a new Data Broker configuration
One of my customers re-created the data guard broker configuration, but he faces the following errors while adding the standby database:ORA-16778 and ORA-12514Environment: Primary: ORACLE_SID=proddb1 ORACLE_BASE=/u01/app/oracle PS1=$PWD<$ORACLE_SID> ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/db_home4 Standby: ORACLE_SID=proddb1 ORACLE_BASE=/u01/app/oracle PS1=$PWD<$ORACLE_SID> ORACLE_HOME=/u01/app/oracle/product/19.3.0.0/db_home4 The Standby database is configured correctly and is receiving and applying logs from the primary database, no gaps (still he didn't create … Continue reading ORA-16778 and ORA-12514 while adding a standby database to a new Data Broker configuration
How to change an Oracle OCI Compute Instance Name and Host Name?
There is an Oracle OCI compute instance (with Oracle Linux 8 as operating system). There is a request from a customer to change both the compute instance name and its hostname.Here are the steps to do that. Change the Compute Instance Name: This is very simple. Just navigate to the compute instance: Navigation Menu ==> … Continue reading How to change an Oracle OCI Compute Instance Name and Host Name?
Oracle Analytics Cloud – Data Modeler Connection Issue (ADF_FACES-60097)
I login to the Oracle Analytics Cloud (OAC), and I successfully created a database connection to the Autonomous Data Warehouse database on the same tenancy (Clicked on the "Create" button then Connection": Then I selected the connection type as "Oracle Autonomous Data Warehouse": Then I entered the connection Details: Connection was created successfully, and I … Continue reading Oracle Analytics Cloud – Data Modeler Connection Issue (ADF_FACES-60097)
Oracle OCI Storage Bucket – Error Browsing Buckets
Today I connected to one Oracle OCI Tenancy (Free Tier), and I navigated to the storage bucket to examine the buckets that I created before, but I received the following error:Error retrieving namespace. u.status is undefined. Also, I was not able to create any new buckets (another error message "Not Found" appeared"). It was a … Continue reading Oracle OCI Storage Bucket – Error Browsing Buckets
How to Install Oracle Apex 23.1?
Welcome to this tutorial on how to install Oracle Apex, step-by-step.In this video, we’ll be walking you through the process of installing Oracle Apex version 23.1 , with ORDS version 23.1.4, on one Oracle pluggable Database version 21c. Whether you’re a beginner or an experienced developer, this tutorial will help you get started with Oracle … Continue reading How to Install Oracle Apex 23.1?
Getting ORA-29003 Connecting to Oracle Autonomous Database Cloud Service
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?
Ahmed AbdelFattah Blog ! 