Here, we have couple of puzzles, they are mainly:1- Why the database services are dynamically registered with non-default listener while the local_listener definition doesn't exist in the tnsnames.ora file?2- If you do some changes in the tnsnames.ora file related to the local_listener, are these changes dynamically reflected to the database and listener? or do you … Continue reading Why my Oracle Database is not dynamically registered with the Listener?
O/S-Error: (OS 5) Access is denied while upgrading Oracle 12c Database to 19c
Background: I was upgrading an Oracle Database version 12c(12.2.0.1) to version 19c (19.24) on Microsoft Windows.This is a manual command line line upgrade ( I didn't use DBUA).I started by doing some preparation tasks like::: Task #1: Run pre-upgrade checks:: Task #2: Run the preupgrade_fixups.sql:: Task #3: Connect to sqlplus and create pfile from pfile:: … Continue reading O/S-Error: (OS 5) Access is denied while upgrading Oracle 12c Database to 19c
Oradim not able to delete an Oracle database windows service
As an intermediate step in a database upgrade process, there is one step to delete an Oracle database Windows Service using the following command:oradim.exe -delete -sid POSDBBut, I received the following error message:O/S-Error: (OS 1072) The specified service has been marked for deletion. I tried many things, like:Closing the Task Manager.Ensuring event viewer, Microsoft Management … Continue reading Oradim not able to delete an Oracle database windows service
Oracle Database Hang, no one was able to connect
What is the problem? I received an email from the client that no one was able to connect to the database this morning (after 8:20 am).This case is a good example to show you how it is important to collect information about the issue from the concerned people before diving into the log files and … Continue reading Oracle Database Hang, no one was able to connect
OHUC-1026 : unable to authenticate the new password
One of my clients faced the following error, while starting an 12.2 database service on Windows:OHUC-1026 : unable to authenticate the new password Background: The client was trying to change the Oracle Home User password using the orahomeuserctl, after that he was not able to start the Database Windows Service. What is Oracle Home User? … Continue reading OHUC-1026 : unable to authenticate the new password
Oracle Database Hangs – FRA Space Issue
Although I feel (or claim) that I know how the FRA is working and I know much about the FRA mechanics, encountering FRA space issues consistently leads me to discover new insights and learn something new (very new). What was the issue? The Archiving process stopped working due to space shortage in the +FRA Disk … Continue reading Oracle Database Hangs – FRA Space Issue
SQL Developer Warning – could not install some modules
I have SQL Developer version 22.2 installed on my laptop, then I installed the latest version 23.1.1.Both of them are working fine, and I can run both of them simultaneously without any issue.I have also a separate installation for the Data Modeler version 23.1I restarted my laptop (I didn't restart it since more than one … Continue reading SQL Developer Warning – could not install some modules
Auditing Individual Functions/Procedures inside a PL/SQL Package
I got this question from one of my clients:How can I Audit Individual Functions/Procedures inside a PL/SQL Package?. Let us build a quick demo: This is just a sample package Let us try to enable this type of auditing using the following command:audit execute on scott.emp_pack.CreateEmp by access;I got the following error: As per Oracle … Continue reading Auditing Individual Functions/Procedures inside a PL/SQL Package
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”
Ahmed AbdelFattah Blog ! 