Mirror Replication Agent requires client access to the primary database to acquire information about the database schema and database log devices.
Use the following procedure to set up a user login name in the primary data server and the primary database for the Mirror Replication Agent instance.
You must have a System Administrator user role in the
primary data server to perform this procedure.
To create a primary database user login for Mirror Replication Agent
Log in to the primary data server with a System Administrator user role.
Add the Mirror Replication Agent login name to the primary data server, and if necessary, to the primary database.
Refer to the Appendix C, “Mirror Replication Agent and Oracle Databases” for information about the permissions and authorities required in each type of primary data server and primary database.
Refer to the documentation provided by your primary data server vendor for information about the specific commands you need to execute to create the Mirror Replication Agent login name in the primary data server (and, if necessary, in the primary database).
After you set up the Mirror Replication Agent user login in the primary data server, verify that the new user login name is valid (it can log in to the primary data server and access the primary database).