This appendix contains information on troubleshooting.
The apexins.sql script creates a log file in the apex directory using the naming convention installYYYY-MM-DD_HH24-MI-SS.log. In a successful installation, the log file contains the following text:
Thank you for installing Oracle Application Express. Oracle Application Express is installed in the APEX_040200 schema.
If the log file contains a few errors, it does not mean that your installation failed. Note that acceptable errors are noted as such in the log file.
You can verify the validity of an Oracle Application Express installation by running the following query:
SELECT STATUS FROM DBA_REGISTRY WHERE COMP_ID = 'APEX';
If the result is VALID, you can assume the installation was successful.
In a successful installation the following banner displays at the end of the installation:
Thank you for installing Oracle Application Express. Oracle Application Express is installed in the APEX_040200 schema.
To reinstall, you must either drop the Oracle Application Express database schemas, or run a script to completely remove Application Express from the database, depending upon the installation type.
This section describes how to remove the Oracle Application Express schema, synonyms, and users from the database without deleting the database. If you are going to delete the database, then you must complete these steps.
To remove Oracle Application Express from the Oracle Database 12c non-CDB where Oracle Application Express is not installed in the CDB$ROOT:
Change your working directory to $ORACLE_HOME/apex.
Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role:
On Windows:
SYSTEM_DRIVE:\ sqlplus /nolog SQL> SQL> CONNECT SYS as SYSDBA Enter password: SYS_password
On UNIX and Linux:
$ sqlplus /nolog
SQL> SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
Execute the following command:
SQL> @apxremov.sql
After successfully removing Application Express using apxremov.sql, you must exit your current SQL*Plus session and reconnect prior to attempting another install using apexins.sql.
To remove Oracle Application Express from the database in 12c multitenant architecture where Oracle Application Express is installed in the CDB$ROOT:
Change your working directory to $ORACLE_HOME/apex.
Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role:
On Windows:
SYSTEM_DRIVE:\ sqlplus /nolog SQL> SQL> CONNECT SYS as SYSDBA Enter password: SYS_password
On UNIX and Linux:
$ sqlplus /nolog
SQL> SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
Execute the following command:
SQL> @apxremov_con.sql
After successfully removing Application Express using apxremov_con.sql, you must exit your current SQL*Plus session and reconnect prior to attempting another install using apexins_con.sql.
If images in Oracle Application Express do not display correctly, you may have more than one definition of the /i/ alias. To address this issue:
If possible, rename the first instance of /i/ to a different alias name.
Alternatively, copy the images from the ORACLE_HOME\apex\images directory to the directory defined by the first /i/ alias.
This may be caused by manual alteration of protected page items. If this error occurs after installation when trying to log into Application Express, then stop and start Oracle REST Data Services. If you are unsure of what caused this error, please contact the application administrator for assistance.
To learn more about stopping and starting Oracle REST Data Services, see Oracle REST Data Services Installation and Developer Guide.