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:
- Launch a Command Prompt (CMD) as the user ‘Administrator’
- Type the following command (or go to the folder where your oracle driver is installed)
CD C:\orarun\ora12102\client\BIN
- 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: