Problem(Abstract)
ORA-12154 or ORA-6413 error when attempting to connect with 32-bit Oracle client on 64-bit Windows OS
Cause
Cognos application is installed in path that contains parenthesis (e.g. "C:\Program Files (x86)\..." .
This is a known Oracle product issue bug #3807408. Please check http://forums.oracle.com/forums/thread.jspa?messageID=3455198
Environment
Windows 64-bit
Resolving the problem
Solution 1:
Use a version of the Oracle software that contains the fix for Bug 3807408.
NOTE: Currently the following patches have been released on Windows:
Windows 32-bit
9.2.0.7.0 Patch 6: Apply Patch 4928723 or later
10.2.0.1.0 Patch 4: Apply Patch 4923768 or later
10.2.0.2.0 Patch 5: Apply Patch 5383042 or later
10.2.0.3.0: Apply Patch 5337014 or later
Windows 64-bit AMD64 and INTEL EM64T
10.2.0.1.0 Patch 4: Apply Patch 4923787 or later
10.2.0.2.0 Patch 5: Apply Patch 5388871 or later
10.2.0.3.0: Apply Patch 5337014 or later
For all other versions on Windows please use SOLUTION 2 for now.
Solution 2:
Find the location of the application that is generating the error. Check the path to this location and see if it contains any parenthesis. If so, you must relocate the application to a directory without any parenthesis in the path.