000016745 - How to verify the replication status in RSA Authentication Manager 7.1.SP2

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000016745
Applies ToRSA Authentication Manager 7.1.SP2
IssueHow to verify the replication status in RSA Authentication Manager 7.1.SP2
[myhost@ssdmyrsa utils]$ ./rsautil manage-rep-error -a run-script -o primary_replication_status.sql
Enter master password: ************
 Manage Replication Error __IMS__VERSION__
 Copyright (C) 2006 RSA Security Inc. All rights reserved.
 %% running at: ssdrsa.mywebcompany.com:[xrgcqrvf] %%
Connected.
DECLARE
*ERROR at line 1:
ORA-20008: The current login user is invalid, please login as RSA_STREAMS_ADMIN
instead of SYS
ORA-06512: at "RSA_STREAMS_ADMIN.IMS_UTILS_PKG", line 3733
ORA-06512: at "RSA_STREAMS_ADMIN.IMS_UTILS_PKG", line 3754
ORA-06512: at "RSA_STREAMS_ADMIN.IMS_MONITOR_PKG", line 1744
ORA-06512: at line 4
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Data Mining and Real Application Testing options
 Done...
[myhost@ssdmyrsa utils]$
Resolution

The new command in 7.1 SP2 gives the replication status of various components in detail. This can be used to troubleshoot the replication.


cd utils


./rsautil manage-database -a exec-sql -U com.rsa.replication.admin -f diagnostics/primary_replication_status.sql


Example from a good Primary server:


