Contact

Category: Goldengate

SQL Developer Data Migration: A Simple Guide

If we talk about the Oracle SQL Developer data migration tool, which helps in migrating a non-Oracle database to an Oracle database, we are talking about one of the best […]

4 Reasons for Data Migration

The growth of technology has encourgaed businesses to use new strategies to handle the big data of their companies. One of the strategies is data migration. This method of transferring data moves […]

Oracle Database System Administration: Are You Safe?

The Oracle Database System Administration accesses all information and data related to the customers, finance, corporate relations, and property. The security is important and most business owners take necessary steps […]

What You Need to Set Up Oracle Goldengate

In order to set up or shift to the Goldengate, a company needs to create the necessary environment to favor this type of database system. There are many ways to […]

Seeking Fundamentals of Oracle Migration

It is quite known to the common public that Oracle is known for a provision of a wide range of “relative migration services” that necessarily transcends the transfer of data […]

Oracle Goldengate – unable to start integrated replicat – OGG-00446

For one of our projects, we upgraded Goldengate version to 12.2.0.1. After upgrading to newer version, I am able to successfully add new replicats. But when I tried starting the […]

Goldengate – Integrated Capture fails with OGG-02912

Here is one of my recent experiences running Oracle Goldegange 12.2.0.1 against Oracle 11.2.0.4 database. I was able to add Goldengate Extract Integrated process successfully without any issues. But when […]

Goldengate Integrated Extract – Identifying and resolving extract process hang issue

