Apex listener to multi Oracle instance - ORDS, SODA & JSON in the Database

Hi,
Is it possible to configure apex listener connect to multiple Oracle instance like what we do in mod_plsql?
I can see only one Oracle instance can be configured in the listener configuration page.
Thanks
Vincent 

Just deploy multiple instances of the listener.

Related

DADS.conf parameter in Listener configuration possible?

I switched from the ORACLE HTTP Server to APEX listener.
Is there any information about how DADS.conf parameters
like PlsqlAuthenticationMode is possible to configure in APEX Listener.
regards
Thorsten

Can you run multiple APEX listeners for different instances on the same server

Please confirm that we can run multiple APEX listeners for different instances on the same server?  Is it an xml setup configuration or do we need to do more??Thank You,Tony MillerSmartDog ServicesAustin, TX
Hi, With latest APEX listener you can Configuring Multiple DatabasesConfiguring Oracle Application Express Listener Is that what you mean? Regards,Jari
Yes.. Just exactly what I was looking for... Thanks Jari!! Thank You,Tony MillerSmartDog ServicesAustin, TX

One Glassfish server - two 11G db servers - how many apex listeners where?

We want to use only one Glassfish installation to manage two APEX installations (prod and test). We're running PROD on box1, we have TEST on box2. We've installed APEX, Apex listener, and Glassfish on box2; we've installed APEX (so far) on box1. I'm guessing we need Apex listener on box1, and want Glassfish to manage the deployed applications from it. Is this correct? 
Hello NancyKay,
We want to use only one Glassfish installation to manage two APEX installations (prod and test).That's possible. You need to deploy APEX Listener two times on that GlassFish using a different context for each deployment, e.g. "apex_test" and "apex_prod".
I'm guessing we need Apex listener on box1, and want Glassfish to manage the deployed applications from it. Is this correct?No. APEX Listener can connect to your APEX (database) instance on box1 from the GlassFish on box2 if your network rules (e.g. firewall) don't block that access. APEX Listener will always use a JDBC connection and is not bound to a local database instance. Possibly you've mixed up APEX Listener with the database listener.
The applications you deploy within APEX don't have anything to do with your GlassFish apart from the fact that your GlassFish hosts the APEX Listener which acts as HTTP frontend for your APEX instance.
-Udo

APEX Listener benefits

What are the real benefits of using apex listener? We are evaluating this tool to convert one of our application which is currently using sql server database and MS Access forms? How difficult can be the conversion? We want it to be web enabled. So is apex listener our option to make it web enabled? Or is it not necessary to use apex listener. Also can the apex listener be installed on the database server itself?
Thanks
Vidya 
Hello Vidya - welcome to the OTN forums!
What are the real benefits of using apex listener? We are evaluating this tool to convert one of our application which is currently using sql server database and MS Access forms? How difficult can be the conversion? We want it to be web enabled. So is apex listener our option to make it web enabled? Or is it not necessary to use apex listener. Also can the apex listener be installed on the database server itself?APEX Listener is a web server to host Oracle Application Express. I think you should start to get an overview on APEX on its [url http://www.oracle.com/technetwork/developer-tools/apex/overview/index.html]OTN homepage. You'll also find tutorials on migrating from MS Access, e.g. starting [url http://www.oracle.com/technetwork/developer-tools/apex/application-express/mig-index-095631.html]here.
So is apex listener our option to make it web enabled? Or is it not necessary to use apex listener.There are two other web servers available for APEX: The "Embedded PL/SQL Gateway" (EPG) hosted by the database internal XDB HTTP Server and mod_plsql, usually hosted by the Oracle HTTP Server (OHS).
Which one you should use depends a bit on what you intend to do.
Also can the apex listener be installed on the database server itself?Yes, you can (but don't have to) install APEX Listener on the same host that runs your database server.
-Udo

Advanced configuration for apex listener

Hi guys, I just discovered apex and apex listener and I want to figure it out and see if it can be a solution for my problem.On this link: Oracle Application Express APEX ListenerI see that it is recommended to you advanced configuration for public productions systems.I also decided that my oracle DB will be installed on a machine and apex listener on a different machine. My question now is if I need a third machine to achieve that configuration where the HTTP server communicates with APEX listener and they are separated by a firewall or they can both be on the same machine and still achieve that? I hope to have apache with tomcat plus apex listener on a single machine and still obtain the needed security.I understand that http server should be separated by apex listener but it should be like a network firewall or…it can be other separation type? I am at the beginnings of web application infrastructure so I need your help. Thank you.

Categories

Resources