Skip to Content
author's profile photo Former Member
Former Member

UD Connect: Installation of JDBC Driver for Oracle

Hello

Environment: SAP BW 3.5

Objective: Configure J2EE for UDI connect to Oracle

Question: What's the correct installation procedure

for the installation of the Oracle JDBC driver?

The white paper "how to...configure UD Connect on the

J2EE Server for JDBC Access to external databases" shows

how to add a JDBC driver to the resource adapter (example for SQL).

According to the installations instruction in OSS Note 509719 "Installation of Oracle JDBC-Drivers" there is

no registration mentioned by means of the Visual Administrator.

What is the exact installation procedure for the

Oracle JDBC-Driver-Installation?

Thanks for your help.

Regards

Chris Johner

Add comment
10|10000 characters needed characters exceeded

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2005 at 01:40 PM

    Hi Christof,

    I don't have any clue, what UD is, but if it uses the connector framework, note 773401 is really good.

    Regards, Karsten

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2005 at 03:32 PM

    Hello Christof,

    Are you still having issues with UD Connect? I believe the user name and password should be entered as separate parameteres in the setup within Visual administrator. The whitepaper states that they are entered separately from JDBC URL.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Yes, the problem is solved now:

      the right URL is: jdbc:oracle:thin:@<hostname>:1527,<username>,<password>

      The password and the user have to be entered in the VA in the separate fields. The last problem that has arised with ther eroor "com.sap.ip.bi.sdk.exception.BIResourceException: Cannot access JDBC metadata at " is due to a Oracle bug:

      Oracle Metalink:

      Bug 1725012 OERI:ttcgcshnd-1 using JDBC thin pre-9i to 9i database

      When using pre-9i Jdbc-Thin to talk to a 9i (or post-9i)

      database, you will see an ORA-600 exception on almost

      everything you do. eg: ORA-600 [ttcgcshnd-1 ].

      Workaround:

      Set event="10841 trace name context forever"

      in the init.ora file

      After that the UDI connect finally worked, thanks!

      Cheers

      Christof

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2006 at 01:33 AM

    Chris,

    I am also trying to configure UDI connection to Oracle in AV and have the same problem. What jar file did you use in the reference and what exactly did you use in the driver name?

    Glenn

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 28, 2007 at 04:33 PM

    Hi,

    Can you please tell me where to get this jar file from.

    and what guide do u use to UD connect the BI 7.0. I am struck and cant find the right guide any help will be apperciated.

    Thanks

    Ibrahim

    Add comment
    10|10000 characters needed characters exceeded