Removing Oracle Database Software 12.2 (Grid + Database)

I have an Oracle Restart virtual machine that has both Oracle grid Infrastructure 12cR2 (12.2) and Oracle Database 12c R2 (12.2) + one CDB database called "orcl". I need to fully remove all oracle components from this machine. About the Deinstallation Tool Starting with Oracle Database 12c, the deinstallation tool is integrated with the database … Continue reading Removing Oracle Database Software 12.2 (Grid + Database)

What is the difference between Oracle RAC One Node and Oracle RAC?

https://www.youtube.com/watch?v=ZM6ckWFlyeM ThanksAhmed

Oracle RAC 12c Installation on Linux

https://www.youtube.com/watch?v=E0bNMbOUbf8 ThanksAhmed

Oracle Database Password file presentation

https://youtu.be/sHUMO-uVYqU ThanksAhmed

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)

Oracle Data Guard 12c Switchover Issues

Environment Primary: 2-nodes 12c RAC ASM Super Cluster Oracle Solaris Dedicated Network Interface for Data Guard Dedicated Listener for Data Guard Standby: 2-nodes 12c RAC ASM Super Cluster Oracle Solaris Dedicated Network Interface for Data Guard Dedicated Listener for Data Guard What is the Issue: Sometimes, when I do a Switchover I receive an error … Continue reading Oracle Data Guard 12c Switchover Issues

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

Oracle Data Guard 12c Testing Scenarios

Objective The objective of this post is to show the detailed steps for: Testing Read-Only access to the Standby DatabaseTesting Active Data Guard Access to the Standby DatabaseTesting Switching over/back to/from Standby DatabaseTesting Failover to the Standby Current Data Guard Environment Testing Read-Only access to the Standby Database On the current primary database create a … Continue reading Oracle Data Guard 12c Testing Scenarios

Oracle Database 12c Password File

Introduction: I (and we) used to see the oracle database password file under $ORACLE_HOME/dbs for both single instance and RAC databases. Example for RAC database: On node1 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwPROD1 On node2 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwPROD2 If one password file was changed in one node, then you have to copy it to all other nodes in the cluster. What is … Continue reading Oracle Database 12c Password File

How to Enable Archivelog Mode for an Oracle database

This is a quick post about the steps required to enable the ARCHIVELOG mode for an oracle database (Single Instance or RAC) To check if the archive log mode is enabled or not, use the following command: SYS@XPS 01-SEP-18 SQL> archive log list Database log mode               No Archive Mode … Continue reading How to Enable Archivelog Mode for an Oracle database