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.