On ASAP Startup Received the error "ORA-01940 Cannot Drop A User That Is Currently Connected" (Doc ID 949370.1)

Last updated on AUGUST 04, 2017

Applies to:

Oracle Communications ASAP - Version 4.2.0 to 7.0.2 [Release 4.2 to 7.0.0]
Information in this document applies to any platform.
***Checked for relevance on 03-OCT-2014***

Symptoms

This is a fatal error that may occur when installing/running ASAP.

This error will be displayed on the ASAP installation screen as well as found in the ASAP installation file CreateDatabase.log:

Creating ASAP database users ...
Creating ctrlPS04 database user ...

User dropped.


User created.


Grant succeeded.


Trigger created.

Creating sarmPS04 database user ...
drop user sarmPS04 cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms