Posts

Showing posts with the label error

MongoDB tip: Apply authentication option to a replica set, issue encountered and fix

Assuming we have a replicate set started as such, please refer to article 1  or article 2 to see how to configure a replica set if you haven't already done so and still have issues. Output of ps -ef | grep mongod root     20706     1  0 15:09 ?        00:00:01 mongod --port 31111 --replSet biDemo --dbpath /data/mongodb/demo1 --logpath /data/mongodb/demolog/1.log --fork  root     20943     1  0 15:10 ?        00:00:01 mongod --port 31112 --replSet biDemo --dbpath /data/mongodb/demo2 --logpath /data/mongodb/demolog/2.log --fork root     21101     1  0 15:11 ?        00:00:01 mongod --port 31113 --replSet biDemo --dbpath /data/mongodb/demo3 --logpath /data/mongodb/demolog/3.log --fork  Log into primary and add user, you will need at least one admin user to start and administer mongod with authentication enabled MongoDB Ente...

Oracle Goldengate Extract and Replicat within same DB from one schema to another plus some issues and fixes

This is a quick guide for GoldenGate replication within the same database from one schema to another. Dblogin and add checkpoint table GGSCI > dblogin userid ggs_owner, password ggs_owner GGSCI > add checkpointtable ggg.chk extract parameter file: es1.prm GGSCI > edit param es1 vi mode EXTRACT es1 SETENV (ORACLE_SID=orcl) SETENV (ORACLE_HOME="/a01/app/oracle/product/11.2.0/dbhome_1") userid ggg, password ggg EXTTRAIL /gg_01/app/goldengate/product/12.1.0/dirdat/ea WILDCARDRESOLVE DYNAMIC EOFDELAY 5 TABLE S1.T1; TABLE S2.T2; replicat parameter file: rs1.prm GGSCI > edit param rs1 vi mode REPLICAT rs1 ASSUMETARGETDEFS SETENV (ORACLE_SID=orcl) SETENV (ORACLE_HOME="/a01/app/oracle/product/11.2.0/dbhome_1") REPERROR (-1, IGNORE) REPERROR (1403, IGNORE) userid ggg, password ggg dboptions nosuppresstriggers HANDLECOLLISIONS MAP S1.T1, TARGET S2.T1; MAP S1.T2, TARGET S2.T2; Configure extract process: GGSCI > ADD EXTRACT ES1, TRAN...

Issue encountered and fix - Installing MongoDB on Redhat 7.x via yum

This is the version of redhat I am running [root@msdlva-dsnops03 ~]# lsb_release -a LSB Version:    :core-4.1-amd64:core-4.1-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-4.1-amd64:desktop-4.1-noarch:languages-4.1-amd64:languages-4.1-noarch:printing-4.1-amd64:printing-4.1-noarch Distributor ID: RedHatEnterpriseServer Description:    Red Hat Enterprise Linux Server release 7.3 (Maipo) Release:        7.3 Codename:       Maipo To start, we need to configure mongodb-enterprise repo https://docs.mongodb.com/manual/tutorial/install-mongodb-enterprise-on-red-hat/ This is the repo I used [root@msdlva-dsnops03 ~]# vi /etc/yum.repos.d/mongodb-enterprise.repo [mongodb-enterprise] name = MongoDB Enterprise Repository baseurl = https://repo.mongodb.com/yum/redhat/$releasever/mongodb-enterprise/3.4/$basearch/ gpgcheck = 1 enabled = 1 gpgkey = https://www.mongodb.org/static/pgp/server-3.4.asc [root@msdlva-dsnops0...