<div>
I ended up uninstalling and using an alternative DB.
</div>

I ended up uninstalling and using an alternative DB.

<div>
<div class="content wysiwyg-content">
I have BO 4.1, Oracle 11 on windows server 2008 R2. I cna coonect to Oracle through SQL Plus etc. WHen I try to create a connection through IDT &nbsp;I get com/businessobjects/connectionserver/PropertySet$CancelSupportLevel - Terst Failed. Screen shots attached 
 
Listener log 
27-APR-2015 07:57:33 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\app\Administrator\product\11.2.0\dbhome_1\perl\bin\perl.exe)(HOST=ALPSVXLABBO)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=62326)) * establish * orcl * 0 
Trace file 
|feb8938b-6607-8324-d94a-9e1c8b1b819e|2015 04 27 07:56:33:507|-0400|Error| | &nbsp;|E| |cms_ALPSVXLABBO.CentralManagementServer| 2708|3932|| |51|0|1|0|BIPSDK.ServiceMgr:getManagedService|alpsvxlabBO:7084:1.94885:1|BIPSDK.ServiceMgr:getManagedService|alpsvxlabBO:7084:1.94885:1|cms_ALPSVXLABBO.CentralManagementServer.newService|localhost:2708:3932.1145112:1|ChG0GKRJAUGGj01x.bvnD2E172a5|||||||||||Failed to get session id from handle and handle is not set to bypass nor server-server discovery
</div>
</div>

I have BO 4.1, Oracle 11 on windows server 2008 R2. I cna coonect to Oracle through SQL Plus etc. WHen I try to create a connection through IDT  I get com/businessobjects/connectionserver/PropertySet$CancelSupportLevel - Terst Failed. Screen shots attached

Listener log
27-APR-2015 07:57:33 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=C:\app\Administrator\product\11.2.0\dbhome_1\perl\bin\perl.exe)(HOST=ALPSVXLABBO)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=62326)) * establish * orcl * 0
Trace file
|feb8938b-6607-8324-d94a-9e1c8b1b819e|2015 04 27 07:56:33:507|-0400|Error| |  |E| |cms_ALPSVXLABBO.CentralManagementServer| 2708|3932|| |51|0|1|0|BIPSDK.ServiceMgr:getManagedService|alpsvxlabBO:7084:1.94885:1|BIPSDK.ServiceMgr:getManagedService|alpsvxlabBO:7084:1.94885:1|cms_ALPSVXLABBO.CentralManagementServer.newService|localhost:2708:3932.1145112:1|ChG0GKRJAUGGj01x.bvnD2E172a5|||||||||||Failed to get session id from handle and handle is not set to bypass nor server-server discovery

Oracle connection in IDT Business objects problem

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

SAP makes enterprise software products, including Customer Relationship Management (CRM), Enterprise Resource Planning (ERP), Product Lifecycle Management (PLM), Supply Chain Management (SCM) and Supplier Relationship Management (SRM) titles, the database product Sybase, along with numerous other products specific to various industries, using a variety of platforms and frameworks.