0 Comments

Important Technical Links Powered by DBsGuru 5 (4)

Important Technical Links Powered by DBsGuru About Us DBsGuru is a group of experienced DBA professionals and serves the database and its related community by providing technical blogs, projects, training. Technical blogs are the source of vast information not about databases but its related product like middleware, PL/SQL, replication methodology, and so on. We are […]

 1,772 Total Views,  3 Views Today

0 Comments

Enable Remote Connection on PostgreSQL 0 (0)

Enable Remote Connection on PostgreSQL In the previous blog, we saw How To Install PostgreSQL 13 on Linux. Click here to read more. By default, PostgreSQL installation is operating through a socket on the localhost. So remote connection will not work, To make it work we need to enable remote connection in couple of configuration […]

 38 Total Views,  4 Views Today

0 Comments

Install PostgreSQL 13 on Linux Using YUM Command 0 (0)

Install PostgreSQL 13 on Linux Using YUM Command  In this blog, we will see How to download and install PostgreSQL 13 on Oracle Linux Server release 7.9. You can get all required commands to install PostgreSQL on Linux from PostgreSQL documentation. Click here to download/follow the steps for PostgreSQL 13 on Linux. Once click on […]

 49 Total Views,  2 Views Today

0 Comments

Fixing OGG-01161 Bad Column Index (77) Specified for Tables 0 (0)

Fixing OGG-01161 Bad Column Index (77) Specified for the Table In this blog we will perform require steps to resolve OGG-01161 Bad column index (77) specified for the table in Oracle Goldengate, This error occurs when the target table doesn’t match the source table, there is a mismatch on columns between source and target. OGG Setup – […]

 46 Total Views,  2 Views Today

0 Comments

Unable to Add Trandata in Oracle Golden Gate (OGG) 0 (0)

Unable to Add Trandata in Oracle Golden Gate (OGG) In the process of data replication using Oracle GoldenGate (OGG ) the first step and important is assuring that all the needed information and changes have been written to the database redo log files. By default, the database does not write all the information that might […]

 47 Total Views,  1 Views Today

0 Comments

Fixing OGG-05500 Detected Database Metadata Mismatch Between Current Trail File 5 (1)

Fixing OGG-05500 Detected Database Metadata Mismatch Between Current Trail File In this blog we will perform require steps to resolve ERROR OGG-05500 Detected database metadata mismatch between current trail file OGG Setup – Source (Window Server) OGG Setup – Target (Linux Server) Step 1. Replicat Process Abended in Target: As you will notice Replicat RC232 […]

 60 Total Views,  3 Views Today

0 Comments

How to Fix ORA-10458 & ORA-01196 in Standby 11g (Roll Forward a Physical Standby Database) 0 (0)

How to Fix ORA-10458 & ORA-01196 in Standby 11g (Roll Forward a Physical Standby Database) This post presents a quick and efficient alternative to rebuilding a physical standby database in Oracle Database 11g Release 2 by using RMAN incremental backups to roll forward and resynchronize a physical standby database with the primary database or Fix ORA-10458 […]

 55 Total Views,  1 Views Today

0 Comments

Oracle Critical Database Patch IDs for April 2021 5 (1)

Oracle Critical Database Patch IDs for April 2021 An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the previous essential Patch Update informative. […]

 462 Total Views,  14 Views Today

0 Comments

How To Bootstrap MySQL Router For InnoDB Cluster 0 (0)

How To Bootstrap MySQL Router For InnoDB Cluster Bootstrap MySQL Router against an InnoDB Cluster to automatically configure the routing of incoming client connections to mysql instances. To bootstrap MySQL Router at the command-line, pass in the –bootstrap option when you start the mysqlrouter command, and it retrieves the topology information from the metadata and configures routing connections to […]

 94 Total Views,  5 Views Today

0 Comments

Changing InnoDB Cluster Topology in MySQL 0 (0)

Changing InnoDB Cluster Topology in MySQL By default, an InnoDB Cluster runs in single-primary mode, where the cluster has one primary server that accepts read and writes queries (R/W), and all of the remaining instances in the cluster accept only read queries (R/O). When you configure a cluster to run in multi-primary mode, all of […]

 85 Total Views,  3 Views Today

0 Comments

How to Setup MySql InnoDB Cluster 0 (0)

How to Setup MySql InnoDB Cluster MySQL InnoDB Cluster provides a complete high availability solution for MySQL. By using the AdminAPI included with MySql Shell, you can easily configure and administer a group of at least three MySQL server instances to function as an InnoDB Cluster. Each MySQL server instance runs MySQL Group Replication, which […]

 72 Total Views,  2 Views Today