Hello everybody.
I've just recently installed und patched Oracle 12.1.0.2 two nodes RAC and created brand new database with dbca.
According to the output of the command below :
SQL> select COMP_NAME, STATUS, VERSION from dba_registry;
Oracle Database Vault VALID 12.1.0.2.0
Oracle Application Express VALID 4.2.5.00.08
Oracle Label Security VALID 12.1.0.2.0
Spatial OPTION OFF 12.1.0.2.0
Oracle Multimedia VALID 12.1.0.2.0
Oracle Text VALID 12.1.0.2.0
Oracle Workspace Manager VALID 12.1.0.2.0
Oracle XML Database VALID 12.1.0.2.0
Oracle Database Catalog Views VALID 12.1.0.2.0
Oracle Database Packages and Types VALID 12.1.0.2.0
JServer JAVA Virtual Machine VALID 12.1.0.2.0
Oracle XDK VALID 12.1.0.2.0
Oracle Database Java Packages VALID 12.1.0.2.0
OLAP Analytic Workspace OPTION OFF 12.1.0.2.0
Oracle OLAP API OPTION OFF 12.1.0.2.0
Oracle Real Application Clusters VALID 12.1.0.2.0
16 rows selected.
i have Oracle Application Express version 4.2.5.00.08 but i need the last one 5.XX.
So as i understand there is no option for me to upgrade my current APEX so i have to remove it completely before new installation.
As states the document https://docs.oracle.com/cd/E59726_01/install.50/e39144/listener.htm#HTMIG838
to remove the old version of APEX i have to run
DROP USER APEX_040200 CASCADE;
howevere there are some script in the $ORACLE_HOME/apex directory
[oracle@test-node1 ~]$ ls -l $ORACLE_HOME/apex | grep apxremov
-rw-r--r-- 1 oracle oinstall 3222 Oct 14 2013 apxremov1.sql
-rw-r--r-- 1 oracle oinstall 5326 Oct 14 2013 apxremov2.sql
-rw-r--r-- 1 oracle oinstall 1995 Oct 14 2013 apxremov_con.sql
-rw-r--r-- 1 oracle oinstall 2024 Oct 14 2013 apxremov.sql
So which way the old APEX is expected to be removed.