使用 Oracle11g 客户端连接到 Oracle19C 服务器

人气:885 发布:2022-10-16 标签: oracle oracle11g oracle12c ora-01017 oracle19c

问题描述

全部

我正在尝试连接到 Oracle 19C 数据库.我安装了两个 Oracle 客户端(11g 和 12c),因为我们需要支持旧程序.我可以通过 12c 客户端与使用 sqlplus 的任何用户毫无问题地连接.但是如果我对任何用户使用 11g (11.2.0) 客户端.我总是得到:

错误:ORA-01017: 无效的用户名/密码;登录被拒绝

两个客户端都有完全相同的 sqlnet.ora 和 tnsnames.ora 文件,所以两个客户端都指向同一个数据库.

有什么想法吗?我需要在 19c 服务器中设置一些特定的配置吗?还是我需要在 11g 客户端中进行一些更改?这甚至可能吗?

谢谢.

解决方案

看看

#9 - 仅限 11.2.0.3 或 11.2.0.4.对于 Oracle Autonomous Transaction Processing 和 Oracle Autonomous Data Warehouse,有额外的限制,11.2.0.4 是支持的最低客户端版本.

通常安装多个 Oracle 客户端是个坏主意(即 32 位和 64 位各一个).

对于某些组件,例如Oracle OleDB 提供程序"甚至不可能安装多个版本(同样,32 位和 64 位各一个).这是旧的 Windows COM 架构的限制.

对于其他组件,它可能有效,但是您需要相应地设置 %PATH% 环境变量,使其指向安装当前所需版本的正确文件夹.

all

I'm trying to connect to an Oracle 19C database. I have installed two Oracle Clients (11g and 12c) because we need to support legacy programs. I can connect with no issue with any user using sqlplus through the 12c client. But if I use the 11g (11.2.0) client with any user. I always get:

ERROR:
ORA-01017: invalid username/password; logon denied

Both clients have exactly the same sqlnet.ora and tnsnames.ora files, so both clients point to the same database.

Any idea? Do I need to set some specific configuration in the 19c server? Or do I need to make some change in the 11g client? Is this even possible?

Thank you.

解决方案

Have a look at Client / Server Interoperability Support Matrix for Different Oracle Versions (Doc ID 207303.1)

#9 - 11.2.0.3 or 11.2.0.4 only. For Oracle Autonomous Transaction Processing and Oracle Autonomous Data Warehouse, there is additional limitation and 11.2.0.4 is the minimum supported client version.

Usually it is a bad idea to install more than one Oracle client (i.e. one each for 32-bit and 64-bit).

For some components, e.g. "Oracle OleDB Provider" it is even not possible to have more than just one version (again, one each for 32-bit and 64-bit) installed. This is a limitation of the old Windows COM architecture.

For other components it may work, however you need to set your %PATH% environment variable accordingly that it points to the correct folder where currently desired version is installed.

663