https://youtu.be/3N2wgayry4g ThanksAhmed
The beauty of Visualization with Oracle Database
What is the difference between Oracle RAC One Node and Oracle RAC?
https://www.youtube.com/watch?v=ZM6ckWFlyeM ThanksAhmed
What is the difference between object_id and data_object_id?
If you describe the dba_objects, you will find two IDs called: object_id & data_object_id, so , what is the difference between them? object_id is the primary key. Any object will have object_id irrespective, if it has an associated segment or not. For example, sequence, package, synonym are all objects with object_id but without any physical … Continue reading What is the difference between object_id and data_object_id?
Protected: Oracle RAC 12c Installation on Linux
There is no excerpt because this is a protected post.
Oracle Listener 19c Starting Error
While starting a newly created Oracle 19c Listener, I received the following errors; C:\Users\win>lsnrctl start LSNR19C LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 06-SEP-2019 13:58:09 Copyright (c) 1991, 2019, Oracle. All rights reserved. Starting tnslsnr: please wait… Unable to OpenSCManager: err=5 TNS-12560: TNS:protocol adapter error TNS-00530: Protocol adapter error The listener configuration file … Continue reading Oracle Listener 19c Starting Error
Install Error [DBT-50000] Unable to check for available memory
While creating an Oracle 19c database I received this error: Install Error [DBT-50000] Unable to check for available memory After some research, I found the following workaround, to start the dbca with specific option: dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false This fixed the error. ThanksAhmed
Oracle Database Password file presentation
https://youtu.be/sHUMO-uVYqU ThanksAhmed
Exadata – Flashcache Contents/objectNumber
This is a quick post about a question that I got about the objectNumber in the "list flashcachecontent" output, is it the same as object_id in the dba_objects in the database? Answer: No, objectNumber is not the same as object_id in dba_objects, actually it maps to the "data_object_id" not the "object_id" Example: Also, the tablespaceNumber … Continue reading Exadata – Flashcache Contents/objectNumber
Oracle Database 19c (19.3) Installation on Windows (Step-by-Step)
This is a quick post about installing Oracle Database 19c (19.3) on my laptop (Windows 10). Procedure will be presented as screen cast. As far as I remember, Oracle 19c was released during Mar-2019 for Linux, and during Apr-2019 for SPARC Solaris and during Jun-2019 for Windows,zLinux , HP and AIX Software Download: First of … Continue reading Oracle Database 19c (19.3) Installation on Windows (Step-by-Step)
Oracle Enterprise Manager Database Control & Time Zone
Background: Egypt time zone is GMT+2. Starting from year 1988, Egypt started to use the summer time zone (GMT +3) starting from the last Thursday of Apr till the last Thursday of September (5 months), then it reset back to GMT +2 for the remaining of the year. Summer time zone was cancelled at 20-Apr-2011, … Continue reading Oracle Enterprise Manager Database Control & Time Zone
Ahmed AbdelFattah Blog ! 