|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;
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 ID||a58488|