ogg 11g刚开始支持integrated模式,需要打补丁+配权限
Database setup for Integrated Capture
We need to keep in mind the point that for full integrated capture support of all Oracle data and storage types, the compatibility setting of the source database must be at least 11.2.0.3.
Also, we need to apply the database patch 14551959 using opatch. Read the MOS note 1411356.1 for full details
After applying the patch 14551959 (the database and listener need to down to apply this patch) using opatch, we also need to do some post install steps as mentioned in the README.txt.
We need to start the database and run the postinstall.sql located in the patch directory.
This is to be followed by granting certain privileges to the GoldenGate database user account via the package
DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE as shown below. In this case the database user is ‘ggate’.
EXEC DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE( - grantee => 'ggate', - privilege_type => 'capture', grant_select_privileges=> true, do_grants => TRUE);
If the patch is not applied or the privileges not granted, we can expect to see an error like the one shown below:
2013-01-24 17:30:24 ERROR OGG-02021 This database lacks the required libraries to support integrated capture.