Apex Location
=============
/PROD/PROD2020/apex
Linux version
=============
[oracle@ip-172-31-25-66 ~]$ cat /etc/system-release
Amazon Linux 2
cd /PROD/PROD2020/apex
@apex_rest_config.sql --password Pass#123
Unlock Accounts
===============
ALTER USER APEX_LISTENER IDENTIFIED BY Pass#123 ACCOUNT UNLOCK;
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY Pass#123 ACCOUNT UNLOCK;
ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY Pass#123 ACCOUNT UNLOCK;
cd /home/oracle/tomcat_23_0ct_2019
tar -xvf jdk-13.0.1_linux-x64_bin.tar.gz
tar -xvf apache-tomcat-9.0.27.tar.gz
unzip ords-19.1.0.092.1545.zip
vi tomcat.env
export JAVA_HOME=/home/oracle/tomcat_23_0ct_2019/jdk-13.0.1
export CATALINA_HOME=/home/oracle/tomcat_23_0ct_2019/apache-tomcat-9.0.27
export CATALINA_BASE=$CATALINA_HOME
. tomcat.env
cd /home/oracle/tomcat_23_0ct_2019/apache-tomcat-9.0.27/bin
sh startup.sh
check link
http://34.207.117.165:8080
sh shutdown.sh
cd /home/oracle/tomcat_23_0ct_2019/apache-tomcat-9.0.27/conf
vi tomcat-users.xml
add below details
=================
<role rolename="manager-gui" />
<user username="oracle" password="oracle" roles="manager-gui" />
ORDS
====
cd /home/oracle/tomcat_23_0ct_2019/params
vi ords_params.properties
db.hostname=ip-172-31-25-66.ec2.internal
db.port=1526
db.servicename=PROD2020
db.sid=PROD2020
db.username=APEX_PUBLIC_USER
migrate.apex.rest=false
rest.services.apex.add=true --set true
rest.services.ords.add=true
schema.tablespace.default=ORDS
schema.tablespace.temp=TEMP
standalone.http.port=8010
#standalone.static.images=
user.tablespace.default=ORDS
user.tablespace.temp=TEMP
cd /home/oracle/tomcat_23_0ct_2019
/home/oracle/tomcat_23_0ct_2019/jdk-13.0.1/bin/java -jar apex.war configdir /home/oracle/tomcat_23_0ct_2019/ords/conf
cd /home/oracle/tomcat_23_0ct_2019
/home/oracle/tomcat_23_0ct_2019/jdk-13.0.1/bin/java -jar apex.war install advanced
[oracle@ip-172-31-25-66 tomcat_23_0ct_2019]$ /home/oracle/tomcat_23_0ct_2019/jdk-13.0.1/bin/java -jar apex.war install advanced
Enter the name of the database server [ip-172-31-25-66.ec2.internal]:
Enter the database listen port [1526]:
Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
Enter the database service name [PROD2020]:
Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:
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.
Oct 24, 2019 1:29:48 AM oracle.dbtools.rt.config.setup.SchemaSetup getInstallOrUpgrade
WARNING: ORDS_METADATA schema exists. Could not connect as ORDS_PUBLIC_USER: ORA-01017: invalid username/password; logon denied
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 PL/SQL Gateway database user name [APEX_PUBLIC_USER]:
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:
Oct 24, 2019 1:31:33 AM
INFO: reloaded pools: []
Upgrading Oracle REST Data Services schema 3.0.4.60.12.48 to version 19.1.0.r0921545
... Log file written to /home/oracle/ords_upgrade_2019-10-24_013134_00053.log
... Upgrading ORDS schema to 19.1.0.r0921545
Completed upgrade for Oracle REST Data Services version 19.1.0.r0921545. Elapsed time: 00:00:38.235
cd /home/oracle/tomcat_23_0ct_2019/ords/conf/apex/conf
vi apex.xml
add below lines
===============
<entry key="jdbc.InitialLimit">15</entry>
<entry key="jdbc.MinLimit">15</entry>
<entry key="jdbc.MaxLimit">50</entry>
mkdir $CATALINA_HOME/webapps/i/
cp -R /PROD/PROD2020/apex/images/* $CATALINA_HOME/webapps/i/
cd /home/oracle/tomcat_23_0ct_2019
cp apex.war $CATALINA_HOME/webapps
start TOMCAT SERVER
===================
. tomcat.env
cd /home/oracle/tomcat_23_0ct_2019/apache-tomcat-9.0.27/bin
sh startup.sh
http://34.207.117.165:8010/apex/f?p=4550:1:16115265072131:::::
