Installing Oracle Database 18.3 on Windows

Posted on by Ahmed Abdel Fattah

This is a quick post about installing Oracle Database 18.3 on my laptop (Windows 10). First of all download the software media file. You can download the media from: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-windows-180000-5066774.html The file name is called:WINDOWS.X64_180000_db_home.zip and it is about 4.5GB Create a folder under d:\app called db183 Unzip the media under this folder d:\app\db183 The … Continue reading Installing Oracle Database 18.3 on Windows

Oracle Database Guard 12c Implementation with RAC (Step-by-Step)

Posted on by Ahmed Abdel Fattah

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 Database Services in (Oracle RAC + Oracle Data Guard) Environment

Posted on by Ahmed Abdel Fattah

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 Database 12c Password File

Posted on by Ahmed Abdel Fattah

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