Скачать с ютуб How to Install Oracle Apex 22.2 | Database 21c XE Pluggable | ORDS 22 | Tomcat | Windows в хорошем качестве

How to Install Oracle Apex 22.2 | Database 21c XE Pluggable | ORDS 22 | Tomcat | Windows

In this step-by-step tutorial, you will learn how to install the latest Oracle APEX version 22.2 on your own local Windows PC. This local Oracle APEX development environment setup will be created using Oracle Database 21c XE, the latest Oracle Rest Data Services (ORDS 22x), Java (JDK 17x), and Apache Tomcat. Chapters --------------- 0:00 - Intro 0:28 - Download links 1:55 - Install Oracle Database 21c XE 4:04 - Install Oracle APEX 22.2 7:39 - Install JDK 8:21 - Install Oracle Rest Data Services 11:40 - Install Apache Tomcat 14:28 - Run Oracle APEX and create your first workspace 15:34 - Log in to the new workspace Download Oracle XE 21c https://www.oracle.com/ie/database/te... Download Oracle APEX https://www.oracle.com/tools/download... Download ORDS https://download.oracle.com/otn_softw... Download JAVA https://www.oracle.com/java/technolog... Download Tomcat https://tomcat.apache.org/download-90... Install Oracle APEX ------------------------------- sqlplus /nolog conn sys as sysdba show pdbs; alter session set container = XEPDB1; // Always execute this command when you open a new sqlplus session column default_tablespace format A15 column temporary_tablespace format A15 @apexins.sql SYSAUX SYSAUX TEMP /i/ @apxchpwd.sql alter user APEX_PUBLIC_USER account unlock; alter user APEX_PUBLIC_USER identified by Manager_2023; // Used this password in this video for all accounts @apex_rest_config.sql Install ORDS -------------------- sqlplus sys as sysdba alter user sys identified by Manager_2023 account unlock container=all; alter session set container = xepdb1; alter user apex_listener identified by Manager_2023 account unlock; alter user apex_public_user identified by Manager_2023 account unlock; alter user apex_rest_public_user identified by Manager_2023 account unlock; ---------------------------------------------------------------------------- Ords.bat ---------------------------------------------------------------------------- set ORDS_HOME=c:\app\ords set ORDS_CONFIG=c:\app\config\ords set ORDS_LOGS=%ORDS_CONFIG%\logs set DB_HOSTNAME=localhost set DB_PORT=1521 set DB_SERVICE=XEPDB1 set SYSDBA_USER=SYS c:\app\ords\bin\ords.exe ^ --config %ORDS_CONFIG% install ^ --log-folder %ORDS_LOGS% ^ --admin-user %SYSDBA_USER% ^ --db-hostname %DB_HOSTNAME% ^ --db-port %DB_PORT% ^ --db-servicename %DB_SERVICE% ^ --feature-db-api true ^ --feature-rest-enabled-sql true ^ --feature-sdw true ^ --gateway-mode proxied ^ --gateway-user APEX_PUBLIC_USER ^ --proxy-user ------------------------------------------------------------------------------ setx PATH "%PATH%;c:\app\ords\bin" set PATH="%PATH%;c:\app\ords\bin" Install Apache Tomcat -------------------------------------- set CATALINA_HOME="c:\Program Files\Apache Software Foundation\Tomcat 9.0" mkdir %CATALINA_HOME%\webapps\i -Dconfig.url=c:\app\config\ords Run Oracle APEX ----------------------------- http://localhost:8888/ords/apex_admin