[vc_row][vc_column][vc_row_inner][vc_column_inner][vc_raw_html]R29sZGVuZ2F0ZSUyMGV4dHJhY3QlMjBwcm9jZXNzJTIwY2FuJTIwaGFuZyUyMGZvciUyMHZhcmlvdXMlMjByZWFzb25zLiUyMEl0JTIwaXMlMjB2ZXJ5JTIwaW1wb3J0YW50JTIwdG8lMjBoYXZlJTIwYSUyMHByb2Nlc3MlMjBpbiUyMHBsYWNlJTIwdG8lMjBtb25pdG9yJTIwZ29sZGVuZ2F0ZSUyMHByb2Nlc3MlMjBhbmQlMjBkZXRlY3QlMjBoYW5naW5nJTIwaXNzdWVzLiUyMEklMjByZWNlbnRseSUyMGVuY291bnRlcmVkJTIwR29sZGVuZ2F0ZSUyMEV4dHJhY3QlMjBIYW5nJTIwaXNzdWUuJTIwQmVsb3clQzIlQTBpcyUyMGhvdyUyMEklMjByZXNvbHZlZCUyMHRoaXMlMjBpc3N1ZSUzQSUwQSUwQUNvcHklMjB0aGUlMjBmb2xsb3dpbmclMjBTUUwlMjBhbmQlMjBzYXZlJTIwdG8lMjBmaWxlJTIwLSUyMGRiYV9jYXB0dXJlX2luZm8uc3FsJTNBJTBBJTNDcHJlJTNFJTNDY29kZSUzRWNvbCUyMENBUFRVUkVfTkFNRSUyMGZvciUyMGEyMCUzQiUwQWNvbCUyMFFVRVVFX05BTUUlMjBmb3IlMjBhMTUlM0IlMEFjb2wlMjBTVEFSVF9TQ04lMjBmb3IlMjA5OTk5OTk5OTk5JTNCJTBBY29sJTIwU1RBVFVTJTIwZm9yJTIwYTEwJTNCJTBBY29sJTIwQ0FQVFVSRURfU0NOJTIwZm9yJTIwOTk5OTk5OTk5OSUzQiUwQWNvbCUyMEFQUExJRURfU0NOJTIwZm9yJTIwOTk5OTk5OTk5OSUzQiUwQWNvbCUyMFNPVVJDRV9EQVRBQkFTRSUyMGZvciUyMGExMCUzQiUwQWNvbCUyMExPR01JTkVSX0lEJTIwZm9yJTIwOTk5OTk5OSUzQiUwQWNvbCUyMFJFUVVJUkVEX0NIRUNLUE9JTlRTQ04lMjBmb3IlMjBhMzAlM0IlMEFjb2wlMjBTVEFUVVNfQ0hBTkdFX1RJTUUlMjBmb3IlMjBhMTUlM0IlMEFjb2wlMjBFUlJPUl9OVU1CRVIlMjBmb3IlMjBhMTUlM0IlMEFjb2wlMjBFUlJPUl9NRVNTQUdFJTIwZm9yJTIwYTEwJTNCJTBBY29sJTIwU1RBUlRfVElNRSUyMGZvciUyMGEzMCUwQWNvbCUyMENBUFRVUkVfVFlQRSUyMGZvciUyMGExMCUzQiUwQVNFTEVDVCUyMENBUFRVUkVfTkFNRSUyQyUyMFFVRVVFX05BTUUlMkMlMjBTVEFSVF9TQ04lMkMlMjBTVEFUVVMlMkMlMEFDQVBUVVJFRF9TQ04lMkMlMjBBUFBMSUVEX1NDTiUyQyUyMFNPVVJDRV9EQVRBQkFTRSUyQyUwQUxPR01JTkVSX0lEJTJDJTIwUkVRVUlSRURfQ0hFQ0tQT0lOVF9TQ04lMkMlMEFTVEFUVVNfQ0hBTkdFX1RJTUUlMkMlMjBFUlJPUl9OVU1CRVIlMkMlMjBFUlJPUl9NRVNTQUdFJTJDJTBBQ0FQVFVSRV9UWVBFJTJDJTIwU1RBUlRfVElNRSUwQUZST00lMjBEQkFfQ0FQVFVSRSUzQiUwQSUwQSUzQyUyRmNvZGUlM0UlM0MlMkZwcmUlM0UlMEExLiUyMEV4ZWN1dGUlMjB0aGUlMjBmb2xsb3dpbmclMjBRdWVyeSUyMHRvJTIwaWRlbnRpZnklMjB0aGUlMjBzdGF0dXMlMjBvZiUyMGNhcHR1cmUlMjBhbmQlMjBpZGVudGlmaWVkJTIwdGhhdCUyMHRoZXJlJTIwaXMlMjBhJTIwZGlzLWNvbm5lY3QlMjBiZXR3ZWVuJTIwREIlMjBhbmQlMjBHRyUyMFByb2Nlc3MuJTBBJTNDcHJlJTNFJTNDY29kZSUzRVNRTCUyNmd0JTNCJTIwJTQwZGJhX2NhcHR1cmVfaW5mby5zcWwlMEElMEFDQVBUVVJFX05BTUUlMjBRVUVVRV9OQU1FJTIwU1RBUlRfU0NOJTIwU1RBVFVTJTIwQ0FQVFVSRURfU0NOJTBBLS0tLS0tLS0tLS0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tLSUyMC0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tLS0lMEFBUFBMSUVEX1NDTiUyMFNPVVJDRV9EQVQlMjBMT0dNSU5FUl9JRCUyMFJFUVVJUkVEX0NIRUNLUE9JTlRfU0NOJTIwU1RBVFVTX0NIQU5HRV9UJTBBLS0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tJTIwLS0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSUyMC0tLS0tLS0tLS0tLS0tLSUwQUVSUk9SX05VTUJFUiUyMEVSUk9SX01FU1MlMjBDQVBUVVJFX1RZJTIwU1RBUlRfVElNRSUwQS0tLS0tLS0tLS0tLSUyMC0tLS0tLS0tLS0lMjAtLS0tLS0tLS0tJTIwLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tJTBBT0dHJTI0Q0FQX0VEX0FQUF9CJTIwT0dHJTI0UV9FRF9BUFBfQiUyMDUwMDg4NzU5NjIlMjBESVNBQkxFRCUyMDUwNjE1NjQxMjYlMEE1MDYxNTY0MTE4JTIwTlVUUklRQSUyMDEzJTIwNTA2MTU2NDExOCUyMDA0LU5PVi0xNSUwQUxPQ0FMJTBBJTBBT0dHJTI0Q0FQX0VEX0FQUF9BJTIwT0dHJTI0UV9FRF9BUFBfQSUyMDUwMDc3NDEzNzIlMjBFTkFCTEVEJTIwNTA2MTY2ODMyNCUwQTUwNjE2NjgzMTQlMjBOVVRSSVFBJTIwMTIlMjA1MDYxNjY4MzE0JTIwMDQtTk9WLTE1JTBBTE9DQUwlMEElMEElM0MlMkZjb2RlJTNFJTNDJTJGcHJlJTNFJTBBMi4lMjBJJTIwdHJpZWQlMjBkb2luZyUyMG5vcm1hbCUyMHN0b3AuJTIwTm9ybWFsJTIwc3RvcCUyMGRpZCUyMG5vdCUyMHdvcmslMjBhcyUyMHRoZSUyMHByb2Nlc3MlMjB3YXMlMjBqdXN0JTIwaGFuZ2luZy4lMEElMEElM0NwcmUlM0UlM0Njb2RlJTNFR0dTQ0klMjAlMjhsb2NhbGhvc3QlMjBhcyUyMGdnYWRtaW4lNDBQUUFEQjIlMjklMjAzJTI2Z3QlM0IlMjBzdG9wJTIwRURfQVBQX0IlMEElMEFTZW5kaW5nJTIwU1RPUCUyMHJlcXVlc3QlMjB0byUyMEVYVFJBQ1QlMjBFRF9BUFBfQiUyMC4uLiUwQSUwQUVSUk9SJTNBJTIwc2VuZGluZyUyMG1lc3NhZ2UlMjB0byUyMEVYVFJBQ1QlMjBFRF9BUFBfQiUyMCUyOFRpbWVvdXQlMjB3YWl0aW5nJTIwZm9yJTIwbWVzc2FnZSUyOS4lMEElM0MlMkZjb2RlJTNFJTNDJTJGcHJlJTNFJTBBJTNDcCUzRTMuJTIwQXMlMjB0aGUlMjBwcm9jZXNzJTIwd2FzJTIwaGFuZ2luZyUyQyUyMEklMjBkaWQlMjAlMjJraWxsJTIyJTIwdGhlJTIwZXh0cmFjdCUyMHByb2Nlc3MuJTNDJTJGcCUzRSUwQSUzQ3ByZSUzRSUzQ2NvZGUlM0VHR1NDSSUyMCUyOGxvY2FsaG9zdCUyMGFzJTIwZ2dhZG1pbiU0MFBRQURCMiUyOSUyMDUlMjZndCUzQiUyMGtpbGwlMjBleHRyYWN0JTIwRURfQVBQX0IlMEFTZW5kaW5nJTIwS0lMTCUyMHJlcXVlc3QlMjB0byUyME1BTkFHRVIlMjAuLi4lMEElM0MlMkZjb2RlJTNFJTNDJTJGcHJlJTNFJTBBJTBBJTNDcCUzRTQuJTIwQ2hlY2slMjB0aGUlMjBjdXJyZW50JTIwc3RhdHVzJTIwYnklMjBpc3N1aW5nJTIwJTIyaW5mbyUyMGFsbCUyMiUyMGNvbW1hbmQlM0ElM0MlMkZwJTNFJTBBJTNDcHJlJTNFJTNDY29kZSUzRSUwQUdHU0NJJTIwJTI4bG9jYWxob3N0JTIwYXMlMjBnZ2FkbWluJTQwUFFBREIyJTI5JTIwNiUyNmd0JTNCJTIwaW5mbyUyMGFsbCUyMCUwQVByb2dyYW0lMjBTdGF0dXMlMjBHcm91cCUyMExhZyUyMGF0JTIwQ2hrcHQlMjBUaW1lJTIwU2luY2UlMjBDaGtwdCUwQSUwQU1BTkFHRVIlMjBSVU5OSU5HJTBBSkFHRU5UJTIwUlVOTklORyUwQUVYVFJBQ1QlMjBSVU5OSU5HJTIwRURfQVBQX0ElMjAwMCUzQTAwJTNBMDYlMjAwMCUzQTAwJTNBMDQlMEFFWFRSQUNUJTIwU1RPUFBFRCUyMEVEX0FQUF9CJTIwMDElM0EzMCUzQTA2JTIwMDAlM0EyNCUzQTQ4JTBBRVhUUkFDVCUyMFJVTk5JTkclMjBQRF9BUFBfQSUyMDAwJTNBMDAlM0EwMCUyMDAwJTNBMDAlM0EwMCUwQUVYVFJBQ1QlMjBSVU5OSU5HJTIwUERfQVBQX0IlMjAwMCUzQTAwJTNBMDAlMjAwMCUzQTAwJTNBMDclMEFSRVBMSUNBVCUyMFJVTk5JTkclMjBSRF9BUFBfQSUyMDAwJTNBMDAlM0EwMCUyMDAwJTNBMDAlM0EwMSUwQVJFUExJQ0FUJTIwUlVOTklORyUyMFJEX0FQUF9CJTIwMDAlM0EwMCUzQTAwJTIwMDAlM0EwMCUzQTA2JTBBJTNDJTJGY29kZSUzRSUzQyUyRnByZSUzRSUwQSUzQ3AlM0U1LiUyMFN0YXJ0JTIwdGhlJTIwZXh0cmFjdCUzQSUzQyUyRnAlM0UlMEElM0NwcmUlM0UlM0Njb2RlJTNFJTBBR0dTQ0klMjAlMjhsb2NhbGhvc3QlMjBhcyUyMGdnYWRtaW4lNDBQUUFEQjIlMjklMjA4JTI2Z3QlM0IlMjBzdGFydCUyMEVEX0FQUF9CJTBBU2VuZGluZyUyMFNUQVJUJTIwcmVxdWVzdCUyMHRvJTIwTUFOQUdFUiUyMC4uLiUwQUVYVFJBQ1QlMjBFRF9BUFBfQiUyMHN0YXJ0aW5nJTBBJTNDJTJGY29kZSUzRSUzQyUyRnByZSUzRQ==[/vc_raw_html][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row]

oracle archive log history

Here is the Oracle SQL script that comes handy to find out the number of archive logs that are generated by the database by day by the hour. set lines […]

  1. Pages:
  3. 1
  4. 2

Categories

Princeton ITS Network:

Hardware Support & Repairs: Princeton Service Center (Lenovo Authorized)  |  SaaS & SMB Solutions: Tech365.io