Hi,
I think I read as of APEX 20.2 EPG and Oracle HTTP server are 'desupported'. i.e. it's ORDS only.
Our app is currently written in APEX 19.2. (which is replacing a legacy client-server app - literally the app on the PC talks to the DB). I am trying to "sell" how great the new APEX world will be to the customer.
"So what do we need to do to run the application"?
"Well - you need to install APEX into the DB - easy - DBA job"
"ok - into all our DBs / envs"?
"yes"
"hmm - ok - we can live with that - what else?"
"ah - ideally, you need ORDS"
"what's ORDS?"
"er, at a very basic level for APEX - think web server, ideally it should be on a separate application server"
"we need to introduce/manage a new server in all our environments? - that's not going to happen"
"you could have one app server (one ORDS install) servicing many DBs ..."
"thats still not going to happen"
"ok - it's possible to install ORDS on the DB server" (although I'm already guessing this is not recommended by Oracle)
"on all the DBs servers?"
"if you don't want an application server in the mix - then yes"
"okkaaaay"
"oh , and ORDS needs JAVA installed ... which I am now not sure the licencing issues of ... and depending on what version of ORDS you install you might need a newer version of JAVA ...."
and so it goes ... why do I feel like I'm pushing uphill?!
So 2 questions:
- Can someone tell me why / what is SO bad about the EPG (apart from being desupported in 20.2 onwards of course!!) ? Is it a security risk (ports etc)? And if so - how is this any greater than if ORDS is also running on the DB server? Is it simply a performance issue (SHARED_SERVERS cannot handle lots and lots of users?)
- Do you need a license for Java if you are just using it to run ORDS?
Thanks