In this tutorial I going to show you how to install Oracle 18c Express and Oracle Apex 18.2 into Windows
We need to know since version Oracle 12, exists the concepts of plug-gable databases and containers.
So first download oracle database and oracle apex:
Oracle Database Express Edition (XE) Release 18.4.0.0.0 (18c)
Oracle APEX Release 18.2.0.00.12
Use the setup and next.
We need to provide and remember the passwords of sys, system y PDBADMIN
Finally we will have the URLs where we can access to the database
So, here i have some troubles to access because my listener was stopped.
The URL for access is : https://localhost:5500/em
If you have problems to access. Check using
lsnrctl status
If the listener is stopped, you can start using:
lsnrctl start
About listener :
Foro Oracle 1
Foro Oracle 2
This point is very important.
Firsts we going to check the current pdbs, connect to sqlplus as execute show pdbs, it must the display the correct mode, read only and read write.
Look this guides if is different
Guía 1
Guía 2
Beforo to start the install, we must to select the correct pdb.
ALTER SESSION SET CONTAINER = XEPDB1;
The containers since Oracle 12, is like this, for that reason before to install we need to select to correct container. This link is a resume about that.
Next, Go to directory where you have apex 18.2 uncompressed, and install,
Guide Oficial Oracle.
@apexins.sql SYSAUX SYSAUX TEMP /i/
Set the password of admin.
@apxchpwd.sql
Configure the Pl/Sql Gateway for local environment.
Use the parent directory as URL.
@apex_epg_config.sql C:\MyPc\InstallApex
Next , check the port:
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
If is 0 we need to change with 8080, or another.
EXEC DBMS_XDB.SETHTTPPORT(8080);
The last step, connect in another cmd as sysdba, and show pdbs, for be sure we are in both container, PDB$SEDD and XEPDB1.
If we are in both and with that mode, execute:
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
Finally we can enter to Oracle Apex 18.2
http://localhost:8080/apex
http://localhost:8080/apex/apex_admin
First time enter as workspace Internal and user admin , and pass of the istallation.
References:
Oracle Database Express Edition (XE) Release 18.4.0.0.0 (18c)
Oracle APEX Release 18.2.0.00.12
Si te olvidaste de seleccionar el contenedor o tienes errores al crear el workspace
Problemas con activar el read write en los contenedores 1
Problemas con activar el read write en los contenedores 2
Guía instalacion Oracle 18c express
Guía instalacion Oracle APEX 18.2
Acerca de pluggable database
We need to know since version Oracle 12, exists the concepts of plug-gable databases and containers.
So first download oracle database and oracle apex:
Oracle APEX Release 18.2.0.00.12
Use the setup and next.
Finally we will have the URLs where we can access to the database
So, here i have some troubles to access because my listener was stopped.
The URL for access is : https://localhost:5500/em
If you have problems to access. Check using
lsnrctl status
If the listener is stopped, you can start using:
lsnrctl start
About listener :
Foro Oracle 1
Foro Oracle 2
This point is very important.
Firsts we going to check the current pdbs, connect to sqlplus as execute show pdbs, it must the display the correct mode, read only and read write.
Look this guides if is different
Guía 1
Guía 2
Beforo to start the install, we must to select the correct pdb.
ALTER SESSION SET CONTAINER = XEPDB1;
The containers since Oracle 12, is like this, for that reason before to install we need to select to correct container. This link is a resume about that.
Next, Go to directory where you have apex 18.2 uncompressed, and install,
Guide Oficial Oracle.
@apexins.sql SYSAUX SYSAUX TEMP /i/
Set the password of admin.
@apxchpwd.sql
Configure the Pl/Sql Gateway for local environment.
Use the parent directory as URL.
@apex_epg_config.sql C:\MyPc\InstallApex
Next , check the port:
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
If is 0 we need to change with 8080, or another.
EXEC DBMS_XDB.SETHTTPPORT(8080);
If we are in both and with that mode, execute:
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
Finally we can enter to Oracle Apex 18.2
http://localhost:8080/apex
http://localhost:8080/apex/apex_admin
First time enter as workspace Internal and user admin , and pass of the istallation.
References:
Oracle Database Express Edition (XE) Release 18.4.0.0.0 (18c)
Oracle APEX Release 18.2.0.00.12
Si te olvidaste de seleccionar el contenedor o tienes errores al crear el workspace
Problemas con activar el read write en los contenedores 1
Problemas con activar el read write en los contenedores 2
Guía instalacion Oracle 18c express
Guía instalacion Oracle APEX 18.2
Acerca de pluggable database