1、升级完成后卸载原有的低版本apex
SELECT * FROM dba_objects where status = 'INVALID' AND (owner like 'FLOWS%' or owner like 'APEX%') select username from dba_users where username like 'APEX%'; select username from dba_users where username like 'FLOWS%'; drop user APEX_PUBLIC_USER CASCADE; drop user APEX_INSTANCE_ADMIN_USER CASCADE; drop user FLOWS_FILES CASCADE; alter session disable guard; drop user APEX_030200 cascade; --ok DROP USER APEX_050000 CASCADE --ok DROP USER APEX_190200 CASCADE --ok select 'drop public synonym ' || synonym_name || ';' from sys.dba_synonyms where table_owner in ('APEX_030200','APEX_050000','APEX_190200','FLOWS_FILES','APEX_PUBLIC_USER','APEX_INSTANCE_ADMIN_USER');
2、卸载完成后装高版本apex
将apex安装包apex_24.1.zip传到/home/oracle/目录下，解压，安装。 unzip apex_24.1.zip @/home/oracle/apex/apexins.sql SYSAUX SYSAUX TEMP /i/ -- 注意，这样不行，需要进入到apex升级文件所在目录下，然后连接到数据库，再执行语句 cd /home/oracle/apex sqlplus / as sysdba @/home/oracle/apex/apexins.sql SYSAUX SYSAUX TEMP /i/
参考： How to Uninstall Oracle HTML DB / Application Express from a Standard Database (Doc ID 558340.1)
