The ‘OraOLEDB.Oracle.1’ provider is not registered on the local machine.

by ·0 Comments

Product:

Cognos Controller 10.3

Microsoft Windows 2008 R2 server

Oracle 12c database

Symptom:

Error when you try to check oracle database connection inside Cognos controller configuration on a new Cognos controller installation.

You have entered the values:

Database type: Oracle

Name: default

Provider: OraOLEDB.Oracle.1

User ID:  (the schema name)

Password:  (the password to the schema user in oracle)

Data source: (the oracle SERVICE_NAME)

Error message:

The ‘OraOLEDB.Oracle.1’ provider is not registered on the local machine.

Solution:

  1. Launch a Command Prompt (CMD) as the user ‘Administrator’
  2. Type the following command (or go to the folder where your oracle driver is installed)

CD C:\orarun\ora12102\client\BIN

  1. Type the following commend:

c:\Windows\system32\regsvr32.exe OraOLEDB12.dll

 

C:\orarun\ora12102\Client\BIN>dir oraole*.*

Volume in drive C is SYSTEM

Volume Serial Number is FC7D-6E96

 

Directory of C:\orarun\ora12102\Client\BIN

 

2014-07-31  21:40           744 448 OraOLEDB12.dll

2014-07-31  21:38             1 712 OraOLEDB12.tlb

2014-07-31  21:34             9 728 OraOLEDB12d.dll

2014-07-31  21:33             9 728 OraOLEDB12e.dll

2014-07-31  21:33             9 728 OraOLEDB12f.dll

2014-07-31  21:33             9 728 OraOLEDB12i.dll

2014-07-31  21:34             9 216 OraOLEDB12ja.dll

2014-07-31  21:33             9 216 OraOLEDB12ko.dll

2014-07-31  21:33             9 728 OraOLEDB12ptb.dll

2014-07-31  21:38             9 728 OraOLEDB12us.dll

2014-07-31  21:33             9 216 OraOLEDB12zhs.dll

2014-07-31  21:34             9 216 OraOLEDB12zht.dll

2014-07-31  21:38           139 776 OraOLEDBgmr12.dll

2014-07-31  21:38            15 360 OraOLEDBpus12.dll

2014-07-31  21:34            11 776 OraOLEDBrfc12.dll

2014-07-31  21:33             9 728 OraOLEDBrmc12.dll

2014-07-31  21:38           177 664 OraOLEDBrst12.dll

2014-07-31  21:33            19 968 OraOLEDButl12.dll

18 File(s)      1 215 664 bytes

0 Dir(s)  59 198 668 800 bytes free

C:\orarun\ora12102\Client\BIN>c:\windows\system32\regsvr32.exe OraOLEDB12.dll

C:\orarun\ora12102\Client\BIN>

Then start the Cognos Controller Configuration and test the connection to database again.

If above does not work, then you need to reinstall the Oracle drivers in a correct manner.

More information:

http://www-01.ibm.com/support/docview.wss?uid=swg21694296