000015364 - How to empty/delete tokens from the token table in the RSA Tokenization Appliance?

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 Number000015364
Applies ToRSA Token Server Appliance (RTS)
IssueHow to empty the token table in the RSA Tokenization Appliance?
How to empty and delete all tokens in the RTS Appliance?
ResolutionLog in (ssh) to the RTS server as root, then:
   su - oracle
   sqlplus / as sysdba
(It should not prompt for a password at this point, since it is set up to use OS authentication.  If it prompts for a password, then make sure you have logged in with "su - oracle" with the spaces around the "-" to make the shell a login shell, which logs in as oracle to get the environment variables set.)

Once connected to Oracle sqlplus:
   delete from rtsowner.tscyobj;
   commit;
   exit;

To check the count:
  select count (*) from rtsowner.tscyobj;
https://your-appliance/heartbeat/token_count also displays the number of tokens in the database (see DTSApplianceDocumentation.pdf, p. 38).
 
Legacy Article IDa58488

Attachments

    Outcomes