ORA-01940 error when running AVDB_Import_AVUSER.sh in RSA Identity Governance and Lifecycle
Originally Published: 2017-08-07
Article Number
Applies To
RSA Version/Condition: 6.9.1, 7.0.1, 7.0.2
Issue
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"..
DECLARE
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
ORA-06512: at line 8
Database is not running.
Database is running.
drop a user that is currently connected
ORA-06512: at line 8
It should be noted that the script calls Drop_User.sql, and this is where the DROP USER SQL statement is actually issued.Cause
ORA-01940: cannot drop a user that is currently connected Cause: Attempt was made to drop a user that is currently logged in. Action: Make sure user is logged off, then repeat command.The error occurs when the avuser is still logged in to the database.
Resolution
cd /home/oracle/database/DBA/AVDB/scripts AVDB_Import_AVUSER.sh -f Export_AVDB_avuser2011-10-21-17-16-00.dmp
Workaround
# sqlplus / as sysdba SQL> shutdown immediate; SQL> startup restrict; SQL> drop user AVUSER cascade SQL> shutdown immediate SQL> startupOnce the user has been dropped, the AVDB_Import_AVUSER.sh script can then be run without the -f option.
Related Articles
AFX Server remains in a 'Not running' State, afx status shows 'timed out waiting for AFX applications to start' and mule_e… Number of Views RSA Identity Governance and Lifecycle installation fails with the error: Problem running roothas.pl Number of Views On database startup for RSA Identity Governance and Lifecycle the following error is seen: CRS-2501: Resource 'ora.avdb.d… Number of Views AFX Server remains in a 'Not running' State, afx status shows 'timed out waiting for AFX applications to start' and esb.AF… Number of Views 'The RSA Identity Governance & Lifecycle server is not running and is not in a starting state' when starting RSA Identity … Number of Views
Trending Articles
RSA Authentication Manager 8.9 Release Notes (January 2026) How to factory reset an RSA Authentication Manager 8.x hardware appliance without a factory reset button from the Operatio… Deploying RSA Authenticator 6.2.2 for Windows Using DISM RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide Microsoft Office 365 - SAML Relying Party Configuration - RSA Ready Implementation Guide
Don't see what you're looking for?
