ORA-28014: cannot drop administrative user or role

While trying to drop an user in a multitenant database the following error is seen: 
[code] SQL> drop user TEST_ENC cascade; drop user TEST_ENC cascade * ERROR at line 1: ORA-28014: cannot drop administrative user or role SQL> drop user TEST1 cascade; drop user TEST1 cascade * ERROR at line 1: ORA-28014: cannot drop administrative user or role SQL> drop user TEST3 cascade; drop user TEST3 cascade * ERROR at line 1: ORA-28014: cannot drop administrative user or role [/code] 

Creating users via catcon.pl and then trying to drop them directly in sqlplus results in ORA-28014.

CAUSE

The user was created by a script executed via catcon.pl. The users created this way are considered administrative users since in that session the parameter "_oracle_script" is set to TRUE. As per ORA-28014: Cannot Drop Administrative Users (Doc ID 1566042.1)

SOLUTION

set "_oracle_script" to TRUE before dropping the users directly:

[code] SQL> alter session set "_oracle_script"=true; Session altered. SQL> drop user TEST_ENC cascade; User dropped. SQL> drop user TEST3 cascade; User dropped. SQL> drop user TEST1 cascade; User dropped. [/code]