@satishpasarti, Thanks for your video. During ORDS 20.4.3 installation : I'm stuck for long time after this execution with some exception. please refer the execution flow below, could you please help me your thought. restEnabledSql.active=true security.requestValidationFunction=wwv_flow_epg_include_modules.authorize security.validationFunctionType=plsql db.password=****** db.username=ORDS_PUBLIC_USER resource.templates.enabled=true 2024-08-10T07:13:19.245Z WARNING *** jdbc.MaxLimit in configuration |apex|pu| is using a value of 10, this setting may not be sized adequately for a production environment *** 2024-08-10T07:13:19.245Z WARNING *** jdbc.InitialLimit in configuration |apex|pu| is using a value of 3, this setting may not be sized adequately for a production environment *** 2024-08-10T07:13:19.605Z INFO Configuration properties for: |apex|al| database.api.enabled=true db.connectionType=basic db.hostname=oracl.ca4vlxv1h8yd.eu-central-1.rds.amazonaws.com db.port=1521 db.sid=orcl feature.sdw=true restEnabledSql.active=true security.requestValidationFunction=wwv_flow_epg_include_modules.authorize security.validationFunctionType=plsql db.password=****** db.username=APEX_LISTENER resource.templates.enabled=true 2024-08-10T07:13:19.605Z WARNING *** jdbc.MaxLimit in configuration |apex|al| is using a value of 10, this setting may not be sized adequately for a production environment *** 2024-08-10T07:13:19.606Z WARNING *** jdbc.InitialLimit in configuration |apex|al| is using a value of 3, this setting may not be sized adequately for a production environment *** 2024-08-10T07:13:20.919Z WARNING The pool named: |apex|rt| is invalid and will be ignored: The username or password for the connection pool named |apex|rt|, are invalid, expired, or the account is locked 2024-08-10T07:13:25.904Z INFO Oracle REST Data Services initialized Oracle REST Data Services version : 20.4.3.r0501904 Oracle REST Data Services server info: jetty/9.4.35.v20201120 WARNING :::Got unchcked exception from user-defined connection labeling callback WARNING :::Got unchcked exception from user-defined connection labeling callback

El valor llamado: feature.sdw se ha definido en: true en la configuración: default El valor global llamado: database.api.enabled se ha definido en: true El valor llamado: restEnabledSql.active se ha definido en: true en la configuración: default ------------------------------------------------------------ Fecha : 10 may 2024 15:00:46 Versión : Oracle REST Data Services 22.4.4.r0411526 Tipo : Instalación de ORDS Base de datos : Oracle Database 19c Standard Edition 2 Versión de base de datos : 19.20.0.0.0 2024-05-10T20:00:46.556Z SEVERE ORA-02097: no se puede modificar el parámetro porque el valor especificado no es válido ORA-01031: privilegios insuficientes

cool

Very nice video. Kudos to the hard work

Hi Satish, what are the advantages of Oracle APEX on AWS RDS vs Oracle APEX on OCI?

