How to Install Oracle Apex 20.2

# install Oracle apex 20.2

# User unlock

# ords configure

# install Oracle apex 20.2

show parameter memory_target

alter system set memory_target='300m' scope=spfile;

create tablespace apex

logging

datafile 'F:\oracle\app\oraclehome2\oradata\ORCL\apex.dbf' size 1024m

autoextend on

next 64m maxsize 5g

extent management local;




--@apexins.sql tablespace_apex tablespace_files tablespace_temp images

@apexins apex apex temp /i/

@apxchpwd.sql

@apex_rest_config.sql




# User unlock

select username,account_status from dba_users where upper(username) like upper('apex%');

select username,account_status from dba_users where upper(username) like upper('ords%');




alter user apex_listener identified by Test_1234 account unlock ;

alter user apex_public_user identified by Test_1234 account unlock ;

alter user apex_rest_public_user identified by Test_1234 account unlock ;

alter user apex_instance_admin_user identified by Test_1234 account unlock ;

alter user apex_200200 identified by Test_1234 account unlock ;

alter user ords_metadata identified by Test_1234 account unlock ;

alter user ords_public_user identified by Test_1234 account unlock ;

alter user ordsys identified by Test_1234 account unlock ;




# oracle database 12c,19c... or later

begin

dbms_network_acl_admin.append_host_ace(

host => '*',

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

principal_name => 'apex_200200',

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_200200',

principal_type => xs_acl.ptype_db));

end;

/

exec dbms_xdb.sethttpport(8080);

commit;




# ords configure

--Images folder Copy and paste to ords folder

--Create Config Folder in ords folder

cmd

cd F:\ords

java -jar ords.war

Microsoft Windows [Version 10.0.18363.1256]

(c) 2019 Microsoft Corporation. All rights reserved.

C:\Users\User>cd F:\ords

C:\Users\User>F:

F:\ords>java -jar ords.war

This Oracle REST Data Services instance has not yet been configured.

Please complete the following prompts







Enter the location to store configuration data: F:\ords\Config

Enter the name of the database server [localhost]:

Enter the database listen port [1521]:

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

Enter the database service name:orcl

Enter the database password for ORDS_PUBLIC_USER:

Confirm password:

Requires to login with administrator privileges to verify Oracle REST Data Services schema.




Enter the administrator username: sys

Enter the database password for SYS AS SYSDBA:

Confirm password:




Retrieving information.

Enter 1 if you want to use PL/SQL Gateway or 2 to skip this step.

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

Enter the database password for APEX_PUBLIC_USER:

Confirm password:

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]:

Enter the database password for APEX_LISTENER:

Confirm password:

Enter the database password for APEX_REST_PUBLIC_USER:

Confirm password:

Jan 07, 2021 3:41:19 PM

INFO: reloaded pools: []

Installing Oracle REST Data Services version 19.2.0.r1991647

... Log file written to C:\Users\User\ords_install_core_2021-01-07_154120_00558.log

... Verified database prerequisites

... Created Oracle REST Data Services proxy user

... Created Oracle REST Data Services schema

... Granted privileges to Oracle REST Data Services

... Created Oracle REST Data Services database objects

... Log file written to C:\Users\User\ords_install_datamodel_2021-01-07_154136_00773.log

... Log file written to C:\Users\User\ords_install_apex_2021-01-07_154139_00059.log

Completed installation for Oracle REST Data Services version 19.2.0.r1991647. Elapsed time: 00:00:22.5




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

Enter the APEX static resources location: F:\ords\images

Enter 1 if using HTTP or 2 if using HTTPS [1]:

2021-01-07 15:43:13.361:INFO::main: Logging initialized @232043ms to org.eclipse.jetty.util.log.StdErrLog

Jan 07, 2021 3:43:13 PM

INFO: HTTP and HTTP/2 cleartext listening on port: 8080

Jan 07, 2021 3:43:13 PM

INFO: Disabling document root because the specified folder does not exist: F:\ords\Config\ords\standalone\doc_root

2021-01-07 15:43:14.087:INFO:oejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2019-05-02T09:46:34.874Z; git: 14f32d50076f2b706f41a33066eb364d8492e199; jvm 1.8.0_271-b09

2021-01-07 15:43:14.105:INFO:oejs.session:main: DefaultSessionIdManager workerName=node0

