OGG-02024 Oracle GoldenGate Capture for Oracle, An attempt to gather information about the logmining server configuration from the Oracle database failed

OGG-02024  Oracle GoldenGate Capture for Oracle,  An attempt to gather information about the logmining server configuration from the Oracle database failed

OGG-00662  Oracle GoldenGate Capture for Oracle, OCI Error retrieving bind info for query (status = 100).

I mistakenly deleted an Integrated Extract process UODSEXT without unregistering the Extract first. The actual procedure to delete an Integrated Extract is, first it should be Unregistered and then it should be deleted.

If it is a Normal Extract, we can just delete it as usual.

I created the Integrated Extract process again and tried to register it but the below error occured.,

Since I did not unregister it and deleted the Integrated Process, I thought to unregister it and then register it again. But that too did not work. I was not able to unregister the Extract Process.

As Integrated Extract is tightly bind with the Oracle Database through Logminer, unlike Classic Extract, we should be careful with the Integrated Extract while creating and Deleting it.
While Registering the Extract Process, a Logminer session will be attached and a Capture Process will be created. So For each Integrated Extract there will be a Capture process and a Logminer Session attached to it.

I just queried the dba_capture and found the naming convention of the Capture Process by seeing the other Capture Process which was created.

From the above output,
OGG$CAP_TRAEXT here TRAEXT is my Integrated Name so I created a very simple Capture Process with the below command. Just forget about the RULE_SET_NAME. For Each Capture Process the RULE_SET will vary.

From the above output We can see that the Integrated Extract Process and the Datapump are in Stopped status.
There is only one Capture TRAEXT which is listed in the output.

SOLUTION

Connect as GoldenGate admin User and Create a simple Capture Process manually as said before.,

So now a simple Capture Process is created. Check if this listed in the output. Issue the below query to check it.,

Again tried to Register the Extract Process UODSEXT but it ended up with the error that “ERROR: This EXTRACT UODSEXT is already registered with the database.”

Start the Capture Process which is created manually.

Now the Capture process is started. Issue the below command to check if the Process is getting started or not.

Yes, now the Capture Process OGG$CAP_UODSEXT is getting Initialized which can be seen from the above output.

Later the State of the Capture has been changed which we can clearly see in the below result.,

Now the Integrated Capture is manually registered and it can be Unregistered now.
UnRegister the Integrated Extract Process UODSEXT.

The Extract has been Unregistered Successfully. In the below output we can clearly see that the Capture Process which was assigned to the Integrated Extract UODSEXT does not exists.

Now, let us check if we can able to register the Extract and also check if a Logminer Process is attached to the Integrated Extract / Capture process.,

Cool… The Extract UODSEXT has been registered successfully.

Here you can see the new Capture Name OGG$CAP_UODSEXT has been created.

We can clearly see, the process is getting Loaded. Later, it got loaded and was waiting for the Logs.,

Now you can Start the Integrated Extract Process UODSEXT and there will be no hurdles in it.

CONCLUSION:

Always be careful while Playing with Integrated Extract Processes. Its configuration is entirely different from the regular Classic Extract Process.

Hope this helped you a lot…..!!!!!!!!