Oerr is an Oracle utility that extracts error messages with suggested actions from the standard Oracle message files. This utility is very useful as it can extract OS-specific errors that are not in the generic Error Messages and Codes Manual. Many Oracle products on UNIX have a utility called OERR that can be used to aid error investigation.…
Today I want to write about one of the most used tools for migrating from Oracle to PostgreSQL. Ora2Pg is Free Software written and maintained by Gilles Darold. In this example Oracle database and the PostgreSQL database are running on the same server. I will show both variants of migration: Variant 1- Oracle and PostgreSQL running…
Switchover Operation Procedure: After configuring data guard, databases would be either primary and standby database role, and we can altered these roles without loss of data or without resetting logs called Switchover. A database can be in one of two mutually exclusive modes (primary or standby). These roles can be altered at runtime without loss…
Physical Standby Commands _________________________ To start redo apply in foreground: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE; To stop redo apply process on the Standby database (to stop MRP): SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; To start real-time redo apply: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;…
There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in elastic pool is essentially just Azure SQL Databases grouped into an elastic pool so you can maximize what you’re paying for and share the resources. Anyway,…
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…