"Oracle provider for OLE DB" missing in the Data Link Properties
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 :
- Oracle database software installed - Oracle 11g R2 Database 64x
- JRE v6 update 34 - 64x
- Oracle client - Oracle 11g R2 Client 64x
- Environmental variables:
- CLASSPATH to the jdbc driver in the oracle client folder : ojdbc6.jar
- I have changed the Java options in the Identity Center Management Console to the java and jdbc driver specified above
- 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.
Matt Pollicove replied
From the 7.2 Installation document:
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.
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.
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