Install APEX 20.2 - Intergraph Smart Materials - Version 10.2 - Installation & Upgrade - Hexagon

To reduce the used space in SYSAUX tablespace, you can uninstall the older APEX version before you install the new version.

1. Download Oracle Application Express to c:\tmp.

2. Extract apex_20.2.zip to your hard drive.

3. Open a Command Prompt window.

4. Change your working directory to the apex directory where you unzipped the installation software, for example, c:\tmp\apex.

5. Set the following Oracle parameters (replace <ORACLE_HOME> with the path of your Oracle home directory):

   set ORACLE_HOME=<ORACLE_HOME>

   For example:

   set ORACLE_HOME=C:\oracle\19c_Sta\db

6. Launch SQL*Plus and connect to the database with sys as sysdba.

   1. In case of multitenant architecture (CDB/PDB), perform the following:

      • Sqlplus /nolog

      • connect sys/<password>@<CDB instance> as sysdba

      • Alter session set container = <PDB instance>

   2. In case of a single instance, perform the following:

      • Sqlplus /nolog

      • connect sys/<password>@<SID> as sysdba

7. Execute:

   @apexins.sql SYSAUX SYSAUX TEMP /i/

   It takes a while.

8. To change the password for the admin account, do the following:

   1. Launch SQL*Plus and connect to the database as SYS specifying the SYSDBA role.

      Sqlplus /nolog

      connect sys/<password>@<PDB instance> as sysdba

   2. Run the apxchpwd.sql script.

   3. When prompted, enter a password for the ADMIN account.

      If you enter a password that does not match the complexity rules, get you an error. With a correct password the procedure will succeed.

      

9. Configure the user APEX_PUBLIC_USER as follows:

   1. Launch SQL*Plus and connect to the database as SYS specifying the SYSDBA role.

      sqlplus /nolog

      connect sys/<password>@<PDB instance> as sysdba

   2. Enter the following commands to unlock the user and change the password (replace <new_password> with your password):

      ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;

      ALTER USER APEX_PUBLIC_USER IDENTIFIED BY <new_password>;

   Remember the new password. In case of using special characters enclose the password in quotes.

10. Install the current APEX 20.2 hotfix as follows:

    1. Download the Patch Set Bundle for Oracle APEX 20.2 (32006852) from

       https://www.oracle.com/tools/downloads/apex-downloads.html

    2. Check the Readme.txt for installation notes

    3. Extract p32006852_2020_Generic.zip to your hard drive.

    4. In <Patch Set Bundle> folder, launch Sql*Plus as SYSDBA.

       • Sqlplus /nolog

       • connect sys/<password>@<CDB instance> as sysdba

       • Alter session set container = <PDB instance>

    5. Execute:

       @catpatch.sql