replication
Warning: Low disk space. More than 75% of disk space allotted for replication on this instance is in use. If it reaches 100% this authentication and replication on this server will stop working and will eventually stop working on all instances. Run the manage-database CLU to increase the allotted disk space.
Data Transfer Status shows an error/warning (or strange message) in the RSA Operations Console > Deployment Configuration > Instances > Status Report
There are several commands that can be used at the command prompt to provide reports on the replication status between the RSA Authentication Manager primary and RSA Authentication Manager replica.
Please run these reports as the user specified during the installation of the software (e.g. for Windows it may be the local 'administrator', UNIX a specific user such as 'superadmin' or 'rsaadmin' for the SecuriD Appliance) from the <AM_INSTDIR>\utils folder and send the captured data and html reports to RSA Customer Support when reporting a replication issue.
1) rsautil manage-database -a exec-sql -U com.rsa.replication.admin -f diagnostics\primary_replication_status.sql
2) rsautil manage-database -a exec-sql -f diagnostics\IMS_RepLogRpt.sql -A log_instance.html -U com.rsa.replication.admin
3) rsautil manage-data -a exec-sql -f diagnostics\IMS_RepInfoRpt.sql -A info_instance.html -U com.rsa.replication.admin
4) rsautil manage-data -a exec-sql -f diagnostics\IMS_RepErrorRpt.sql -A error_instance.html -U com.rsa.replication.admin
Reports for 2), 3) & 4) are html formatted reports and are placed in the current folder (this would be the <AM_INSTDIR>\utils folder)
An example report using point 1)
| Usage on a WINDOWS platform where replication is working:
C:\Program Files\RSA Security\RSA Authentication Manager\utils>rsautil manage-database -a exec-sql -U com.rsa.replication.admin -f diagnostics/primary_replication_status.sql Enter password: *********** Confirm password: ***********
Manage Database ims-2.0.2-build20091007172001 Copyright (C) 2008 RSA Se curity Inc. All rights reserved.
%% Running at: am71sp2p.bellnet.local:[qiicuuli] %%
=========================================== % Execute SQL % =========================================== Are you sure you want to execute the SQL file [diagnostics/primary_replication_status.sql] ? (Y/N): y . .SQL*Plus: Release 10.2.0.4.0 - Production on Wed May 12 17:57:37 2010 . .Copyright (c) 1982, 2007, Oracle. All Rights Reserved. . . .Connected to: .Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production .With the OLAP, Data Mining and Real Application Testing options . .ENABLED 17:57:38 : capture_name => RSA_STREAMS_CAPTURE .capture_status => ENABLED .capture_state => CAPTURING CHANGES .capture_error => .capture_time => 12-05-2010 05:57:38 PM .used_arc_log_size => 1512 .max_arc_log_size => 102400 .min_arc_log_time => 05-05-2010 04:02:09 PM .local_utc_time => 12-05-2010 07:57:38 AM +10 .remote_site_name => am71sp2r.bellnet.local 17:57:38 : link_name => KHXTX42T.IMS.RSA .link_status => ENABLED .link_error => .remote_utc_time => 12-05-2010 07:57:38 AM +10 .remote_capture_status => ENABLED .remote_capture_state => CAPTURING CHANGES .remote_capture_error => .remote_capture_time => 12-05-2010 05:57:35 PM .remote_used_log_size => 1822 .remote_max_log_size => 102400 .remote_min_log_time => 03-05-2010 04:02:30 PM .local_propagation_status => ENABLED .local_propagation_error => .local_propagation_num_msgs => 16174 .remote_propagation_status => ENABLED .remote_propagation_error => .remote_propagation_num_msgs => 62 .remote_apply_status => ENABLED .remote_apply_error => .remote_apply_time => 12-05-2010 05:57:01 PM .remote_apply_timeout => .remote_heartbeat_received_time => 12-05-2010 07:56:59 AM +10 .local_apply_status => ENABLED .local_apply_error => .local_apply_time => 12-05-2010 05:57:33 PM .local_apply_timeout => .local_heartbeat_received_time => 12-05-2010 07:57:15 AM +10 . .PL/SQL procedure successfully completed. . .SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production .With the OLAP, Data Mining and Real Application Testing options
Done...
C:\Program Files\RSA Security\RSA Authentication Manager\utils> |
An example report using point 3)
| Usage on a WINDOWS platform:
C:\Program Files\RSA Security\RSA Authentication Manager\utils>rsautil manage-data -a exec-sql -f diagnostics\IMS_RepInfoRpt.sql -A info_primary.html -U com.rsa.replication.admin Enter password: *********** Confirm password: ***********
Manage Database ims-2.0.2-build20091007172001 Copyright (C) 2008 RSA Security Inc. All rights reserved.
%% Running at: am71sp2p.bellnet.local:[qiicuuli] %%
=========================================== % Execute SQL % =========================================== Are you sure you want to execute the SQL file [diagnostics\IMS_RepInfoRpt.sql] ? (Y/N): y . .SQL*Plus: Release 10.2.0.4.0 - Production on Wed May 12 10:08:21 2010 . .Copyright (c) 1982, 2007, Oracle. All Rights Reserved. . . .Connected to: .Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production .With the OLAP, Data Mining and Real Application Testing options . .**************************************************************** .<br> .* .<br> .* .<br> .* The report C:\Junkyard\C10184436\info_primary.html is generated successfully, thanks .<br> .* .<br> .* .<br> .* .<br> .**************************************************************** .<br> .Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production .With the OLAP, Data Mining and Real Application Testing options
Done...
C:\Program Files\RSA Security\RSA Authentication Manager\utils> |
NOTE: the actual report is the ?info_primary.html? file saved to the current folder. Using a different filename for the replica report would be advisable e.g. info_replica.html.
Here is an example of part of the data displayed in ?info_primary.html? where replication is working:
| Replication Process Status
SCN and redo log Status
DB Link Status
Propagation Process Status
count of received messages - v$propagation_receiver
? ? |
operating system update on the authentication manager server
Related Articles
SP4 installation fails and automatic restoration breaks the replication. Number of Views Audit logs events and their descriptions Number of Views How to address a customer request for Customer Support to perform RSA Web Threat Detection upgrade Number of Views How to create a compressed tar archive of the Oracle audit files in RSA Identity Governance & Lifecycle Number of Views Database fails to start with ORA-03113: end-of-file on communication channel error in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
How to recover the Application and AFX after an unexpected database failure in RSA Identity Governance & Lifecycle Troubleshooting AFX Connector issues in RSA Identity Governance & Lifecycle RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Release Notes for RSA Authentication Manager 8.8 RSA Authentication Manager 8.9 Release Notes (January 2026)
