Wednesday, August 26, 2020

How to Install Oracle Apex 20.1 on windows 10 with oracle database 19c


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

Installing Oracle Apex 20.1 as like the previous version.

1>  First download the the Oracle apex 20.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 20.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 20.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 ACCOUNT UNLOCK;

           #    ALTER USER APEX_PUBLIC_USER IDENTIFIED BY rony;

           #   alter user anonymous identified by oracle 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



No comments:

Post a Comment