Article Content
Article Number | 000035448 |
Applies To | RSA Product Set: Identity Governance and Lifecycle RSA Version/Condition: 6.9.1, 7.0.1, 7.0.2 |
Issue | The AVDB_Import_AVUSER.sh is a script that is used for restoring the database for an RSA appliance. The procedure for using the script is documented in the online help under Administration > Managing the Appliance > Restoring the Database for an RSA Appliance. However, when running the script, the following error may be encountered. Dropping the user "avuser".. It should be noted that the script calls Drop_User.sql, and this is where the DROP USER SQL statement is actually issued. |
Cause | The Oracle description for the error is as follows.ORA-01940: cannot drop a user that is currently connected The error occurs when the avuser is still logged in to the database. |
Resolution | Use the -f option when running the AVDB_Import_AVUSER.sh script. Using -f forces the import by terminating any existing sessions. For example: cd /home/oracle/database/DBA/AVDB/scripts |
Workaround | Alternately, the error can be overcome by connecting to the database as SYSDBA and manually dropping the avuser.# sqlplus / as sysdba Once the user has been dropped, the AVDB_Import_AVUSER.sh script can then be run without the -f option. |