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
Oracle Cluster Node is Down, bad news
This is one of the difficult situations for any Oracle DBA, where you may receive wrong/conflicting messages from the end users, you may need to run many commands, examine many lengthy trace files, cooperate with other team members, contact vendor support teams. Yesterday, I got a complaint that the database/application is running very slow. I … Continue reading Oracle Cluster Node is Down, bad news
Oracle Single-Instance Database Creation in a Clustered Environment
How to Create Autonomous Datawarehouse Database (Always Free Services)?
https://www.youtube.com/watch?v=nOJowoCyw7Y ThanksAhmed
The beauty of Visualization with Oracle Database
https://youtu.be/3N2wgayry4g ThanksAhmed
Protected: Oracle RAC 12c Installation on Linux
There is no excerpt because this is a protected post.
Oracle Enterprise Manager Database Express 12c Overview
Oracle Database 12c introduced Oracle Enterprise Manager Database Express 12c. Oracle Enterprise Manager Express is a Web-based interface for managing an Oracle database. Using Oracle EM Database Express, you can perform basic administrative tasks such as user, performance, memory, and space management. Oracle Enterprise Manager Database Control is no longer available. EM Database Express is … Continue reading Oracle Enterprise Manager Database Express 12c Overview
Oracle Database Guard 12c Implementation with RAC (Step-by-Step)
Introduction: This is a real data guard implementation case for one of my clients. Data Guard is implemented between two clusters that reside on two different supercluster machines. The below procedure applies between any two clusters, it doesn't matter if it is a supercluster or Exadata or normal servers. I tried to put as much … Continue reading Oracle Database Guard 12c Implementation with RAC (Step-by-Step)
Protected: Oracle Data Guard 12c Switchover Issues
There is no excerpt because this is a protected post.
Oracle Database Services in (Oracle RAC + Oracle Data Guard) Environment
Introduction: We may classify the database services into two types of services : 1- Database Services 2- Cluster Managed Database Services Please note that: - The procedure dbms_service.start_service - used with the first type - is deprecated in databases managed by Oracle Clusterware and Oracle Restart with Release 11.2. While the procedure remains available in … Continue reading Oracle Database Services in (Oracle RAC + Oracle Data Guard) Environment
Ahmed AbdelFattah Blog ! 