How to install Apex 18.1 to Oracle Database 18.3 on Linux

Following, the step to install Apex 18.1 to Oracle Database 18.3 on Oracle Linux 7.5.

#STEP1: Download Apex 18.1
http://download.oracle.com/otn/java/appexpress/apex_18.1.zip

#STEP2: Verify & Check Apex Installed 

sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Dom Set 16 16:49:52 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connesso a:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> SELECT STATUS, VERSION FROM DBA_REGISTRY WHERE COMP_ID = 'APEX';

STATUS VERSION
-------------------------------------------- ------------------------------
VALID 5.1.1.00.08

 

#STEP3: Remove old version (ATTENTION! this destroy old Apex repository)
cd $ORACLE_HOME/apex
sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Dom Set 16 16:49:52 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connesso a:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> @apxremov.sql

Procedura PL/SQL completata correttamente.

Procedura PL/SQL completata correttamente.

...Removing Application Express

APX_USER
--------------------------------------------------------------------------------
APEX_050100

Modificata sessione.

Procedura PL/SQL completata correttamente.

Nessuna riga selezionata

Procedura PL/SQL completata correttamente.

Modificata sessione.

Procedura PL/SQL completata correttamente.

APX_USER
--------------------------------------------------------------------------------
APEX_050100

Modificata sessione.

Procedura PL/SQL completata correttamente.

Nessuna riga selezionata

Procedura PL/SQL completata correttamente.

Utente eliminato.

Procedura PL/SQL completata correttamente.

Procedura PL/SQL completata correttamente.

Procedura PL/SQL completata correttamente.

Procedura PL/SQL completata correttamente.

Procedura PL/SQL completata correttamente.

Package eliminato.

Procedura PL/SQL completata correttamente.

...Application Express Removed

********************************************************************
** You must exit this SQL*Plus session before running apexins.sql **
********************************************************************

SQL> SELECT STATUS, VERSION FROM DBA_REGISTRY WHERE COMP_ID = 'APEX';

Nessuna riga selezionata

#STEP3: Remove old Tablespace
SQL> drop tablespace APEX including contents and datafiles;

Eliminata tablespace.

#STEP4: Install Apex 18.1
mv $ORACLE_HOME/apex $ORACLE_HOME/apex.old
mv apex_18.1_en.zip $ORACLE_HOME
cd $ORACLE_HOME
unzip apex_18.1_en.zip
Archive: apex_18.1_en.zip
creating: apex/
inflating: apex/apxe101.sql
inflating: apex/apxdevrm_cdb.sql
extracting: apex/apxexit.sql
inflating: apex/coreins3.sql
.....
inflating: apex/apex_epg_config_nocdb.sql
inflating: apex/apxsqler.sql

cd $ORACLE_HOME/apex

sqlplus / as sysdba

SQL> CREATE TABLESPACE APEX DATAFILE '/oracle/oradata/orcl/apex01.dbf' SIZE 128M AUTOEXTEND ON NEXT 64M;

Creata tablespace.

SQL> @apexins.sql APEX APEX TEMP /i/
...set_appun.sql

Procedura PL/SQL completata correttamente.

...............
....

timing per: Phase 3 (Switch)
Passati: 00:03:46.16
timing per: Complete Installation
Passati: 00:21:30.30

Procedura PL/SQL completata correttamente.

1 riga selezionata.

...null1.sql

SQL> exit

 
#STEP5: Post Installation
sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Dom Set 16 17:34:33 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connesso a:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> @apxchpwd.sql
================================================================================
This script can be used to change the password of an Application Express
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator''s username [ADMIN] ADMIN
User "ADMIN" does not yet exist and will be created.
Enter ADMIN's email [ADMIN] oracleblog@mantisoft.it
Enter ADMIN's password []
Created instance administrator ADMIN.

SQL> exit

sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Dom Set 16 17:37:59 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connesso a:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> @apex_epg_config.sql /oracle/product/18
Procedura PL/SQL completata correttamente.

Procedura PL/SQL completata correttamente.

Procedura PL/SQL completata correttamente.

Procedura PL/SQL completata correttamente.

. Loading images directory: /oracle/product/18/apex/images

Creata directory.

Procedura PL/SQL completata correttamente.

Procedura PL/SQL completata correttamente.

Procedura PL/SQL completata correttamente.

Commit completato.

Eliminata directory.

timing per: Load Images
Passati: 00:03:43.85

Procedura PL/SQL completata correttamente.

Commit completato.

#STEP6: HTTP Port Activation
sqlplus / as sysdba

SQL> ALTER USER ANONYMOUS ACCOUNT UNLOCK;

Utente modificato.

SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT
-----------
0

SQL> EXEC DBMS_XDB.sethttpport(8080);

Procedura PL/SQL completata correttamente.

SQL> SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT
-----------
8080

SQL> exit

==>Ensure listener is up:
lsnrctl status

LSNRCTL for Linux: Version 18.0.0.0.0 - Production on 16-SET-2018 17:59:59

Copyright (c) 1991, 2018, Oracle. All rights reserved.

Connessione a (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ol7.fritz.box)(PORT=1521)))
STATO del LISTENER
------------------------
Alias LISTENER
Versione TNSLSNR for Linux: Version 18.0.0.0.0 - Production
Data di inizio 16-SET-2018 17:58:00
Tempo di attività 0 giorni 0 ore 1 min. 58 sec.
Livello trace off
Sicurezza ON: Local OS Authentication
SNMP OFF
File di parametri listener/oracle/product/18/network/admin/listener.ora
File di log listener /oracle/diag/tnslsnr/ol7/listener/alert/log.xml
Summary table degli endpoint di ascolto...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ol7.fritz.box)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ol7.fritz.box)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Summary table dei servizi...
Il servizio "orcl" ha 1 istanze.
L'istanza "orcl", stato READY, ha 1 handler per questo servizio...
Il servizio "orclXDB" ha 1 istanze.
L'istanza "orcl", stato READY, ha 1 handler per questo servizio...
Il comando è stato eseguito

 
#STEP7: Install Rest (Optional)
sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Dom Set 16 23:29:09 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connesso a:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> @apex_rest_config.sql

Procedura PL/SQL completata correttamente.

Procedura PL/SQL completata correttamente.

Enter a password for the APEX_LISTENER user []
Enter a password for the APEX_REST_PUBLIC_USER user []
...set_appun.sql
...create APEX_LISTENER and APEX_REST_PUBLIC_USER users

Procedura PL/SQL completata correttamente.

Utente modificato.

Concessione riuscita.

Concessione riuscita.

.........
...

Sinonimo creato.

Modificata sessione.

Procedura PL/SQL completata correttamente.

 
#STEP8: Using Apex 

http://localhost:8080/apex/apex_admin



APEX INSTALLATION DONE!

Leave a Comment