Drop user ORACLE_OCM cascade is giving ORA-01940 (Doc ID 1517405.1)

Last updated on MAY 16, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
**Checked for Relevance May 16, 2016**

Symptoms

 SQL> drop user ORACLE_OCM cascade;


drop user ORACLE_OCM cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected

There are no sessions for CCR or ORACLE_OCM on any of the instances of the database

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