Install oracle apex on Linux:
Following software are installed in the given order for Apex.
1- openjdk-11.0.2_linux-x64_bin.tar
2- Oracle Database.
3- apex_20.2.zip
4- apache-tomcat-9.0.41.tar.gz
5- ords-20.4.1.013.1644.zip (ords have a .war file which will be deployed on tomacat to access apex).
OS: Linux_x64
1- install database. (I installed 12.1.0.2.0)
2- ------------ Installing Apex ------------------------
a) create dedicated tablespace for apex.
create tablespace apex datafile '/opt/oracle/oradata/orcl/apex01.dbf' SIZE 100M AUTOEXTEND ON NEXT 1M;
b) create directy in which we want to install the apex. unzip the zip file of apex setup (apex_20.2.zip).
mkdir /opt/apex
unzip apex_20.2.zip
c) Connect to SQL*Plus as the SYS user and run the "apexins.sql" script, specifying the relevant tablespace names and image URL.
cd /opt/apex
sqlplus / as sysdba
@apexins.sql APEX APEX TEMP /i/
d) change the admin password:
cd /opt/apex
sqlplus /as sysdba
@apxchpwd.sql
-----------------------------
e) Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users by running the "apex_rest_config.sql" script.
sqlplus / as sysdba
@apex_rest_config.sql (i set the password apex)
3- --------------Installing Tomcat -------------------
a) create a directory for java and unzip it.
mkdir /opt/java
tar -xzvf openjdk-11.0.2_linux-x64_bin.tar.gz
b) create soft link to set java as latest java.
ln -s jdk-11.0.1 latest
c) make a directory for tomcat and unzip it.
mkdir /opt/tomcat
tar -xzvf apache-tomcat-9.0.41.tar.gz
ln -s apache-tomcat-9.0.14 latest
d) create .env file for java.
vi /home/oracle/java.env
export JAVA_HOME=/opt/java/jdk-11.0.2
export PATH=$JAVA_HOME/bin:$PATH
e) start the tomcat services.
. /home/oracle/java.env
/opt/tomcat/apache-tomcat-9.0.41/bin
./startup.sh
f) check the status of the tomcat:
ps -ef|grep tomcat
http://192.168.0.100:8080/
4- --------------Installing ORDS ------------------
a) Unlock the following users and change their passwords:
ALTER USER SYS IDENTIFIED BY nosys ACCOUNT UNLOCK;
ALTER USER APEX_LISTENER IDENTIFIED BY apex ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY apex ACCOUNT UNLOCK;
ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY apex ACCOUNT UNLOCK;
-- The next one will fail if you've never installed ORDS before. Ignore errors.
ALTER USER ORDS_PUBLIC_USER IDENTIFIED BY apex ACCOUNT UNLOCK;
b) Unzip the ORDS.
mkdir /opt/ords
unzip ords-20.4.1.013.1644.zip
c) Make a directory to hold the configuration.
mkdir -p /opt/ords/conf
edit the following file and input only given entries.
vi /opt/ords/params/ords_params.properties
db.hostname=localhost
db.port=1521
db.servicename=orcl
db.sid=orcl
d) Set the configuration directory:
cd /opt/ords
. /home/oracle/java.env
$JAVA_HOME/bin/java -jar ords.war configdir /opt/ords/conf
e) Start the configuration:
$JAVA_HOME/bin/java -jar ords.war
--------
[oracle@apex1 ords]$ $JAVA_HOME/bin/java -jar ords.war
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:
Connecting to database user: SYS AS SYSDBA url: jdbc:oracle:thin:@//localhost:1521/orcl
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 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
Choose [1]:
2021-02-01T19:51:51.705Z INFO reloaded pools: []
Installing Oracle REST Data Services version 20.4.1.r0131644
... Log file written to /home/oracle/ords_install_core_2021-02-01_145151_00860.log
... Verified database prerequisites
... Created Oracle REST Data Services proxy user
Warning: Nashorn engine is planned to be removed from a future JDK release
... Created Oracle REST Data Services schema
... Granted privileges to Oracle REST Data Services
... Created Oracle REST Data Services database objects
... Log file written to /home/oracle/ords_install_datamodel_2021-02-01_145218_00571.log
... Log file written to /home/oracle/ords_install_apex_2021-02-01_145222_00690.log
Completed installation for Oracle REST Data Services version 20.4.1.r0131644. Elapsed time: 00:00:34.176
Enter 1 if you wish to start in standalone mode or 2 to exit [1]:2
--------
f)
mkdir -p /opt/tomcat/apache-tomcat-9.0.41/webapps/i
cp -R /opt/apex/images/* /opt/tomcat/apache-tomcat-9.0.41/webapps/i
cp /opt/ords/ords.war /opt/tomcat/apache-tomcat-9.0.41/webapps
g) Change the Tomcat default listen port from 8080 to 8085:
vi /opt/tomcat/apache-tomcat-9.0.41/conf/server.xml
<Connector port="8085" protocol="HTTP/1.1"
connectionTimeout="20000"
redirectPort="8443" />
-----------------------------------------------------------------------------
In-Case of error (WARNING: The pool named: |apex|| is invalid and will be ignored), update the password from following user and
edit the following files and input new password.
alter user ORDS_PUBLIC_USER identified by 381;
alter user APEX_PUBLIC_USER identified by 381;
alter user APEX_LISTENER identified by 381;
alter user APEX_REST_PUBLIC_USER identfied by 381;
cd /opt/ords/conf/ords/conf/
vi apex_rt.xml
vi apex.xml
vi apex_al.xml
vi apex_pu.xml