Discussions
Categories
- 385K All Categories
- 2.5K Data
- 568 Big Data Appliance
- 2K Data Science
- 452K Databases
- 222.3K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 573 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 575 SQLcl
- 4K SQL Developer Data Modeler
- 187.7K SQL & PL/SQL
- 21.5K SQL Developer
- 10 Data Integration
- 10 GoldenGate
- 297.6K Development
- 3 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 294.2K Development Tools
- 118 DevOps
- 3.1K QA/Testing
- 646.3K Java
- 30 Java Learning Subscription
- 37K Database Connectivity
- 185 Java Community Process
- 107 Java 25
- 22.1K Java APIs
- 138.3K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 172 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 573 LiveLabs
- 41 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 182 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 239 Portuguese
Stop pump from target host
Hello,
Target host got rebooted without pumps being stopped, resulting in lots of corrupted / incomplete trail files. Target host receives multiple trail files from multiple sources so coordinating with all of them to stop to the pumps before target host gets rebooted is not an easy task.
I couldn't find a manager / data collector command to gracefully stop the pumps.
Is there a way to stop the pumps from the target host without killing (kill -9) the "./server" processes (as that would result in corrupted trails too) ?
Thank you in advance!
Answers
-
Start a static collector process manually, i.e. not using mgrport but port on the extract side. When starting the collector (server executable program), use the -f option. See collector parameters in the reference.
-
Got it, thank you very much!
-
We don't have that functionality out of the box in Classic Architecture. You could create a script from the target to ssh to source and stop the pump if that's what you mean.
BTW, Microservices architecture resolves this problem. You should consider migrating.
Thanks,
Alex Lima
-
I don't have access to the source hosts, but it's good to know Microservices is an option.
Thank you!
-
So, the only way for you to stop the PUMP from the target will be to stop OGG completely, which will stop the server process and kill the connection from PUMP.
On the source, since the PUMP will present ABENDED.
-
Yeah, but killing the server processes to stop the connection results in a corrupted trail file (missing end-of-transaction)
It would be good to add some functionality to the collector / mgr in the TARGET host to send a signal to the PUMP to gracefully stop it, even if it would result in the pump being ABENDED - ERROR OGG-XXXXX collector terminated by target :)
Anyway, seems like unfortunately I'm out of options, it's either requesting all sources to stop the pumps or migrating to Microservices.
Thank you again, Alex!
-
No, not necessary. Since you still have the trail files in the source, you can re-transmit them without any corruption.
If you have deleted the source trail files, then yes, you are hosted. That's why I always recommend keeping the trail file for a # of days.
There will be no functionality like this added to Classic Architecture, as it has been deprecated.
Thanks,
Alex