Oracle Apex 22.2 Installation with ORDS

Topic Introduction: In this tutorial, we will describe Oracle Apex 22.2 Installation with ORDS step-by-step process. Here we will install it on windows 10, all software needs to download for windows.

Required Software List:

1. Oracle Database 19c
2. Oracle Apex 22.2
3. JDK version 8
4. ORDS Version 21.2

All unzipped software folders have been kept to D:\OracleSoftware path.

Database Installation

For Database Installation go to the link described in the previous tutorial. 

https://oracleschoolbd.blogspot.com/2022/08/oracle-database-19c-installation-on.html

Apex Installation

1. Open Command Prompt(CMD)

2. Go to the path D:\OracleSoftware\apex by command

    i. d:

    ii. cd OracleSoftware

    iii. cd apex

    iv. sqlplus

    v. sys /as sysdba

    vi. @apexins.sql sysaux sysaux temp /i/

    vii. @apxchpwd.sql

         a. User ADMIN

         b. email reza@gmail.com

         c. password Reza123;

    viii. @apex_rest_config.sql

         a. apex listener user: 123

         b. apex rest public user:123 

3. Apex-related user unlock

    ix. ALTER USER APEX_LISTENER  ACCOUNT UNLOCK identified by 123;

    x. ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK identified by 123;

    xi. ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK identified by 123;

    xii. ALTER USER APEX_220200 ACCOUNT UNLOCK identified by 123;

4. Create ACL using the below code:

BEGIN

DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(

host => '*',

ace => xs$ace_type(privilege_list => xs$name_list('connect'),

principal_name => 'APEX_220200',

principal_type => xs_acl.ptype_db));

END;

/

BEGIN

DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(

host => 'localhost',

ace => xs$ace_type(privilege_list => xs$name_list('connect'),

principal_name => 'APEX_220200',

principal_type => xs_acl.ptype_db));

END;

/

5. Execute the script:

EXEC DBMS_XDB.sethttpport(0);

6 Exit from CMD

      i. exit;

JDK Installation & Check

1. JDK Installation

     i. Install JDK

2. Check the Installation

     i. Go to cmd

     ii. java -jar

ORDS Configuration

1. Rename the Folder to 'ords'

2. Enter to 'ords' folder and create a folder 'config'

3. Enter into 'apex' folder then copy 'image' folder and paste it to 'ords' folder

4. Open Command Prompt(CMD)

5. Go to the path D:\OracleSoftware\ords by command

    i. d:

    ii. cd OracleSoftware

    iii. cd words

    iv. java -jar ords.war

         a. Enter the location to store configuration data: D:\OracleSoftware\ords\config

         b. Enter the name of the database server [localhost]: Press Enter

         c. Enter the database listen port [1521]: Press Enter

         d. Enter 1 to specify the database service name, or 2 to specify the database SID [1]: Press 1

         e. Enter the database service name: orcl

         f. Enter the database password for ORDS_PUBLIC_USER: 123

         g. Confirm password: 123

        h. Enter the administrator username: sys

        i. Enter the database password for SYS AS SYSDBA: 123

        j. Confirm password: 123

        k. If using Oracle Application Express or migrating from mod_plsql then you must enter 1 [1]: 1

        l.  Enter the database password for APEX_PUBLIC_USER: 123

        m. Confirm password: 123

        n. Enter 1 to specify passwords for Application Express RESTful Services database users (APEX_LISTENER, APEX_REST_PUBLIC_USER) or 2 to skip this step [1]: Press 1

       o. Enter the database password for APEX_LISTENER: 123

       p. Confirm password: 123

       q. Enter the database password for APEX_REST_PUBLIC_USER: 123

       r. Confirm password: 123

       s. Enter a number to select a feature to enable:

          [1] SQL Developer Web  (Enables all features)

          [2] REST Enabled SQL

          [3] Database API

          [4] REST Enabled SQL and Database API

          [5] None

      t. Choose [1]: Press 1

      u. Enter 1 if you wish to start in standalone mode or 2 to exit [1]: Press 1

      v. Enter the APEX static resources location: D:\OracleSoftware\ords\images

      w. Enter 1 if using HTTP or 2 if using HTTPS [1]: Press 1

URL for Go to Apex Development

      http://localhost:8080/

Run ORDS

1. Open Command Prompt(CMD)

2. Go to the path D:\OracleSoftware\ords by command

    i. d:

    ii. cd OracleSoftware

    iii. cd words

    iv. java -jar ords.war