Installing Oracle Apex 21.1 with 19C Database and Configure ORDS

================================================================================================================================================

Installing Oracle Apex 21.1 as like the previous version.

1>  First download the the Oracle apex 21.1 apex software from the below link

https://www.oracle.com/tools/downloads/apex-v191-downloads.html

2>  After downloading extract the zip file

3>  Open the command prompt on windows  to change the directory

4>  Now take the location just like  

D:\apex

5> On the command prompt write the command :cd the the location 

D:\apex

6> Now run the oracle apex 21.1 all scripts from this software .So login to the sys user.

# sqlplus sys/sys as sysdba

     After login to the sys user run the script

# @apexins SYSAUX SYSAUX TEMP /i/

8> Now run the password change script for the admin user.

     Login the sys user

  sqlplus sys/sys as sysdba

@apxchpwd.sql

9> Configure Apex RESTful Services as follows: 

    Connect to Oracle Using SQL*PLUS if disconnected

# sqlplus sys/syspsw@orcl as sysdba

#@apex_rest_config.sql

9> To copy the Oracle Apex 21.1 images to the apex/images folder .Run the script.

  @apex_epg_config.sql D:\

10> Unlock the APEX_PUBLIC_USER account and specify the password.Don’t forget to connect to Oracle using SQL *PLUS not cmd if disconnected.

# ALTER USER APEX_PUBLIC_USER  IDENTIFIED BY  password ACCOUNT UNLOCK;

          

           #   alter user anonymous identified by password account unlock;

12> Set the HTTP Port if using HTTP server as follows

    Connect to oracle using SQL PLUS if disconnected

#sqlplus sys/syspsw@orcl as sysdba

          #EXEC DBMS_XDB.SETHTTPPORT(8181);  

Enabling Network Services for Oracle Database 12C or later version:

/* First connect as the SYS user with SYSDBA role from sqlplus not cmd */ 

sqlplus sys/syspsw@orcl as sysdba

/* Then execute the below script */

Begin

    DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(

        host => '*',

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

                           principal_name => 'APEX_200100',

                           principal_type => xs_acl.ptype_db));

End;

/

Now your Installation and configuration are complete for Oracle Apex 20.1.You can open the Oracle Apex in a browser using the following URL:

http://localhost:8181/apex/apex_admin

=========================================================================

ORDS Configuration