Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

"Oracle provider for OLE DB" missing in the Data Link Properties

Hello Everyone,

I am a newbie and I am currently doing my first SAP NW Identity Management 7.2 installation. At the moment, I am at the phase where I need to do the initial configuration, but I am stuck at the first step of  Identity Center configuration wizard. The reason is that I am missing "Oracle provider for OLE DB" in the Data Link Properties. I know there are several discussions on the topic, which I went through and I did all the suggestions but none of them worked for me. What I have so far is :

  1. Oracle database software installed - Oracle 11g R2 Database 64x
  2. JRE v6 update 34 - 64x
  3. Oracle client - Oracle 11g R2 Client 64x
  4. Environmental variables:
    • JAVA_HOME
    • PATH
    • CLASSPATH to the jdbc driver in the oracle client folder : ojdbc6.jar
  5. I have changed the Java options in the Identity Center Management Console to the java and jdbc driver specified above
  6. Windows Server 2008 R2 64x

I read that Oracle Provider for OLE DB is included as part of the Oracle installation, this is why I searched for ojdbc.jar files in both installation folders for the client(\oracle_client64x) and the database(\oracle). I found several ojdbc5.jar, ojdbc6.jar,ojdbc14.jar, etc. I started changing the path to each of these jdbc drivers in the the Java options in the Identity Center Management Console and testing to see if "Oracle provider for OLE DB" will appear in the Data Link Properties. Unfortunately, none of the steps above worked and now I am clueless how to solve this, so I really need help. I will really appreciate any advice or hint or a solution for my problem.


Tags:
Former Member
replied

From the 7.2 Installation document:

Oracle client

The Oracle client must be installed and correctly configured on all servers connecting to the

Identity Center database. The client software is part of the Oracle database installation package.

Note:

If you are using Oracle as your database system, make sure to install the 32-bit version of the

Oracle client if you run a 32-bit Java Virtual Machine on Microsoft Windows. This will be the

case on the server running the Identity Center Management Console.

Oracle 11

For Oracle 11, the 32-bit client must be downloaded separately.

If you install the 32-bit and 64-bit client on the same server, remove the 32-bit client from

PATH.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question