|Applies To||RSA Product Set: Identity Governance & Lifecycle |
RSA Version/Condition: 6.x, 7.x
|Issue||There are times during testing or during deployment when you want to remove all the data in the RSA Identity Governance & Lifecycle Application Oracle Database. It is possible to clear out all the user data from an existing RSA Identity Governance & Lifecycle Oracle Database installation using the methods below.|
For a Local Database
For a hardware or software appliance using a local database, the $AVEKSA_HOME/database/createSchema.sh script may be run which essentially erases all existing data. For that reason, it is recommended that a database backup is created before following this process.
For a Remote Database
Remote database environments such as Enterprise Software users using WebSphere or WebLogic, or software appliances using a remote database have a slightly different process. The createSchema.sh script cannot be used when the database is remote. For that scenario, the Oracle application user, AVUSER, has to be manually dropped and recreated. Refer to the RSA Identity Governance & Lifecycle Database Setup and Management Guide for your RSA Identity Governance & Lifecycle version for specifics on how to do this for a remote database.
NOTE: If AFX is used, AFX data may need to be re-enabled after the database is completely refreshed. This RSA Knowledge Base Article covers RSA Identity Governance & Lifecycle only.
|Resolution||This process can be used for a hardware or software appliance that has a local database. |
Login as the linux oracle user and perform the following tasks:
It is good policy to make sure that a backup of the existing database is created in the event it needs to be restored at some future point in time.
The createSchema.sh script should take between 15 and 35 minutes to run depending on the class of machine. The script drops and recreates the application use, AVUSER. Note that the default password for this user will be restored If this password had been changed, it will need to be updated again manually by logging into the database as sysdba and updating the password.
After this script completes, the database will be in the same state as a new installation.
|Notes||As a reminder, since running this script resets the database to be the same as a fresh, brand new installation, the default AveksaAdmin password is reset to the new installation default.|
When the createSchema.sh script is run, the output on the terminal session will look similar to this: