Just learned something new I couldn’t find actually in the doc at the first glance:
There’s a new init.ora parameter introduced in Oracle Database 11.2.0.4 named:
ENABLE_GOLDENGATE_REPLICATION
By default it is set to FALSE and the parameter got introduced because not only the external use of Oracle GoldenGate requires a valid license but also the use of the internal APIs. For example, XStream provides high performance APIs that enable client
applications to receive and send real-time data changes from an Oracle
database. Other APIs were added for encryption support, trigger
suppression, etc. None of these APIs are licensed with the Oracle
database itself – the license is included with an Oracle GoldenGate
license, and most of the APIs are not public.
So please make sure if you turn ENABLE_GOLDENGATE_REPLICATION=TRUE that you’ll need to have a valid Oracle GoldenGate license in place.
That will apply to 3rd party products such as Dell Shareplex as well in case they’ll switch it to true.
–Mike
—
Addition: As a customer talked to me about that during the Sydney workshop last week I’d like to point out that this paramater does not effect the use of Oracle GoldenGate as a stand-alone tool but only the internal interfaces inside the database.
