64bit windows 上連線本機32bit Oracle系統報ORA-12154

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

Windows 64-bit

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.