环境：Microsoft .NET框架版本：4.0.30319; ASP.NET版本：4.6.1586.0 后端：Oracle 9 i 工具：Visual Studio 2012，ODAC 11.2版本 当我通过Visual Studio 2012调试时，应用程序工作正常，所有CRUD操作都工作完美。
C:\oracle\instantclient_12_2>.\sqlplus.exe scott/tiger@oracle11
SQL*Plus: Release 12.2.0.1.0 Production on Mon Feb 18 07:31:38 2019
Copyright (c) 1982, 2017, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
SQL> select * from dept@oracle9;
DEPTNO DNAME LOC
---------- -------------- -------------
12 RESEARCH SARATOGA
10 ACCOUNTING CLEVELAND
11 ART SALEM
13 FINANCE BOSTON
21 SALES PHILA.
22 SALES ROCHESTER
42 INT'L SAN FRAN
7 rows selected.
Oracle客户端11.2.0.4可以连接到Oracle关系数据库管理系统9.2.0.8。
C:\oracle\instantclient_11_2>.\sqlplus.exe scott/tiger@oracle9
SQL*Plus: Release 11.2.0.4.0 Production on Mon Feb 18 07:37:22 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL>
Oracle客户端12.2.0.1无法连接到Oracle RDBMS 9.2.0.8。
C:\oracle\instantclient_12_2>.\sqlplus.exe scott/tiger@oracle9
SQL*Plus: Release 12.2.0.1.0 Production on Mon Feb 18 07:36:45 2019
Copyright (c) 1982, 2017, Oracle. All rights reserved.
ERROR:
ORA-03134: Connections to this server version are no longer supported.
1条答案
按热度按时间1wnzp6jl1#
您可以使用网关DB版本11.2访问旧数据库9.2.0.8。从网关DB版本11.2为旧数据库9.2.0.8创建数据库链接。
Oracle客户端11.2.0.4可以连接到Oracle关系数据库管理系统9.2.0.8。
Oracle客户端12.2.0.1无法连接到Oracle RDBMS 9.2.0.8。