I wanted to upgrade Apex from version 18.2 to 21.2. I got error:
SQL> @apexins.sql APEXDATA APEXDATA TEMP /i/
...set_appun.sql
PL/SQL procedure successfully completed.
...set_ufrom_and_upgrade.sql
PL/SQL procedure successfully completed.
Session altered.
FOO3
------------------------------
install2022-05-18_12-31-53.log
. ORACLE
.
. Application Express (APEX) Installation.
..........................................
.
...set_appun.sql
... Checking prerequisites (MANUAL)
.
. SYSDBA Privilege
. pass - Connection with SYSDBA privilege.
. Database rolling upgrade
. pass - No rolling upgrade.
. DB components
. pass - APEX: version=18.2.0.00.12
. pass - CATPROC: version=19.0.0.0.0
. pass - XDB: version=19.0.0.0.0
. XDB
. pass - is valid
. DB parameters
. pass - workarea_size_policy is AUTO
. PL/SQL Web Toolkit
. pass - version 11.2.0.0.1
. Tablespaces
. pass - found APEXDATA
. pass - found APEXDATA
. pass - found TEMP
. PHASES (1,2,3)...
PL/SQL procedure successfully completed.
.
... Prerequisite checks passed.
.
...gen_adm_pwd.sql
Phase 1 (Installation)
# Bootstrapping
...apxsqler_exit.sql
...setting session environment
...Creating users
...create user APEX_210200
Installing SYS views
...sys_core_views.sql
...core_grants.sql
...grant APEX owner core privileges
grant select on sys.dual to APEX_210200
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object SYS.DUAL
Disconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Then I tried to install it again:
SQL> @apexins.sql APEXDATA APEXDATA TEMP /i/
...set_appun.sql
PL/SQL procedure successfully completed.
...set_ufrom_and_upgrade.sql
PL/SQL procedure successfully completed.
Session altered.
FOO3
------------------------------
install2022-05-18_12-50-14.log
. ORACLE
.
. Application Express (APEX) Installation.
..........................................
.
...set_appun.sql
... Checking prerequisites (MANUAL)
.
. SYSDBA Privilege
. pass - Connection with SYSDBA privilege.
. Database rolling upgrade
. pass - No rolling upgrade.
. DB components
. pass - APEX: version=18.2.0.00.12
. pass - CATPROC: version=19.0.0.0.0
. pass - XDB: version=19.0.0.0.0
. XDB
. pass - is valid
. DB parameters
. pass - workarea_size_policy is AUTO
. PL/SQL Web Toolkit
. pass - version 11.2.0.0.1
. Tablespaces
. pass - found APEXDATA
. pass - found APEXDATA
. pass - found TEMP
. PHASES (1,2,3)...
. FAIL - Precondition for Phase 1 failed: APEX_210200 already exists
.
. 1 error occurred
declare
*
ERROR at line 1:
ORA-20001: Prerequisite checks failed; unable to proceed with APEX installation
ORA-06512: at line 318
What can I do?