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?
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
[DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.
Background: A customer has an Oracle Database version 12.2.0.1 on Windows server. He asked to upgrade this database to 19c (19.17) on the same server. Procedure: I installed Oracle 19c (19.3) on a new oracle home on the same server.(During the installation I selected "Windows Virtual Account" as the Oracle Home owner) I applied the … Continue reading [DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.
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 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
Introduction to Oracle RAC One Node
ORA-03113 when running a specific query
I got a question from one of my clients that he has a query that he used to run it successfully on Oracle Database 10g,but when he run the same query on Oracle Database 12.1.0.1, the query failed and the connection dropped with the following errors: He confirmed many times that the same query with … Continue reading ORA-03113 when running a specific query
Ahmed AbdelFattah Blog ! 