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:::::
Recent Posts