Oracle 12.1.0.1
Steps so far ..
1. Connect to Container database
kts64~k12c~K12C~CDB$ROOT-SYS> @C:\Oracle\Ora12c\apex\apxremov_con.sql
PL/SQL procedure successfully completed.
catconInit: database is not open
Unexpected error encountered in catconInit; exiting
===
running the script steps manually, I get the error
kts64~k12c~K12C~CDB$ROOT-SYS> define UPGRADE = '1'
kts64~k12c~K12C~CDB$ROOT-SYS> define APPUN = 'APEX_040200'
kts64~k12c~K12C~CDB$ROOT-SYS> define IMGPR = '/i/'
kts64~k12c~K12C~CDB$ROOT-SYS> column foo2 new_val UPGRADE
kts64~k12c~K12C~CDB$ROOT-SYS> select '2' foo2
2 from dba_users
3 where username in
4 ('FLOWS_010500'
5 ,'FLOWS_010600'
6 ,'FLOWS_020000'
7 ,'FLOWS_020100'
8 ,'FLOWS_020200'
9 ,'FLOWS_030000'
10 ,'FLOWS_030100'
11 ,'APEX_030200'
12 ,'APEX_040000'
13 ,'APEX_040100');
no rows selected
kts64~k12c~K12C~CDB$ROOT-SYS> alter session set current_schema = SYS;
Session altered.
kts64~k12c~K12C~CDB$ROOT-SYS>
kts64~k12c~K12C~CDB$ROOT-SYS> set serveroutput on
kts64~k12c~K12C~CDB$ROOT-SYS> WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK
kts64~k12c~K12C~CDB$ROOT-SYS> begin
2 if dbms_registry.status('APEX') is null then
3 dbms_output.put_line(chr(13)||chr(10));
4 dbms_output.put_line('Error:');
5 dbms_output.put_line('You can only use this script to remove Application Express');
6 dbms_output.put_line(chr(13)||chr(10)||chr(13)||chr(10));
7 execute immediate('invalid sql stmnt to force exit');
8 end if;
9 end;
10 /
PL/SQL procedure successfully completed.
kts64~k12c~K12C~CDB$ROOT-SYS> WHENEVER SQLERROR CONTINUE
kts64~k12c~K12C~CDB$ROOT-SYS> drop user &APPUN cascade;
old 1: drop user &APPUN cascade
new 1: drop user APEX_040200 cascade
drop user APEX_040200 cascade
*
ERROR at line 1:
ORA-28014: cannot drop administrative users
Is there a solution?