How to Create Autonomous Datawarehouse Database (Always Free Services)? 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 Database Migration to Exadata – Case Study

Objective: This report will show the detailed steps that we followed to migrate a real client production database from its current production server to the Exadata machine. Environment:  SourceTargetServer Nameprod-n-214exa-db-101Database NamePRODPRODOracle version11.2.0.311.2.0.3O.SLinux OEL 6.5Exadata OEL 6.8Character setWE8ISO8859P1WE8ISO8859P1Clustered:Single InstanceSingle Instance Migration High Level Plan: Migration Preparation.Backup the production database.Duplicate the production database to Exadata.Post Migration stepsValidate … Continue reading Oracle Database Migration to Exadata – Case Study

Oracle tnsnames.ora Distribution Management System!

What? Does tnsnames.ora file need a Distribution Management System? In our case, the answer is yes. It is a headache to implement our client requirements without some sort of automation. What is tnsnames.ora file? tnsnames.ora is a text file that resides on the ORACLE_HOME/network/admin and contains some simple information about our databases connection information, it … Continue reading Oracle tnsnames.ora Distribution Management System!