Install Oracle Apex 21.2 | Database 21c XE | Pluggable | ORDS | Windows 10

Описание

How to Install Oracle APEX 21.2 | Database 21c XE | Pluggable | ORDS | Windows 10
01. Download APEX 21.2 , Oracle XE 21 Database, ORDS,Java (JDK)
02. Install the Database and JDK .
03. Extract APEX Zip file.
04. Open Command Prompt (CMD) as Administrator.
05. Open APEX path in cmd and conn to oracle.

D:\Apex\apex_19.2\apex sqlplus /nolog
conn sys/admin123 as sysdba

06. Now we ready to install. Run apexins.sql with all parameters.
show pdbs
alter session set container = XEPDB1;
COLUMN default_tablespace FORMAT A15
COLUMN temporary_tablespace FORMAT A15
@apexins.sql SYSAUX SYSAUX TEMP /i/

07. Run apex_rest_config.sql to create rest users.
@apex_rest_config.sql

08. Run
@apxchpwd.sql

09. Unlock users
ALTER USER APEX_LISTENER IDENTIFIED BY admin123 ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY admin123 ACCOUNT UNLOCK;
ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY admin123 ACCOUNT UNLOCK;

alter pluggable database pdb$seed open read write;

10. Install the ORDS using below command using Jar file.
Create path as ords\config
java -jar ords.war
i.Set location as …. ords\config
ii.(admin user is sys)
iii.SERVISE_NAME : XEPDB1 (DON’T SELECT SID)
iv.Standalone is 1 (or 2 for tomcat,etc)