if i can`t use Putty ... what can i do ? please help.

Do you have similar steps for Installing/Upgrading APEX version on ECS Docker container ?

Hello! When trying to connect for first time to my db instance i get an error ORA-12514 TNS: Listener does not know of service requested in connect descriptor, although I have correct connection string... Any ideas how to check listener status and change the connection name? Thank you! Happy new year...

/*********************************** ********* enable https ************* ************************************/ Purchase a domain from a registrar like namecheap ssh -i yourkeypair.pem ec2-user@[ec2DNSName] go to root sudo -i cd /usr/local/tomcat9 keytool -genkeypair -keystore [yourchoice].keystore -keypass [yourchoice] -storepass [yourchoice] -keyalg RSA -keysize 2048 -alias [yourchoice] -deststoretype pkcs12 provide CN as your domain name and answer few other questions. keytool -certreq -keyalg RSA -alias [yourchoice] -file [yourchoice].csr -keystore [yourchoice].keystore cat [yourchoice].csr copy content to notepad, remove any ^M characters, put in the namecheap certificate and that starts validation process. Choose DCV DNS method. During this process an email is also asked, where the cert zip file is sent after successful validation. from get CNAME record here -> EDIT Methods -> get record This shows the CNAME host and target. Copy those values. In Namecheap Go to Domain List > [Your Domain] > MANAGE > Advanced DNS Modify CNAME Record as below: Host == first part of the host copied. Ex: if your host name copied earlier is _xxxxxxxxxx.yourdomain.com then put only _xxxxxxxxxx Target == copy entire target ex: XXXXXX.YYYYYYY.ZZZZZZ.comodoca.com wait 10 min or call namecheap to validate certificate. download the www_yourdomain.com.zip from namecheap or from email (given durin DNS validation steps) scp -i www_yourdomain.com.zip ec2-user@[ec2DNSName]:/home/ec2-user move it to /usr/local/tomcat9 unzip www_yourdomain.com.zip keytool -import -trustcacerts -alias [yourchoice] -file www_yourdomain.com.p7b -keystore [yourchoice].keystore keytool -list -v -keystore [yourchoice].keystore (or) keytool -list -keystore [yourchoice].keystore chmod 644 [yourchoice].keystore cd /usr/local/tomcat9/conf modify server.xml to use this vi server.xml -------- <Connector port="8080" protocol="HTTP/1.1" connectionTimeout="20000" /> <!-- redirectPort="8443" --> --comment this --add below <Connector port="8443" maxThreads="150" scheme="https" secure="true" SSLEnabled="true" keystoreFile="/usr/local/tomcat9/sonitoca.keystore" keystorePass="soniapex" clientAuth="false" sslProtocol="TLS" /> ------- modify web.xml to use this vi /usr/local/tomcat9/conf/web.xml --add below at the bottom of the file before closing tag </web-app> <security-constraint> <web-resource-collection> <web-resource-name>securedapp</web-resource-name> <url-pattern>/*</url-pattern> </web-resource-collection> <user-data-constraint> <transport-guarantee>CONFIDENTIAL</transport-guarantee> </user-data-constraint> </security-constraint> Restart tomcat cd /usr/local systemctl restart tomcat On AWS security group named APEXLSNSG used by EC2 instance Add inbound route TCP 8443 from 0.0.0.0/0 You can remove 8080 as 8080 insecure port will not respond any more. Launch below and verify. Now the traffic is secured to your APEX applications. yourdomain.com:8443/ords/ (or) ec2DNS:8443/ords/ ******************************************************************

And some one asked about securing using SSL. You could go one of two ways. You can purchase domain, setup a free public certificate in ACM, and create a application load balancer using that certificate and routing traffic to this EC2 listener. Pro is -- free certificate, simple, reliable and scalable setup. But ALB costs additional minimum around $20 a month. Other way is, install certificate directly on the tomcat. I will provide the instructions on it.

Thanks for positive feedback. For questions on upgrades. ***************** How to Upgrade ****************** Make sure the APEX version you are trying to upgrade to is certified on docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.Options.APEX.html. At this writing the version certified is 22.1. Download 22.1 version from Oracle downloads. Database side +++++++ In RDS console, create new options group called ex: apex2201og Add options -- APEX with the latest version needed, APEX_DEV, S3_INTEGRATION Click on Modify button on the database. Under additional configuration > select new options group, keeping everything else same. Click Modify. AWS will upgrade your APEX version to version chosen. From listener side ++++++++ --transmit the softwares scp -i yourkeypair.pem apex_22.1_en.zip ec2-user@[ec2DNSName]:/home/ec2-user --ssh into the instance ssh -i yourkeypair.pem ec2-user@[ec2DNSName] --change to root sudo -i cp /home/ec2-user/apex_22.1_en.zip /home/apexuser/ chmod 777 /home/apexuser/* --su as apexuser su - apexuser --from ec2 linux instance as apexuser move any previous installs, unzip new software mv apex apex_bkp unzip apex_22.1_en.zip Update tomcat artifacts to new 22.1 Apex images etc... /bin/cp -Rf /home/apexuser/apex/images/* /usr/local/tomcat9/webapps/i --go to root exit --restart tomcat systemctl restart tomcat That's it. You can now leverage cool features like PWA. Make sure themes are refreshed and compatibility is set to latest version in apps developed.

to anyone having issues with this being outdated. You CANNOT use teh latest downloads of ords and apex from oracle. amazon RDS only supports a highest version of apex 21.2 in the db options. so you need to roll back all of the downloads to match 21.2. until AWS allows apex 22+ on the db you must go with the old version. if you download the old version then all of his instructions will be accurate.

Brilliant tutorial, like a few others I tried the latest version with failures but this meant I could at least get up and running a Apex instance with the bonus of learning allot of the AWS structure :)

Nice Video I was wondering if youc ould try with latest version (22.1.2) as your video are little out of date, right now everytime I try to create reset the password it errors out so I can never actually login to Apex.

You got the points across very well. I commend you Satish. Good teacher. Keep going.

excellent explaining

Hi Satish, I am completely new to this Oracle apex and RDS. I have an existing Oracle Apex on AWS RDS. And we are planning to upgrade oracle database from 12c to 19c. Do you have a video or something for this.

good job

Thanks man!

Do you have PCDS 8.5 dumps

Yeah very well explained

Your video is really great and helped me. can you do a video on how to connect the DB to the instances?

Your video helped me! Thanks!

Now please setup SSL (443) over load balancer

Hello, I am following your video step by step to be able to do the installation. At the time of doing the configuration in the part that you use MOBAXTERM, there is a part that you do the ls -lrt and you do the configuration using /*sqlcl - 19.4.0.354.0937.zip*/. I am doing it for the first time doing what you indicate step by step, but I did not understand or I never saw where you got all those files that you do when doing the ls -lrt, I only get /*-rw ------ - 1 lguevara UsersGrp 1704 Nov 30 09:27 APEX_KEY_PAIR.pem */. I hope you can help me regarding that. Best regards.

Well Explained

Could you please copy and paste here the commands you type on 3:30?

Hi Satish. Could you help ($) me to migrate my Oracle Apex from Maxapex to AWS implementing high availability, backup and autoscalling?