0 
Oracle ORDS 3.0
Oracle 12c database
Red Hat Linux 6.8
Tomcat 8.0.22

Can two ORDS be deployed to one web server (Tomcat) and access the same database? If so, how is this accomplished?

That is, I would be deploying to Tomcat an ords1.war file and an ords2.war file that both connect to the same Oracle database.

Better yet, I need two URLs that point to two different applications running on the same database. Perhaps another ORDS is not needed.

The context root (normally just 'ords') has to be different for each application. For example, ords1 and ords2. Hence, the thought that there needs to be a ords1.war and ords2.war file deployed.

Improve this question
2
  • Why do you want to do that?
    – Michael Kutz
    Commented May 4, 2018 at 9:31
  • I have a request to setup another URL to access the database.
    – tale852150
    Commented May 4, 2018 at 11:02

1 Answer 1

Reset to default
0

This can be done.

Make a copy of the existing ords.war (call it, say, ords2.war) and just follow the same process that you would when creating your initial ORDS .war file. Just be sure to use different configuration directories for each ORDS .war file in order to avoid possible collisions.

You name the two ORDS .war file differently in order to change the 'root'. For example:

https://mywebsite.com/ords/...
https://mywebsite.com/ords2/...

has the 'root' of ords and ords2, respectively

Improve this answer
9
  • Each ORDS will share a db repo, so upgrade one ORDS, and you'll have to prob upgrade the other
    – thatjeffsmith
    Commented May 7, 2018 at 12:29
  • @thatjeffsmith - thanks for the note. Not a big problem in my case. I enjoy your blog btw.
    – tale852150
    Commented May 7, 2018 at 13:32
  • @thatjeffsmith - can both ORDS share the same cache folder (as defined in the defaults,xml file within each ORDS's conf folder)? Is there anything else that needs to be defined to avoid collisions?
    – tale852150
    Commented Nov 28, 2018 at 16:01
  • they could share that folder - but why do you need 2 ords for the same db? seems like a lot of overhead just to get a different URL
    – thatjeffsmith
    Commented Nov 28, 2018 at 16:19
  • Thanks Jeff. Customer requested specific URL that does not contain /ords in the URL string. Other apps use /ords in the URL.
    – tale852150
    Commented Nov 28, 2018 at 16:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.