Step by step full installation. I used oracle Apex version 20.2 using ORDS installation and configuration. database version Oracle 12c. added
Is apex installed by default in all
1) Downloading the latest version
https://www.oracle.com/tools/downloads/apex-downloads.html
2) Change your working directory to apex (unzipped APEX software)
AND then connect to the main Oracle database with sys user from SQLPLUS as
below-
(I have multiple version of database in my
machine so I explicitly invoke 12c env.)
3) Create a tablespace (apex_tbs) for only APEX metadata –
SQL> CREATE TABLESPACE apex_tbs DATAFILE 'C:\app12c\oracle\oradata\atlantadb\apex_tbs_01.dbf' SIZE 200M AUTOEXTEND ON NEXT 10M;
4) Install apex using below command –
Syntax:
@apexins.sql tablespace_apex tablespace_files tablespace_temp images
Description:
· tablespace_apex is the name of the tablespace for the Oracle Application Express application user. In our
· tablespace_files is the name of the tablespace for the Oracle Application Express files user. In our
· tablespace_temp is the name of the temporary tablespace or tablespace group. In our case
· images is the virtual directory for Oracle Application Express images. To support future Oracle Application Express upgrades, define the virtual image directory /i/
SQL> @apexins.sql apex_tbs apex_tbs temp /i/
After successfully complete, you see output like this-
When Application Express installs, it creates the following database accounts:
- APEX_200200 - This account owns the Application Express schema and metadata. (This name might differ based on
Apex - FLOWS_FILES - This account owns the Application Express uploaded files.
- APEX_PUBLIC_USER - This minimally privileged account is used for Application Express configuration with Oracle REST Data Services or Oracle HTTP Server and mod_plsql.
If you configured RESTful Web services, then these additional accounts will be created:
- APEX_INSTANCE_ADMIN_USER - A minimally privileged account used for the REST
- APEX_REST_PUBLIC_USER - The account used when invoking RESTful Services definitions stored in Oracle Application Express.
- APEX_LISTENER - The account used to query RESTful Services definitions stored in Oracle Application Express.
If you are upgrading from a previous release, then FLOWS_FILES already exists and APEX_PUBLIC_USER is created if it does not already exist.
5) For Changing Apex Instance Administrator password using (apxchpwd.sql )
What Is an Instance Administrator?
Instance administrators are superusers that are responsible for managing an entire Oracle Application Express instance, including managing workspace provisioning, configuring features and instance settings, and managing security.
· Change your working directory to the apex directory where you unzipped the installation software.
· Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role
SQL> @apxchpwd.sql
Output-
Note: You must run the apxchpwd.sql script in the following scenarios:
· New Oracle Application Express installations -
· Converting of a runtime environment to a development environment
· Changing Your Instance Administrator Password
· Unlocking Your Instance Administrator Account
6) Unlock and change passwork
SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY apex123$ account unlock ;
Note to remember: Password might expire in 180 days, so need a separate profile with never expire password then assign to this user.
----------------------------Apex software Installation completed--------------------------
7) Configuring Oracle RESTful Services (ORDS)
In a new installation of Oracle Application Express, you must run the configuration script apex_rest_config.sql to configure RESTful Services.
SQL>@apex_rest_config.sql
When
When configuring RESTful Services in Oracle Application Express, it creates two new database accounts.
- APEX_LISTENER - The account used to query RESTful Services definitions stored in Oracle Application Express.
- APEX_REST_PUBLIC_USER - The account used when calling RESTful Services definitions stored in Oracle Application Express.
8) Unlock all below users if they are locked and change password
ALTER USER APEX_LISTENER IDENTIFIED BY Apex123$ ACCOUNT UNLOCK;ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Apex123$ ACCOUNT UNLOCK;ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY Apex123$ ACCOUNT UNLOCK;
9) Download and install ORDS Oracle rest data services
https://www.oracle.com/database/technologies/appdev/rest-data-services-downloads.html
I downloaded - “Oracle REST Data Services”
a) After download unzip the file – something like - C:\apex_20.2_en\ords
b) Make a conf folder something like - C:\apex_20.2_en\ords\conf
c) Setup ords param file : C:\apex_20.2_en\ords\params\ords_params.properties with below properties - it should be based on you environments
db.hostname=my-PC
db.port=1521
#db.servicename=
db.sid=atlantadb
db.username=APEX_PUBLIC_USER
db.password=Apex123$
migrate.apex.rest=false
plsql.gateway.add=true
rest.services.apex.add=true
rest.services.ords.add=true
schema.tablespace.default=apex_tbs
schema.tablespace.temp=TEMP
standalone.mode=true
# Next 3 lines for standalone mode only.
standalone.use.https=true
standalone.http.port=8080
standalone.static.images=C:\apex_20.2_en\apex\images
user.apex.listener.password=Apex123$
user.apex.restpublic.password=Apex123$
user.public.password=Apex123$
user.tablespace.default=apex_tbs
user.tablespace.temp=TEMP
#sys.user=SYS
#sys.password=sys
# Enable REST Enabled SQL.
restEnabledSql.active=true
# Enable SQL Developer Web. Available from 19.4 onward. Requires REST Enabled SQL.
feature.sdw=true
# Enable database APIs. Available from 19.1 onward.
database.api.enabled=true
d) Specifying configuration file :
C:\apex_20.2_en\ords>java -jar ords.war configdir C:\apex_20.2_en\ords\conf
e) Installing ORDS :
C:\apex_20.2_en\ords>java -jar ords.war
Output-
10) After a successful installation you can Validate ORDS services
C:\apex_20.2_en\ords> java -jar ords.war validate
11)Running ORDS in Standalone mode ( it should be running for using apex like http
ords>java -jar
This value will show when it is running in standalone mode
C:\apex_20.2_en\ords>java -jar ords.war standalone
Enter the APEX static resources location [C:apex_20.2_enapeximages]:C:\apex_20.2_en\apex\images
Enter 1 if using HTTP or 2 if using HTTPS [1]:2
Enter the HTTPS port [8443]:
Enter the SSL hostname:my-PC
Enter 1 to use the self-signed certificate or 2 if you will provide the SSL certificate [1]:1
2021-01-14T02:44:55.057Z INFO HTTPS and HTTPS/2 listening on host: localhost port: 8443
2021-01-14T02:44:55.101Z INFO Disabling document root because the specified folder does not exist: C:\apex_20.2_en\ords\conf\ords\standalone\doc_root
2021-01-14T02:44:56.358Z INFO Configuration properties for: |apex||
database.api.enabled=true
db.connectionType=basic
db.hostname=my-PC
db.port=1521
db.sid=atlantadb
feature.sdw=true
...............
..............
2021-01-14T02:44:58.905Z INFO Oracle REST Data Services initialized
Oracle REST Data Services
Oracle REST Data Services server info: jetty/9.4.30.v20200611
12) Now it is time to login
Admin login
https://my-pc:8443/ords/apex_admin
apex instance admin
password for me: Halim123$
Developer Login with workspace name:
workspace name: Halim
https://my-pc:8443/ords/f?p=4550:10:14418526633984:::::
https://my-pc:8443/ords/f?p=4550:1:2335960019865:::::
Success!!
Note: I used auto SSL (for HTTPS) when running ORDS. it uses jetty and
ORDS will automatically create a self-signed certificate for use with SSL if you don't specify a valid certificate and key.
Edit the "/u01/
Or It default it will be added when you provided in the prompt
jetty.secure.port=8443
13) ---Deploying to Weblogic server
14) ----Deployment to apache Tomcat
References:
----Downloading and installing Oracle APEX
https://oracle-base.com/articles/misc/oracle-application-express-apex-installation
---Configuring and Installing Oracle rest data services (ORDS)
---Running on Standalone mode
https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-standalone-mode
Issues and solution:
Issue #1: Image directory not setup correctly in
"There is a problem with your environment because the Application Express files have not been loaded. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide.
Solution:
1. Go to the apex\utilities directory.
cmd> cd C:\apex_20.2_en\apex\utilities
2. Login to database with sys user
I have multiple
C:\apex_20.2_en\apex\utilities>C:\app12c\oracle\product\12.1.0\dbhome_1\BIN\sqlplus.exe
SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 2 09:00:48 2021
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: sys as
Enter password:
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics
SQL>
3. Then run this script reset_image_prefix.sql as mentioned above.
SQL> @reset_image_prefix.sql
Just enter.
4. Correct the standalon property file - standalone.properties
in this location- C:\apex_20.2_en\ords\conf\ords\standalone
content of standalone.properties
jetty.port=8080 # after installation I changed the port 8080 for http mode to run the application
standalone.context.path=/ords
standalone.doc.root=C\:\\apex_20.2_en\\ords\\conf\\ords\\standalone\\doc_root
standalone.scheme.do.not.prompt=true
standalone.static.context.path=/i
standalone.static.path=C\:\\apex_20.2_en\\apex\\images
Make sure blue highlighted line is correct.
