Switching Replicat from Non-Integrated Mode to Integrated Mode

Valid for Oracle only. For more information about Replicat modes for an Oracle database, see Choosing Capture and Apply Modes in Using Oracle GoldenGate for Oracle Database.

This procedure switches an existing Replicat group from non-integrated to integrated mode.

Note:

Do not configure the switch between Replicat modes to occur immediately after Extract recovers from a failure or is repositioned to a different location in the transaction log.

Back up the Oracle GoldenGate working directories.
While the Oracle GoldenGate processes continue to run in their current configuration, so that they keep up with current change activity, copy the Replicat parameter file to a new name.
Grant the appropriate privileges to the Replicat user and perform the required configuration steps to support your business applications in integrated Replicat mode. See Assigning Credentials to Oracle GoldenGate in Using Oracle GoldenGate for Oracle Databasefor information about configuring and running Replicat in integrated mode.
Run the command line (Admin Client).
Stop Replicat.
```
STOP REPLICAT group
```
Log into the target database from GGSCI.
```
DBLOGIN USERIDALIAS alias
```
Where: alias is the alias of a user in the credential store who has the privileges granted through the Oracle dbms_goldengate_auth.grant_admin_privilege procedure.
Alter Replicat to integrated mode.
```
ALTER REPLICAT group, INTEGRATED
```
Replace the old parameter file with the new one, keeping the same name.
Start Replicat.
```
START REPLICAT group
```
Verify that Replicat is in integrated mode.
```
INFO REPLICAT group
```

When you start Replicat in integrated mode for the first time, the START command registers the Replicat group with the database and starts an inbound server to which Replicat attaches. When you convert a Replicat group to integrated mode, the use of the Oracle GoldenGate checkpoint table is discontinued and recovery information is maintained internally by the inbound server and by the checkpoint file going forward. You can retain the checkpoint table in the event that you decide to switch back to non-integrated mode.