Oracle APEX (apex_23.1) - installation procedure with Oracle 19.16.0.0.0

1. Download REST services https://www.oracle.com/database/sqldeveloper/technologies/db-actions/download/ or go to C:\Oracle\product\19.0.0.0\dbhome_1\ords
3. Change ords.war => apex.war
5. 
   
6. 
   
7. 
   
8. Download APEX from https://www.oracle.com/tools/downloads/apex-downloads/
9. Extract files f.e. in C:\temp\ folder (keep the folder tree) 
   
10. Run command line and navigate to folder where apex directory was extracted (C:\Temp\apex_23.1_en\apex>)s
11. Run SQLPlus on server with Oracle database, connect with` SYS as SYSDBA (previously check if Environment variable for ORACLE_SID is configured) 
    
    
    
    
    
    
    
12. Check database status with query SELECT INSTANCE_NAME, STATUS, DATABASE_STATUS FROM V$INSTANCE; (should be 'ACTIVE')
13. Check parameter SHOW PARAMETER MEMORY_TARGET (should be at least '300M')
14. Check parameter SHOW PARAMETER WORKAREA_SIZE_POLICY (should be set to 'AUTO') 
    
    
    
15. Create new tablespace for APEX CREATE TABLESPACE apex DATAFILE SIZE 100M AUTOEXTEND ON NEXT 1M;
16. Run installation script @apxrtins.sql tablespace_apex tablespace_files tablespace_temp images @apexins.sql APEX APEX TEMP /i/ 
    
    
    
17. Unlock apex_public user ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK
18. Change the password for public user ALTER USER APEX_PUBLIC_USER IDENTIFIED BY "new_password";
19. Change password for admin user by running @apxchpwd.sql
20. Change password policy for APEX_PUBLIC_USER profile alter profile DEFAULT limit password_life_time UNLIMITED;
21. Check the port with query  SELECT DBMS_XDB.gethttpport FROM DUAL; If it is set to 0 change it with  EXEC DBMS_XDB.sethttpport(8080);