Install APEX - Intergraph Smart Materials - Version 2020 (10.0) - Installation & Upgrade - Hexagon

Download Oracle Application Express to c:\tmp.

Extract apex_19.1.zip to your hard drive.

Open a Command Prompt window.

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

Set the following Oracle parameters (replace <ORACLE_HOME> with the path of your Oracle home directory, and <SID> with the name (sid) of your database):

set ORACLE_HOME=<ORACLE_HOME>

set ORACLE_SID=<SID>

For example:

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

set ORACLE_SID=SMAT

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

Sqlplus /nolog

connect sys/<password> as sysdba

Execute:

@apexins SYSAUX SYSAUX TEMP /i/

It takes a while.

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> 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.

   

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> 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.