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)

ITPub博客

11g升级19c apex无效

1、升级完成后卸载原有的低版本apex

2、卸载完成后装高版本apex

最新文章