000023182 - Oracle replication troubleshooting scripts included with Authentication Manager 7.0

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

Article Content

Article Number000023182
Applies ToTHIS SOLUTION IS FOR INTERNAL USE ONLY - DO NOT DISTRIBUTE
Authentication Manager 7.0
Windows 2003 Server SP1
NotesThe following scripts are in the utils\diagnostics directory.  Note that these used within the rsautil manage-replication  CLU, but can also be run manually using sqlplus.  To run them get the sysman user and password by running the rsautil manage-secrets CLU, then connect to the database using sqlplus sysman/password.  From there just type start filename.sql. 

apply.sql:   Apply all the transaction in the apply error queue.
apply_t.sql: apply the specific transactions in the apply error queue.
applylatencymonitor.sql: displays information about each apply reader( the apply dequeue process).
delete.sql: delete all the transactions in the apply error queue.
delete_t.sql: delete the specific transaction in the apply error queue.
diable-soe-p.sql: set the disable_on_error to false for the specific apply process
disable-rep-p.sql: stop the apply processes specified by name.
disable-rep.sql: stop the replication processes like apply process, capture process.
disable-soe.sql: set the disable_on_error parameter to false to the all apply process
enable-rep-p.sql: enable the specific apply process
enable-rep.sql: enable all the apply processes
enable-soe-p.sql: set the disable_on_error parameter to true for the specific apply process
enable-soe.sql: set the disable_on_error to true for all the apply processes
list-err-o-f.sql: list the apply error queue to a file
list-err.sql: list the apply error queue to the console
print_capture_proc_status.sql: print the status of the capture process
printapplyqueueparams.sql: print the apply process parameters
printapplyqueuestate.sql: display some statistic info about the apply processes.
printapplyqueuestatus.sql: shows some useful statistics related to messages applied
printcapturequeue.sql: some information about the LCR that the capture process handled.
This is INFORMATIONAL, the rsautil manage-replication CLU is the customer facing tool when dealing with replication.
Legacy Article IDa32652

Attachments

    Outcomes