KTEXPERTS – Page 15 – KNOWLEDGE SHARING PLATFORM

Oracle : Adding new table to existing GoldenGate Replication without downtime

3 years ago by Binnary Ajay KumarAdd new table to existing GoldenGate Replication

Adding new table to existing GoldenGate Replication In this article, we will add a new table in existing GG replication setup without downtime using filter (@GETENV (‘TRANSACTION’,’CSN’) > scn number); Source : GG11 Target : GG12 Source : Connect and Login to the ggsci

[oracle@GG11 19c12]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.1 OGGCORE_19.1.0.0.0_PLATFORMS_190524.2201_FBO
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.

[oracle@GG11 19c12]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 19.1.0.0.1 OGGCORE_19.1.0.0.0_PLATFORMS_190524.2201_FBO

Operating system character set identified as UTF-8.

Oracle : Shell script for RMAN backup of Standby Database

3 years ago by Binnary Ajay KumarOracle DB Admin

Oracle : Shell script for RMAN backup of Standby Database In this article, we wrote an automation job for Shell script for RMAN backup of Standby Database The below script will be initiating the RMAN backup on the standby database: RMAN Script : [oracle@tewnposqa1 scripts]$… Read More

Protected: Oracle : Shell Script to Send email if RAC services not running

3 years ago by Rakesh SahuOracle Production Support Scripts

There is no excerpt because this is a protected post.

CONFIGURING Object Storage & Archive Storage

3 years ago by Venkata Sai PavanOracle Cloud

CONFIGURING Object Storage & Archive Storage In this article we will learn about “CONFIGURING Object Storage & Archive Storage” Object Storage provides unlimited, high-performance, durable, and secure data storage. Data is uploaded as objects that are stored in buckets. It can store an unlimited amount… Read More

Autonomous Transaction Processing

3 years ago by Venkata Sai PavanOracle Cloud

Autonomous Transaction Processing In this article, we will know about “ATP” Oracle Autonomous Transaction Processing delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet the demands of a variety of applications: mission-critical transaction processing, mixed transactions and analytics, IoT, JSON… Read More

HOW TO CONNECT AND ACCESS ATP DATABASE

3 years ago by Venkata Sai PavanOracle DB Admin

HOW TO CONNECT AND ACCESS ATP DATABASE In this article, we will know “HOW TO CONNECT AND ACCESS ATP DATABASE” We can access ATP database through SQL developer for that we have to download wallet file of this particular database 1. Click on the ATP… Read More

Real-Time Use Case : IAM (Identity and Access Management)

3 years ago by Ramesh ReddyAWS

Dear Readers, In this article, we will see the following Realtime Usecase. Realtime Usecase : My Client swiggy wants to administrate theri technical Engineers as follows. They have team such as Developers,Database Admins,Linux Admins and storage admins.All the team should be in two levles L1… Read More

How to Install Oracle VM Virtual Box On Windows

3 years ago by Ramesh ReddyOracle DB Admin

Hi Dears, In this article, we will see Install Oracle VM Virtual Box On Windows. Oracle VirtualBox Oracle VM VirtualBox is a free, open-source, cross-platform application for creating, managing and running virtual machines (VMs). Virtual machines are computers whose hardware components are emulated by the… Read More

How to drop a Oracle RAC database manually

3 years ago by Binnary Ajay KumarOracle Architecture

How to drop a two-node Oracle RAC database database manually. In this article, we wrote an Clear steps for dropping a two node oracle database with Pre-requisite steps. Server: sewnpossqa01/02 Database : npossqa1 DB Unique name: sewnpossqa1 Step 1: Take consistent export of NPOSSQA1 database… Read More

AWS : Real Time Use Case On Storage

3 years ago by Ramesh ReddyEC2

Dear Readers, In this article, we will see the following Real-Time Use Case On Storage. Realtime Usecase : My Client, Nokia needs a Windows Server for Data Storage. So Launch a Server with three Additional Volumes. Volume capacities should be 10GB & 5GB. Duplicate the… Read More