c+链接oracle+9.2,客户端连接oracle9.2.0.1时总是报错:ORA-12203: TNS：无法与目标连接...

我找了一台PC机(win2000sp5),在上面安装了oracle9i,具体版本是9.2.0.1,操作系统是red linux7.2 核心是2.4.7-10

一,在主机上使用系统一切正常,主机上的信息如下:

[oracle@ccyyss admin]$ echo $ORACLE_BASE

/home1/oracle/OraBase

[oracle@ccyyss admin]$ echo $ORACLE_SID

test

[oracle@ccyyss admin]$ echo $ORACLE_HOME

/home1/oracle/OraHome920

[oracle@ccyyss admin]$ tnsping ora9201

TNS Ping Utility for Linux: Version 9.2.0.1.0 - Production on 19-NOV-2003 13:31:48

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:

/home1/oracle/OraHome920/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ccyyss.paicdom)(PORT = 1523))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora920)))

OK (0 msec)

对应的listener有如下信息:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home1/oracle/OraHome920)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = ora920)

(ORACLE_HOME = /home1/oracle/OraHome920)

(SID_NAME = test)

)

)

对应的tns有如下信息:

ORA9201.PAICDOM =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = ccyyss.paicdom)(PORT = 1523))

#      (ADDRESS = (PROTOCOL = TCP)(HOST = ccyyss)(PORT = 1523))

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = ora920)

)

)

[oracle@ccyyss admin]$ sqlplus system@ora9201        --连接成功

二,客户机器

OCI version8.0

对应的tns有如下信息:

ORA9201.world =

(DESCRIPTION =

(ADDRESS_LIST =

#      (ADDRESS = (PROTOCOL = TCP)(HOST = ccyyss.paicdom)(PORT = 1523))

(ADDRESS = (PROTOCOL = TCP)(HOST = ccyyss)(PORT = 1523))

)

(CONNECT_DATA =

(SERVICE_NAME = ora920)

)

)

命令行上运行:

E:\ORANT\BIN>tnsping80 ora9201

TNS Ping Utility for 32-bit Windows: Version 8.0.5.0.0 - Production on 19-11月-0

3 13:48:51

(c) Copyright 1997 Oracle Corporation.  All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=ccyyss)(PORT=1523))

确定(50 毫秒)

成功!

问题是,使用sqlplus连接时报如下错误:

ORA-12203: TNS：无法与目标连接

请帮忙看看是什么错误,谢谢啊