When you initialize the Mirror Replication Agent instance using ra_init, Mirror Replication Agent executes the Adaptive Server sp_special_columns procedure in the primary database, while the database is quiesced, to get the information it needs for its system data repository.
Therefore, the metadata caches for open indexes and open objects in the primary Adaptive Server must be large enough to execute sp_special_columns against each table marked for replication in the primary database. The default value of the number of open indexes and number of open objects configuration parameters is 500.
If metadata caches in the primary Adaptive Server are not large enough, the execution of ra_init may be blocked in the Mirror Replication Agent until the primary database is unquiesced (update activity is resumed).
To avoid this problem, increase the values of the number of open indexes and number of open objects configuration parameters in the primary Adaptive Server to accommodate the number of tables marked for replication in the primary database, before you initialize the Mirror Replication Agent instance.
After the Mirror Replication Agent instance is initialized, you can restore the normal number of open indexes and number of open objects parameter values in the primary Adaptive Server.
