Transparent Data Encryption (TDE) provides mechanism to encrypt the data stored in the OS data files. TDE enables the encryption of data at the storage level to prevent data tempering from outside of the database. New commands has been introduced in oracle 12c for enabling Transparent data encryption. ADMINISTER KEY MANAGEMENT will replace the previous commands like ALTER…
First of all, What is a Load Balancer A load balancer can be deployed as software or hardware to a device that distributes connections from clients between a set of servers. A load balancer acts as a ‘reverse-proxy’ to represent the application servers to the client through a virtual IP address (VIP). This technology is…
In this below tutorial, we will setup one-way goldengate replication for below two tables from database SRCDB to TRGDB. PRESPLAY.EMP; PRESPLAY.DEPT; PREREQUISITE: Make sure the goldengate installation is completed and manager process is running on both source and target hosts. 1. Enable supplemental logging for those tables.[SOURCE] 2. Prepare extract parameter file[ SOURCE ] Here –…
Below are the steps for adding a new table to the existing extract and replicat. In this example, we will add PRESPLAY.SAL table to existing replication. 1.stop extract and pump process [ SOURCE] GGSCI > info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EXT1 00:00:00 00:00:00 EXTRACT RUNNING…
A quick Guide on How to Install the Oracle Database 12c Release 2 in Redhat Enterprise Linux 7.5 Server. To Download the Oracle Database Installer, Visit the below URL: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Prerequiste for Installation: Download the Oracle Database 12c installer package. The Swap Space size should be 16GB . Enable X11 Forwarding to “yes” in sshd…