[wsdoa00@ssdrsa 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 Security Inc. All rights reserved.
 %% Running at: ssdrsa.mywebcompany.com:[xrgcqrvf] %%
 ===========================================
 %             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 Tue Nov 10 13:31:38 2009
.
.Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
.
.
.Connected to:
.Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
.With the Partitioning, Data Mining and Real Application Testing options
.
.ENABLED
13:33:24 : capture_name => RSA_STREAMS_CAPTURE
.capture_status => ENABLED
.capture_state => CAPTURING CHANGES
.capture_error =>
.capture_time => 10-11-2009 01:32:50 PM
.used_arc_log_size => 4552
.max_arc_log_size => 102400
.min_arc_log_time => 04-11-2009 06:56:29 PM
.local_utc_time => 10-11-2009 09:32:50 PM -08
.remote_site_name => ssyrsarep.mywebcompany.com
13:33:24 : link_name => DK6MEQAC.IMS.RSA
.link_status => ENABLED
.link_error =>
.remote_utc_time => 10-11-2009 09:32:34 PM -08
.remote_capture_status => ENABLED
.remote_capture_state => CAPTURING CHANGES
.remote_capture_error =>
.remote_capture_time => 10-11-2009 01:32:51 PM
.remote_used_log_size => 942
.remote_max_log_size => 102400
.remote_min_log_time => 08-11-2009 05:52:12 AM
.local_propagation_status => ENABLED
.local_propagation_error =>
.local_propagation_num_msgs => 107336
.remote_propagation_status => ENABLED
.remote_propagation_error =>
.remote_propagation_num_msgs => 17917
.remote_apply_status => ENABLED
.remote_apply_error =>
.remote_apply_time => 10-11-2009 01:32:21 PM
.remote_apply_timeout =>
.remote_heartbeat_received_time => 10-11-2009 09:31:22 PM -08
.local_apply_status => ENABLED
.local_apply_error =>
.local_apply_time => 10-11-2009 01:32:45 PM
.local_apply_timeout =>
.local_heartbeat_received_time => 10-11-2009 09:32:13 PM -08
.remote_site_name => sbjrsarep.mywebcompany.com
13:33:24 : link_name => YSSLCYZ0.IMS.RSA
.link_status => ENABLED
.link_error =>
.remote_utc_time => 10-11-2009 09:32:40 PM -08
.remote_capture_status => ENABLED
.remote_capture_state => CAPTURING CHANGES
.remote_capture_error =>
.remote_capture_time => 10-11-2009 01:32:58 PM
.remote_used_log_size => 1045
.remote_max_log_size => 102400
.remote_min_log_time => 08-11-2009 02:07:17 AM
.local_propagation_status => ENABLED
.local_propagation_error =>
.local_propagation_num_msgs => 155116
.remote_propagation_status => ENABLED
.remote_propagation_error =>
.remote_propagation_num_msgs => 17317
.remote_apply_status => ENABLED
.remote_apply_error =>
.remote_apply_time => 10-11-2009 01:32:22 PM
.remote_apply_timeout =>
.remote_heartbeat_received_time => 10-11-2009 09:31:19 PM -08
.local_apply_status => ENABLED
.local_apply_error =>
.local_apply_time => 10-11-2009 01:33:15 PM
.local_apply_timeout =>
.local_heartbeat_received_time => 10-11-2009 09:32:07 PM -08
.remote_site_name => srdrsarep.mywebcompany.com
13:33:24 : link_name => XVW0U7JV.IMS.RSA
.link_status => ENABLED
.link_error =>
.remote_utc_time => 10-11-2009 09:32:47 PM -08
.remote_capture_status => ENABLED
.remote_capture_state => CAPTURING CHANGES
.remote_capture_error =>
.remote_capture_time => 10-11-2009 01:33:04 PM
.remote_used_log_size => 1858
.remote_max_log_size => 102400
.remote_min_log_time => 07-11-2009 08:36:34 AM
.local_propagation_status => ENABLED
.local_propagation_error =>
.local_propagation_num_msgs => 221463
.remote_propagation_status => ENABLED
.remote_propagation_error =>
.remote_propagation_num_msgs => 19362
.remote_apply_status => ENABLED
.remote_apply_error =>
.remote_apply_time => 10-11-2009 01:32:22 PM
.remote_apply_timeout =>
.remote_heartbeat_received_time => 10-11-2009 09:31:22 PM -08
.local_apply_status => ENABLED
.local_apply_error =>
.local_apply_time => 10-11-2009 01:32:54 PM
.local_apply_timeout =>
.local_heartbeat_received_time => 10-11-2009 09:32:12 PM -08
.remote_site_name => ssdrsarep.mywebcompany.com
13:33:24 : link_name => SHBFXIOO.IMS.RSA
.link_status => ENABLED
.link_error =>
.remote_utc_time => 10-11-2009 09:32:50 PM -08
.remote_capture_status => ENABLED
.remote_capture_state => CAPTURING CHANGES
.remote_capture_error =>
.remote_capture_time => 10-11-2009 01:33:05 PM
.remote_used_log_size => 1554
.remote_max_log_size => 102400
.remote_min_log_time => 06-11-2009 02:31:59 AM
.local_propagation_status => ENABLED
.local_propagation_error =>
.local_propagation_num_msgs => 237647
.remote_propagation_status => ENABLED
.remote_propagation_error =>
.remote_propagation_num_msgs => 25107
.remote_apply_status => ENABLED
.remote_apply_error =>
.remote_apply_time => 10-11-2009 01:32:23 PM
.remote_apply_timeout =>
.remote_heartbeat_received_time => 10-11-2009 09:31:21 PM -08
.local_apply_status => ENABLED
.local_apply_error =>
.local_apply_time => 10-11-2009 01:32:39 PM
.local_apply_timeout =>
.local_heartbeat_received_time => 10-11-2009 09:32:06 PM -08
.
.PL/SQL procedure successfully completed.
.
.SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
.With the Partitioning, Data Mining and Real Application Testing options


 Done...
[wsdoa00@ssdrsa utils]$
Notice that in the above output every component is in ENABLED status. If the above output shows "DISABLED" troubleshoot the particular component using SQL commands.


Replica installation fails at 91%


Run below reports on 7.1.SP2 Primary server send it to RSA Technical Support:


cd <am_home>/utils


 


rsautil manage-data -a exec-sql -f /usr/local/RSASecurity/RSAAuthenticationManager/utils/diagnostics/IMS_RepInfoRpt.sql -A info_<instance_name>.html -U com.rsa.replication.admin (This will create report)


 


rsautil manage-data -a exec-sql -f /usr/local/RSASecurity/RSAAuthenticationManager/utils/diagnostics/IMS_RepErrorRpt.sql -A error_<instance_name>..html -U com.rsa.replication.admin


 


Also, send RSA Authentication Manager\db\admin\<instance_name>\bdump\alert.log 


 

WorkaroundThe above command works only in Authentication Manager 7.1. This command has been changed in Authentication Manager 7.1 SP2.
Legacy Article IDa48479

Attachments

    Outcomes