How to empty/delete tokens from the token table in the RSA Tokenization Appliance?
2 years ago
Originally Published: 2012-06-11
Article Number
000047873
Applies To
RSA Token Server Appliance (RTS)
Issue
How to empty the token table in the RSA Tokenization Appliance?
How to empty and delete all tokens in the RTS Appliance?
Resolution
Log 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).