tnsping 不通

[chenliangtadu]

问题是这样的 数据库可以连接 sqlplus /nolog conn sys/tadu as sysdba
但是通过 conn sys/tadu@orcl as sysdba 通过翻看解决办法 是network/admin 下的sqlnet.ora listener.ora tan..ora 等问题 改了还是不通 请各位大侠指教 数据库实例 orcl oracle 11g
sqlnet.ora
sqlnet.authentication_services=NTS
names.directory_path=(TNSNAMES) 只修改了这2个
listener.ora
# LISTENER =
# (ADDRESS_LIST=
# (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
# (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

# SID_LIST_<lsnr>
# List of services the listener knows about and can connect
# clients to. There is no default. See the Net8 Administrator's
# Guide for more information.
#
# SID_LIST_LISTENER=
# (SID_LIST=
# (SID_DESC=
# #BEQUEATH CONFIG
# (GLOBAL_DBNAME=salesdb.mycompany)
# (SID_NAME=sid1)
# (ORACLE_HOME=/private/app/oracle/product/8.0.3)
# #PRESPAWN CONFIG
# (PRESPAWN_MAX=20)
# (PRESPAWN_LIST=
# (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))
# )
# )
# )
tan.ora

orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
不知道为什么 帮看看

[Yakecanz]

查看一下你的tnsnames.ora是否配置好，如果配配好了在DOS CONSOLE中运行tnsping orcl

[chenliangtadu]

[Quote=引用 1 楼 的回复:]

查看一下你的tnsnames.ora是否配置好，如果配配好了在DOS CONSOLE中运行tnsping orcl
[/Quote]
配置好了 tnsping orcl 报错 userd parameters file:TNS-03505 failed to resolve name