Skip to Main Content

Analytics Software

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.

Installation steps

VBajajMar 9 2016 — edited Mar 22 2016

Hi all,

I have installed 11.1.2.4 on Linux + Windows Machine. And its working fine when I access it via awb, HyperionPlanning, Workspace.

But I want to access all the components from Workspace. It is not working. Please guide me which configuration and where I have to do so that I could access all via Workspace directly.

Thanks,

Vishal

Comments

591186
[http://www.orafaq.com/wiki/XA_FAQ]

also. You have to execute $ORACLE_HOME/rdbms/admin/xaview.sql to have XA releated views created.

Perhaps, Metalink note : Required Grants For Retail Integration Bus Distributed XA Transaction-467466.1 Would help.


HTH
Anantha.
Timur Akhmadeev
From what I gathered, I think I need to run initjvm.sql and initxa.sql but I am not entirely sure.
Starting with JDBC driver 10g you don't have to execute initxa.sql. Basically, before 10g JDBC driver [used a PL/SQL package|http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/xadistra.htm#BGBIDIGD] named JAVA_XA to manage distributed transactions, but with 10g it doesn't require additional database configuration, since it uses native protocol (claimed to be faster) without issuing PL/SQL.
Also, what is the XA driver class called? Is that oracle.jdbc.xa.client.OracleXADatasource?
Yes.
708336
Hi,

Thanks for the response.
Does this mean I still need to run initjvm.sql and grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to user?
Timur Akhmadeev
Does this mean I still need to run initjvm.sql and grant select,insert,update,delete on DBA_PENDING_TRANSACTIONS to user?
According to documentation - no.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 19 2016
Added on Mar 9 2016
34 comments
6,090 views