Oracle Goldengate Issue OGG-00664 OCI Error during OCIServerAttach (status = 12547-ORA- 12547: TNS:lost contact)

-

 I have recently encountered this issue

OGG-00664 OCI Error during OCIServerAttach (status = 12547-ORA- 12547: TNS:lost contact)

After doing some research, tried several approach, finally found a solution that worked for me

Approaches I tried that didn't work for me but seems to work for some people:

I have also listed the approaches in the order I tried them as sometimes some configuration we applied does help to achieve our resolution in the end. 

1. I noticed the os user I use to log into ggsci does not belong to the group oinstall which is the group that owns the oracle binary, so basically run the following, note that oragg is the os username that I use to run my ggsci

usermod -a -G oinstall oragg


2. Add the following lines the prm files

SETENV (TNS_ADMIN="<your oralce home>/network/admin")

SETENV (ORACLE_SID='<your oracle sid>')

SETENV (ORACLE_HOME="<your oracle home>")


I also did try (NOTE: my thought process was I don't need the old data, if you do need the old data, DON'T RUN THIS)

alter <extract process or replicat process>, begin now


so all of the above don't work, I still see the same error in the log. 

so I made one more modification to the prm files

ggsci> edit param <process>

used to be:

userid <gg user>, password <gg password>

changed to:

userid <gg user>@<oracle sid>, password <gg password>


This fixes my problem. If you are reading this, hope this helps! Enjoy!




Comments

Post a Comment

Popular posts from this blog

MongoDB Tips: Kill long running processes

-
This is just a quick and simple script to find all active opid that has been running over 10 seconds and they are running against the databases and collections you can specify in the "ns" filter. It's best to first run db.currentOp(    {      "active" : true,      "secs_running" : { "$gt" : 10 },      "ns" : {$in:["equipment.detachment","personnel.detail","personnel.unavailability","personnel.detachment"]}    } ).inprog.forEach(function (doc) { print(doc.opid); }) and verify your output before you execute the kill command in my experience to make sure you are killing the processes that are meant to be killed. Once verifed, simply run: db.currentOp(    {      "active" : true,      "secs_running" : { "$gt" : 10 },      "ns" : {$in:["<db1>.<col1>","<db2>.<col2>","<dbn>.<coln>...
Read more

Oracle Goldengate Extract, Pump, and Replicat

-
This is just a quick demonstration of setting up extract, pump, and replicate. I prefer to edit the prm files at OS level, but we can also do GGSCI> edit param esource to enter the vi mode to create the prm file. Here are the sample prm files used in the demonstration: prm files: -------------------------------- Source: (2 processes) ~~~~~~~~~~~~~~~~ esource.prm ~~~~~~~~~ EXTRACT ESOURCE SETENV (ORACLE_SID=source) SETENV (ORACLE_HOME="/source/app/oracle/product/11.2.0.3") userid ggg, password ggg EXTTRAIL /ggSource/app/goldengate/product/12.1.0/dirdat/es --Resolves the TABLES to be replicated when they first encounter a dml operation WILDCARDRESOLVE DYNAMIC --Reduce the system I/O overhead of redolog reads EOFDELAY 5 TABLE mine.table; psource.prm ~~~~~~~~~ EXTRACT PDWDSPRD SETENV (ORACLE_SID=source) SETENV (ORACLE_HOME="/source/app/oracle/product/11.2.0.3") userid ggg, password ggg RMTHOST targetServer.example.net, MGRPO...
Read more

MongoDB Ops Manager Basic Installation and Configuration

-
Image
This post is just a quick guide of MongoDB Ops Manager basic installation and configuration. The bare minimum of getting an instance of MongoDB Ops Manager up and running. We will be working with the latest version of the OpsManager, release version 3.4.7. Prerequisite: To start fresh, we remove any mongodb related RPM. I had Mongod installed as well, therefore, I have extras to be removed. [root@msdlva-dsnops01 ~]# yum autoremove $(rpm -qva | grep mongo) Loaded plugins: langpacks, product-id, rhnplugin, search-disabled-repos, subscription-manager This system is receiving updates from RHN Classic or Red Hat Satellite. Resolving Dependencies --> Running transaction check ---> Package mongodb-enterprise.x86_64 0:3.4.6-1.el7 will be erased ---> Package mongodb-enterprise-mongos.x86_64 0:3.4.6-1.el7 will be erased ---> Package mongodb-enterprise-server.x86_64 0:3.4.6-1.el7 will be erased ---> Package mongodb-enterprise-shell.x86_64 0:3.4.6-1.el7 will be erased...
Read more