[Q]: Oracle8.0.5 connect to Oracle9i. How to

显示全部楼层 · 2005-10-30 17:05:33

[Q]: Oracle8.0.5 connect to Oracle9i
为什么我不能用客户端 Oracle8.0.5(or Oracle8.0.6) 连接到Oracle9i?
(error message ORA-12203: TNS:unable to connect to destination)
而用客户端Oracle8.1.7用与前者(8.0)相同的配置却可以连接到Oracle9i?
我应如何用客户端 Oracle8.0.5(or Oracle8.0.6) 连接到Oracle9i?
Can you tell me?
--------------------------------------------------------------
以下是Oracle9i database info.
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
--------------------------------------------------------------
以下是Oracle8.0.5 SQLNET.ORA 文件内容
AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
names.directory_path = (TNSNAMES)
names.default_domain = world
name.default_zone = world
names.default_domain=world
以下是Oracle8.0.5 tnsnames.ora 文件内容
TST_9i.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =

(PROTOCOL = TCP)

(Host = 172.21.0.1)

(Port = 1521)
)
)
(CONNECT_DATA = (SID = orcl9i)
)
)
--------------------------------------------------------------
以下是Oracle8.1.7 SQLNET.ORA 文件内容
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES)
Oracle8.1.7 的 tnsnames.ora 与 Oracle8.0.5 的相同