Skant Gupta is certified for: Microsoft Microsoft® Certified Technology Specialist: SQL Server® 2005 Microsoft® Certified Solutions Associate: Office 365 (MCSA) Microsoft® Specialist: Server Virtualization with Windows Server Hyper-V and System Center Specialist Microsoft® Certified Professional IBM IBM Certified Deployment Professional – Tivoli Directory Server V6.1 IBM Certified Associate Developer — Rational Application Developer for WebSphere Software […]
Monthly Archives: December 2017
Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials
Hi Readers Finally I’ve successfully passed 1Z0-337, Oracle Infrastructure as a Service Cloud 2017 Implementation Essentials. It was almost more than 2 months that I’ve been preparing for this. The Exam contains 60 questions related to Compute, Container, Networking and Ravello Services. To earn this certification you need to get 70% marks. This was the result of […]
Database Server Components of Exadata X7-2
Database Server Components of Oracle Exadata Database Machine X7-2 Oracle Exadata Database Machine X7-2 database servers include the following components: 2 x 24-core Intel Xeon Platinum 8160 Processors (2.10GHz) 384GB RAM 1.5T (24 x 64GB) with memory expansion kit 4 x 600 GB 10K RPM SAS disks, hot swappable, expandable to 8x Disk controller HBA […]
Oracle Exadata 18c and Database Machine X7-2
Oracle Exadata Database Machine consists of Oracle Database servers, Exadata Storage Servers, and the network components to connect to your network. Oracle Exadata Database Machine is available as a full rack, half rack, quarter rack or eighth rack. The following table lists the components included for each type of Oracle Exadata Database Machine. Components of […]
COLS & COLSEXCEPT FILTER in goldengate
Introduction:- We are going to have look at COLS & COLSEXCEPT FILTER in goldengate. First, we have mentioned the technical definition of COLS & COLSEXCEPT FILTER. after completing, we are going to learn about the steps use ofCOLS & COLSEXCEPT FILTER in goldengate . These parameters are used to Replicat only specific columns from the Source to […]
Schema replication using oracle goldengate
Being a DBA we are must aware of replication in DATA field. In this tutorial, we will explain how to do schema replication in goldengate. Schema replication means, replicating all the tables of a schema. This table explains about the HOST IP, DB_NAME, Goldengate Process, SCHEMA To Replicate. All steps mention the way to replication […]
Setting Up Table Replication In Oracle Goldengate
Today we are going to learn about the steps use for Setting Up Table Replication In Oracle Goldengate. In this below tutorial, we will setup one-way goldengate replication for below two tables from database SRCDB to TRGDB. DBACLASS.EMP; DBACLASS.DEPT; SOURCE TARGET HOST 172.65.47.32 172.20.21.56 DB_NAME SRCDB TEGAB GG PROCESS EXT1(extract) EXT1P(extract pump) REPR1 (replicat) TABLES DBACLASS.EMP […]