Infrastructure at your Service

All posts by Vincent Matthey

Vincent Matthey
consultant

Vincent Matthey holds a Bachelor in business administration and informatics from the University of Applied Sciences Western Switzerland (HES-SO ARC) in Neuchâtel. He also holds a degree from the École Supérieure d'Informatique de Gestion, Delémont. Vincent is ITIL V3 Foundation certified. Vincent Matthey has solid basis in MySQL technologies and Oracle technologies (DBA, Backup & Recovery and Linux). During his studies, Vincent Matthey completed various internships as Database application developer.
Vincent Matthey

GoldenGate 12.2 – Installation of the monitoring agent

By | Database Administration & Monitoring | No Comments

As described in my last post, GoldenGate Studio requires the monitor agent on each GoldenGate instance. The goal of this agent is to allow GoldenGate Studio to interact with GoldenGate, for example, to deploy a new solution. So lets start with the installation of the agent. Download The first step is to download the monitor agent (Oracle GoldenGate Monitor). It is available here. Installation The second step is to install the product. After you have…

 
Read More
Vincent Matthey

GoldenGate Studio 12.2 – Create repository

By | Database Administration & Monitoring | One Comment

In a previous blog I explained you how to install GoldenGate Studio. This time the goal is to describe how to create the repository required by GoldenGate Studio. Oracle provides a tool to create all the repository data required by GoldenGate Studio. Its name is RCU for Repository Creation Utility. Create repository The first step is to go to the folder GOLDENGATESTUDIO_HOME/oracle_common/bin. In this folder there is the RCU executable. Launch it: oracle@goldengate122:/u04/app/goldengate/product/ggstudio122/oracle_common/bin/ [DB1] ./rcu…

 
Read More
Vincent Matthey

GoldenGate Studio 12.2 – Installation

By | Database Administration & Monitoring | No Comments

Today I will present you the new product GoldenGate Studio which was announced at the last Oracle Open World. This product allows to design the replication flows and deploy a solution with a graphical tool. Download The first step is to download GoldenGate Studio. It is available here. Installation The second step is to install the product. After you have transferred the installer to the server decompress it. oracle@goldengate122:/tmp/goldengate_studio/ [rdbms12102] ll total 2035484 -rw-r–r– 1…

 
Read More
Vincent Matthey

GoldenGate 12.2 parameter file check

By | Database Administration & Monitoring | No Comments

Today I will talk about the new parameter file checks available to continue the series of blog posts about the new features of GoldenGate 12.2. There are three themes that I will present you: Checkprm utility Info param Getparaminfo Checkprm utility This utility can be used to validate a parameter file (.prm). It is located in the home of the GoldenGate installation. oracle@goldengate122:/u04/app/goldengate/product/12.2.0.0/DB1/ [DB1] ll | grep check -rwxrwxr-x 1 oracle oinstall 11216170 Nov 10…

 
Read More
Vincent Matthey

GoldenGate 12.2 additional column on the target

By | Database Administration & Monitoring | One Comment

My colleague Hervé last week posted a blog concerning a bug in GoldenGate 12.1. You can find the blog here. In fact the problem is that GoldenGate works with the column position and not with the column name. To follow up this bug I tried to reproduce that with GoldenGate 12.2 that was released last week. As Hervé did I used the schema scott/tiger. The goal is not to test an initial load. Source>@utlsampl.sql Target>@utlsampl.sql…

 
Read More
Vincent Matthey

GoldenGate 12.2 new parameter ALLOWOUTPUTDIR

By | Database Administration & Monitoring | 9 Comments

I will start a series of blog posts about the new features of GoldenGate 12.2. This first blog will be concerned by the new parameter ALLOWOUTPUTDIR. When I tried GoldenGate 12.2 for the first time, I reused the same configuration as with GoldenGate 12.1. It means two virtual machines with OEL 6.5 and Oracle Database 12.1.0.2.4 Enterprise Edition. First I configured my SCOTT extract process without problems. It was the same for the REPSCOTT replicat…

 
Read More
Vincent Matthey

GoldenGate – Error during a register extract

By | Database Administration & Monitoring | 2 Comments

This week, I tried to install a GoldenGate environment to make some test. The installation was good and simple. Firstly I tested the normal capture mode and all worked correctly. In a second time, I wanted try to use the integrated capture mode. When arrived the time to register my extract in the database, I have received an error. GGSCI (goldengate as ggadmin@DB1) 2> register extract test database ERROR: Cannot register or unregister EXTRACT TEST…

 
Read More