oracle的报TNS错,connect / as sysdba 报TNS错误是那里配置问题？？

TNSNAMES.ORA配置如下：

# TNSNAMES.ORA Network Configuration File: F:\oracle\ora92\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST = 192.168.1.3

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

ora9 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS=        (PROTOCOL=tcp)        (HOST=192.168.1.3)(PORT=(1521))

)

(CONNECT_DATA =

(SID =ora9)

)

)

LISTENER.ORA配置如下：

# LISTENER.ORA Network Configuration File: F:\oracle\ora92\network\admin\listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))

)

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = ora9)

(ORACLE_HOME = F:\oracle\ora92)

(PROGRAM = extproc)

)

)

执行报错如下：

F:\oracle\ora92\dbs>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 3月 13 07:51:47 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> connect / as sysdba

ERROR:

ORA-12560: TNS: 协议适配器错误

采用TNSPING工具验证情况如下：

C:\Documents and Settings\ljyhn1>tnsping 192.168.1.3

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 13-3月 -2

004 07:56:32

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

已使用的参数文件:

F:\oracle\ora92\network\admin\sqlnet.ora

已使用 HOSTNAME 适配器来解析别名

Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SID=*)(SERVICE_NAME=192.168.1.

3))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.3)(PORT=1521)))

OK(80毫秒)

还请指点一下！！