我的Oracle服务器都是启动的,没问题,可是我用客户机联接时提示:
TNS:监听程序未找到适用于客户机连接的例程
为方便大家分析,一下是几个可能用到的文件信息,
还需要用到什么大家提出来,请大家一直关注本贴,
谢谢大家帮我解决这个问题:
listener.ora:
LISTENER =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = EA203015)(PORT = 1521)))
sqlnet.ora:
# SQLNET.ORA Network Configuration File: C:\oracle1\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)
tnsnames.ora:
# TNSNAMES.ORA Network Configuration File: C:\oracle1\ora92\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
INSPUR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = EA203015)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = inspur)
)
)
INSPUR_LOCALHOST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = inspur)
)
)