64bit windows 上连接本机32bit Oracle系统报ORA-12154

最新推荐文章于 2022-07-28 11:02:56 发布

转载最新推荐文章于 2022-07-28 11:02:56 发布 · 131 阅读

收录于

当使用32位Oracle客户端在64位Windows操作系统上进行连接时遇到ORA-12154或ORA-6413错误时，可能是因为Cognos应用程序安装路径包含括号。此问题是Oracle产品已知的bug#3807408。解决办法包括应用特定版本的补丁，或者重新定位应用程序到不包含括号的路径。

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.