Overview Until Oracle GoldenGate 11g, Oracle GoldenGate installation was fairly simple. You just unzip the software into a directory and create subdirs. Starting with Oracle GoldenGate 12c, Oracle GoldenGate software for Oracle Database is installed using Oracle Universal Installer (OUI). This change makes it easy for Oracle to audit software and licensing. You can Install Oracle GoldenGate 12c in 2 ways: Graphical User Interface (GUI)  Using response file (Silent) In this article I will demostrate how to Install Oracle GoldenGate 12c using response file on a full Rack Exadata DatabaseSEE DETAILS

Overview: Oracle Recovery Manager (RMAN) provides a comprehensive foundation for efficiently backing up and recovering the Oracle databases, it provides a common interface, via command line and Enterprise Manager, for backup tasks across different host operating systems, automates administration of your backup strategies. Prerequisites: Database should be in archive log mode. We need to have super user credentials. Steps to schedule Rman backup: Create Rman scripts Open textpad Set ORACLE_SID=<DB_Name> D:oracle11204product11.2.0dbhome_1BINrman.exe target / cmdfile= ‘F:Backup_scriptsdbname_rman_target.sql’ log=’F:Backup_scriptsdbname_target_backup.log’ Save and exit Run { Allocate channel c1 device type disk; Allocate channel c2<a class="more-link" href="https://netsoftmate.com/schedu...

Overview When you configure DBFS on Exadata, it recommended configuring a separate database to be used for DBFS. In this article we will demonstrate how to create a Database to store DBSF (Database File System) on Exadata Database Machine. Using DBCA (Database Configuration Assistance) Utility is the recommended method for creating a Database to store DBFS. Environment Exadata X4-2 Quarter Rack Steps to Create a Database Create a Database Login to the Exadata Compute node 1, export DISPLAY variable and Invoke DBCA utility Choose the first option “Real Application ClustersSEE DETAILS

Overview: Oracle Golden Gate provides very fast replication of data by reading transaction logs and writing the changes to one or more target databases in a homogeneous and heterogeneous environment. It is useful for High Availability Architectures and especially for Data Warehouse and Decision Support Systems. Thus, the variety of techniques and methods spreads from unidirectional environments for query offloading/reporting to bidirectional or Peer-to-Peer architectures in an active-active fashion. Environment Details Hostname Node1 and Node2 Operating system Linux Environment production Oracle Home /u01/app/oracle/product/11.2.0/db GoldenGate software staging location /u01/app/oracle/software/OGG12c GoldenGate Shared Home<a class="more-link" href="https://netsoftmate.com/installing-...

OverviewTo manage and monitor Exadata Database Machine you must discover it in Oracle Enterprise Manager. Before you discover Exadata DBM you first Install EM Agent on all Exadata Compute nodes. The Guided Discovery Process of OEM helps you discover all the Exadata Components easily. The following Exadata components can be monitored and managed by OEM: Compute NodesStorage CellsInfiniband SwitchesCisco SwitchesPower Distribution UnitsKVMIn this article I will demonstrate how to discover an Exadata Database Machine in OEM 13c. Discover Exadata in OEM 13c is no different than OEM 12c except couple ofSEE DETAILS

Overview We know that Exadata consists of Storage grid, compute grid and Network grid. Exadata Storage runs the Exadata storage server software which comes preinstalled and is responsible for satisfying database IO requests and implementing unique Exadata features like Smart scan, Smart Flash cache, and storage index and so on. The Exadata storage cell consists of: Hardware (Hard disk, Flash cache, Memory, Processor & IB ports) Exadata (Linux Operating System, Firmware, Exadata software) The Exadata storage software should be update periodically.  Oracle releases patches for Exadata to keep these componentsSEE DETAILS </...

Overview Oracle Exadata Database Machine consists of several components such as Compute nodes, Storage Cells, ILOM, Infiniband Switches, Cisco Switch and PDUs. So we need a tool that can manage all these components from one single console. Oracle Enterprise manager Cloud Control is the recommended best practices for monitoring and managing Exadata Database machine. Once the Exadata database Machine is installed the next step is enable monitoring for it. The following Exadata components can be monitored and managed by OEM: Compute Nodes Storage Cells Infiniband Switches Cisco Switches Power DistributionSEE DETAILS

Overview: Oracle Enterprise Manager is Oracle’s integrated enterprise information technology management product line, which provides the industry’s only complete, integrated, and business-driven enterprise cloud management solution. Oracle Enterprise Manager Cloud Control 13c is Oracle’s single, integrated solution for managing all aspects of the Oracle Cloud and the applications running on it. Media: Download the software from following link. http://www.oracle.com/technetwork/oem/grid-control/downloads/index.html Required Packages for Oracle Cloud Control Installation (Linux 6) make binutils gcc libaio glibc-common libstdc++ libXtst sysstat glibc glibc-devel glibc-devel.i686 Assumptions: Here we are assuming that: Oracle RDMS software Installed and Oracle<a class="m...

Overview After Oracle Platinum upgrades Oracle software for example from 11.2.0.3 to 11.2.0.4, the OLD Oracle Homes are not removed immediately. There are 2 different types of Oracle Home, Grid Infrastructure (ASM + Clusterware) home and RDBMS (Database software) home. In this article I will demonstrate how to De-install Oracle 11gR2 and 12cR1 Homes on Exadata database machine. Why De-install Oracle Software? One should consider de-installing Oracle software for the following reasons: To save disk space To ease management complexities To avoid accidentally using unused home About De-install Utility TheSEE DETAILS

Overview As we know Exadata database machine is a combination of Hardware and Software. Over a period of time these hardware and software can failure or give performance issues. In my experience I have seen hardware failures during the Exadata install and as well immediate after completion of Installation. But the newer generations of Exadata machines are more stable and you might find fewer hardware failures. When you work with Support on hardware, software or performance issues they would request you to run the following Diagnostic utilities and uploaded theSEE DETAILS

Overview This Blog contains steps to perform upgrading Oracle GoldenGate from 12.1.2.1.0 to 12.1.2.1.7. This chapter contains minimal upgrade that deploys only the updated core functionality, it is best practice to perform a minimal upgrade first, so that you can trouble shoot more easily in the event that any problems arise. Environment details Operating system Windows server 2012 R2 Environment production Oracle Home D:oracle11204product11.2.0dbhome_1 Golden Gate stage D:oraclegg_stage Golden Gate Home D:oraclegg_homeproduct12.1.2.1ggfor11 OGG Source version 12.1.2.1.0 OGG Target Version 12.1.2.1.7 Steps to perform Oracle Golden Gate upgrade. 1.   Download patchSEE DETAILS <span class="m...

Exadata was first launched in the year 2008 and it was names as Exadata V1. Since then Exadata has undergone many significant changes. In this article I will give a quick overview of Exadata history and changes made in each of the model. •         V1 –     First Exadata model released in 2008 –     It was a combination of HP hardware + Oracle Software –     Exclusively for Data Warehouse workload –     There were too many hardware failures noticed in this model –     Working with Hardware issues was not easy as itSEE DETAILS <span class="more-li...

What is Exadata Database Machine? Exadata Database Machine or simply known as Exadata is:           An Engineered System           A pre-configured combination of balanced Hardware and unique software           A unique platform for running Oracle Databases           Consists of Compute Grid, Storage Grid and Network Grid           A fully integrated platform for Oracle Database           Ideal for Database Consolidation platform           It provides High Availability and High Performance forSEE DE...

Overview: Oracle Golden Gate provides very fast replication of data by reading transaction logs and writing the changes to one or more target databases in a homogeneous and heterogeneous environment. It is useful for High Availability Architectures and especially for Data Warehouse and Decision Support Systems. Thus, the variety of techniques and methods spreads from unidirectional environments for query offloading/reporting to bidirectional or Peer-to-Peer architectures in an active-active fashion. Environment Details   Hostname PROD-DB1 Ip Address 10.78.101.3 Operating system Windows server 2012 R2 Environment production Oracle Home D:oracle11204product11.2.0dbhome_1 Golden GateSEE DETAILS <s...