Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

removing apex 4.2.5.00.08

DBA092012Jul 28 2016 — edited Jul 28 2016

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.

This post has been answered by DBA092012 on Jul 28 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2016
Added on Jul 28 2016
2 comments
1,024 views