Verifying the Oracle User Roles Created by the Replication Agent

Validate the required Oracle settings.

Use SQLPLUS to run this command as the new Oracle user:

select GRANTED_ROLE from USER_ROLE_PRIVS;
GRANTED_ROLE
--------------------
CONNECT
RESOURCE
SELECT_CATALOG_ROLE

The user who starts the Replication Agent instance must also have read access to the Oracle redo log files and the Oracle archive directory that contains the archive log files to be accessed for replication. If the Replication Agent is configured to remove old archive files, the user must have update authority to the directory and the archive log files.