Skip to Main Content

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

920799
Done ....

My account -- > configure the device
user4531066
Hello,

Any chance you could post the instructions to create a "dashboard" device? It's not in any of th edocumentation.

Thanks!
user12068228
Hi
Did you find a solution for this? I have the same problem. I configured e-mail settings and use system subject area. Sending Agents via E-Mail is working. But sending Agents to the user homepage gives me the error: "Device (dashboard) is not set in..."
Thank you
User_5TGU6
Hi,

Can you kindly elaborate your solution.. Coz i am getting the same error and going crazy on it..
Plz do the needfull
Mark.Thompson
I guess nobody ever told him that it's nice to share.
Mark.Thompson
Throw us a bone here. How did you resolve this problem? Please tell us the steps to configure the user account so that we can send to a dashboard.
user12068228
Hi
I had the same problem in 11.1.1.6.1. In 11.1.1.6.2 BP1 it is gone.
Regards
Mark.Thompson
Not for me. I installed BP1 last weekend and I still can't send an alert to my dashboard. Did you do anything special to make it work?
user12068228
No nothing that I'd be aware of.
920799
Hi

Sorry for the delayed reply i havnt looked in to ibots for last few months...

Steps to configure device..

After login into analytics....click on ur username u used to login and select My Account..there u can Add email..

As for as i know u can do this only if u are sending ibots to few users...

we have to create SA system subject area as shown in below URL

http://oraclebizint.wordpress.com/2008/04/25/oracle-bi-ee-101332-sa-system-subject-area-autoloading-profiles-and-bursting/

please send a test mail to shekaready@gmail.com i will send u a doc with screen shots on how to add Device..


Apologies again...for the delayed reply
Mark.Thompson
I'm sorry, I don't understand why you are telling me how to add an e-mail device. Sending to e-mail isn't a problem. It's sending the alert to the dashboard that isn't working.
RockITCity
I have saw the same issue after upgrading to 11.1.1.6.2. BP1 and found the following:

http://obirockit.blogspot.com/2012/08/obi-11g-agent-messagedevice-dashboard.html
1 - 12
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 7 2015
Added on May 26 2015
3 comments
2,254 views