oracle apex 21.2 on oracle 21 c xe database Linux Centos 8 workstation (for laptops) instalations

pic 1 right click on mouse and run install

pic 2 centos 8 automaticaly install oracle 21 c xe and 21 pre instal rpm files

pic 3 after installation its need oracle be configured and need to type systemctl start oracle-xe-21c for automatically start after restart

pic 4 apex 21.2 is copy unzip on /root/apex folders and with export oracle home and oracle sid need run /opt/oracle/product/21c/dbhomeXE/bin sqlplus sys/pass@127.0.0.1:1521/xepdb1 as sysdba and @apexins sysaux sysaux temp /i/

and steps shown on pic 3 2,3 and i add 4 steps @apxrtins sysaux sysaux temp /i/

Most important is from sql run alter user apex_public_user account unlock

 

Pic 4 and static files path to image /root/i/   i - copy folder from apex images

and its important to run java (jdk 11) and orda need to be unziped into folder /root/ords and run from command line java -jar ords.war (before make ords.war executable) and put database parameters for ords. Every time when laptop is restarted its need type /root/ords java -jar ords.war. 

SQL offer LISTAG DISTINCT AGGREGATIONS its new function oracle 21 c XE database have!

pic 5 https://localhost:5500/em https://testtesttest.ddns.net:5500/em

 

Electrical installation calculations:

 

 In first example I set 17 floors in house, barier direct D and ked 0.6 (no thermal

equipment in houses) and result give me 180 [mm2] 3 phases wire

 

When I change to enclosed type B there is 120 [mm2] conductors

 DEMO :

http://testtesttest.ddns.net:8282/ords/f?p=130

http://testtesttest.ddns.net:8383/apex/f?p=130:380