Skip to Main Content
Forums

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How do I migrate from OHS to ORDS?

RichDBAMay 26 2015 — edited Jun 9 2015

Afternoon all,

I have an existing OHS install that's running a number of DAD's to connect to different databases all running Apex 4.2.  I'm looking to migrate to using ORDS on Tomcat.

I've tested deploying ORDS to Tomcat and connecting to a new default 11g XE install and all works fine, I'm comfortable with the process of running the ORDS install itself, but wondered if there's a document on MOS or somewhere similar on how to migrate an existing install, what pitfalls to look out for, what might need changing when using a different listener etc.

I did read a thread on here that mentioned things like authentication might need changing when using the ORDS listener over OHS etc.

As a side note, I'm aware that I can convert each of those DAD's to individual war files deployed to Tomcat by changing the war file name and using a different context root, or I can use mapping and set up each database on a single ORDS war install, there isn't much documentation about this, is there an Oracle recommended stance on this?

If anyone is able to provide any guidance or a link I'd really appreciate it.

Kind Regards

Rich
This post has been answered by Kiran Pawar on May 28 2015
Jump to Answer

Comments

Kiran Pawar
Answer

Hi RichDBA,

RichDBA wrote:





I have an existing OHS install that's running a number of DAD's to connect to different databases all running Apex 4.2.  I'm looking to migrate to using ORDS on Tomcat.




I've tested deploying ORDS to Tomcat and connecting to a new default 11g XE install and all works fine, I'm comfortable with the process of running the ORDS install itself, but wondered if there's a document on MOS or somewhere similar on how to migrate an existing install, what pitfalls to look out for, what might need changing when using a different listener etc.

     You are changing the Web Tier of Oracle APEX and this will require nothing but proper configuration of Web Server with existing Oracle APEX installation.

I did read a thread on here that mentioned things like authentication might need changing when using the ORDS listener over OHS etc.

     Then mention that threads, and how do they resemble your authentication scheme issues.

As a side note, I'm aware that I can convert each of those DAD's to individual war files deployed to Tomcat by changing the war file name and using a different context root, or I can use mapping and set up each database on a single ORDS war install, there isn't much documentation about this, is there an Oracle recommended stance on this?

     With ORDS 2.0 (latest ORDS 3.0) you don't require to generate different ords.war for each DAD configuration. In this ORDS you can configure multiple databases and through URL mapping feature you can have multiple APEX instances listening to one Web Server.

     Refer :

     Hope this helps!

Regards,

Kiran

Marked as Answer by RichDBA · Sep 27 2020
RichDBA

Thanks Kiran, that's extremely helpful and answered my queries.

One small clarification then, I'm assuming as I'm only altering the web tier, that I can set up the ORDS listener to point to the DB and start using it in parallel with the OHS install that I have, and once I'm happy that it's working, just shutdown the OHS instance?

Kiran Pawar

Hi RichDBA,

RichDBA wrote:




One small clarification then, I'm assuming as I'm only altering the web tier, that I can set up the ORDS listener to point to the DB and start using it in parallel with the OHS install that I have, and once I'm happy that it's working, just shutdown the OHS instance?

     Yes, you can set up ORDS in parallel with OHS(If you are setting up OHS and ORDS on same server then just take care of the ports. They have to be different). While configuring ORDS you have to point to the correct DB where APEX is installed.

     Once, your APEX instance is stable and you are satisfied with ORDS configuration you can shutdown the OHS instance.

Regards,

Kiran

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 7 2015
Added on May 26 2015
#migration
3 comments
2,292 views