Hello, I'm totally new to Apex so please bear with me :) I’m attempting to configure my environment locally to run legacy Apex applications that uses Oracle HTTP Server 11. My first thought was to use the latest and greatest Apex 23 with Ords 22 and Java 17. It took a little time but I managed to get ORDS running locally. Therefore, I tried to import the sql for the apps downloaded from older application versions and received errors.
So now I’m on a path to replicate the older application. I have Oracle HTTP Server 11 (Java 8) installed and have configured the Dads conf file, as well as copied the ”images” from Apex 23 to HTTP server. After staring the server with opmnctl startall I’m able to see that the server is up as I can see the Oracle Fusion Middleware 11g page. However when I go to ip:port/pls/apex I get
HTTP-503 ORA-12505 ORA-12505: TNS:listener does not currently know of SID given in connect descriptor\n
I have played around with my Dads file but nothing works. Is this because Apex 23 is expecting Ords or Tomcat and won’t deploy in HTTP server or am I really close 😊.
Also, is there a way to update my SQL files to work with the newer versions of Apex/Ords instead of relying on HTTP server?