2021-01-07 15:43:14.106:INFO:oejs.session:main: No SessionScavenger set, using defaults

2021-01-07 15:43:14.107:INFO:oejs.session:main: node0 Scavenging every 600000ms

Jan 07, 2021 3:43:14 PM

INFO: Configuration properties for: |apex||

db.hostname=localhost

db.password=******

db.port=1521

db.servicename=orcl

db.username=APEX_PUBLIC_USER

resource.templates.enabled=true

security.requestValidationFunction=wwv_flow_epg_include_modules.authorize

security.validationFunctionType=plsql




Jan 07, 2021 3:43:14 PM

WARNING: *** jdbc.MaxLimit in configuration |apex|| is using a value of 10, this setting may not be sized adequately for a production environment ***

Jan 07, 2021 3:43:14 PM

WARNING: *** jdbc.InitialLimit in configuration |apex|| is using a value of 3, this setting may not be sized adequately for a production environment ***

Jan 07, 2021 3:43:15 PM

INFO: Configuration properties for: |apex|al|

db.hostname=localhost

db.password=******

db.port=1521

db.servicename=orcl

db.username=APEX_LISTENER

resource.templates.enabled=true

security.requestValidationFunction=wwv_flow_epg_include_modules.authorize

security.validationFunctionType=plsql




Jan 07, 2021 3:43:15 PM

WARNING: *** jdbc.MaxLimit in configuration |apex|al| is using a value of 10, this setting may not be sized adequately for a production environment ***

Jan 07, 2021 3:43:15 PM

WARNING: *** jdbc.InitialLimit in configuration |apex|al| is using a value of 3, this setting may not be sized adequately for a production environment ***

Jan 07, 2021 3:43:15 PM

INFO: Configuration properties for: |apex|pu|

db.hostname=localhost

db.password=******

db.port=1521

db.servicename=orcl

db.username=ORDS_PUBLIC_USER

resource.templates.enabled=true

security.requestValidationFunction=wwv_flow_epg_include_modules.authorize

security.validationFunctionType=plsql




Jan 07, 2021 3:43:15 PM

WARNING: *** jdbc.MaxLimit in configuration |apex|pu| is using a value of 10, this setting may not be sized adequately for a production environment ***

Jan 07, 2021 3:43:15 PM

WARNING: *** jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequately for a production environment ***

Jan 07, 2021 3:43:16 PM

INFO: Configuration properties for: |apex|rt|

db.hostname=localhost

db.password=******

db.port=1521

db.servicename=orcl

db.username=APEX_REST_PUBLIC_USER

resource.templates.enabled=true

security.requestValidationFunction=wwv_flow_epg_include_modules.authorize

security.validationFunctionType=plsql




Jan 07, 2021 3:43:16 PM

WARNING: *** jdbc.MaxLimit in configuration |apex|rt| is using a value of 10, this setting may not be sized adequately for a production environment ***

Jan 07, 2021 3:43:16 PM

WARNING: *** jdbc.InitialLimit in configuration |apex|rt| is using a value of 3, this setting may not be sized adequately for a production environment ***

Jan 07, 2021 3:43:16 PM

INFO: Oracle REST Data Services initialized

Oracle REST Data Services version : 19.2.0.r1991647

Oracle REST Data Services server info: jetty/9.4.z-SNAPSHOT




2021-01-07 15:43:17.357:INFO:oejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@2ca923bb{/ords,null,AVAILABLE}

2021-01-07 15:43:17.362:INFO:oejsh.ContextHandler:main: Started o.e.j.s.h.ContextHandler@13bc8645{/i,null,AVAILABLE}

2021-01-07 15:43:17.773:INFO:oejs.AbstractConnector:main: Started ServerConnector@47f9738{HTTP/1.1,[http/1.1, h2c]}{0.0.0.0:8080}

2021-01-07 15:43:17.774:INFO:oejs.Server:main: Started @236456ms

Jan 07, 2021 3:46:07 PM







http://127.0.0.1:8080/apex




# Application server

# install Tomcat

# https://tomcat.apache.org/download-90.cgi

# create i filder in tomcat -- C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\i

# Add Images pathlocation -- C:\Program Files\Apache Software Foundation\Tomcat 9.0\conf\server.xml




<Host name="localhost" appBase="webapps"

unpackWARs="true" autoDeploy="true">

<!--Images pathlocation-->

<Context docBase="F:\ords\images" path="/i" />