我的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)
)
)
还需要用到什么大家提出来,请大家一直关注本贴,
谢谢大家帮我解决这个问题:
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)
)
)
remote_login_passwordfile的值是什么?
sqlnet.ora和init.ora的相关设定,对于认证,是组合的,你只给出一部分没办法判断。
如果你认为设定都没有问题,我也没办法。
另外,remote_login_passwordfile的值跟IP有什么关系?
你老师怎么确认的?怀疑中!
ORA-12523: TNS:listener could not find instance appropriate for the client connection
Cause: The listener could not find any available (database) instances, that are appropriate for the client connection.
Action: Run "lsnrctl services" to ensure that the instance(s) are registered with the listener, and have status READY.
你先尝试一下:
1、tnsping INSPUR
我才你要连接INSPUR这个。
看看能不能联通。
2、lsnrctl services
看看数据库监听的状态。
3、执行一下:startup mount
看看是不是数据库处在nomount状态或者未open状态。
注意这两个状态如果是在windows系统中,windows的相关服务也是启动中的状态。
你可以试验一下,即使shutdown数据库,windows的services也是启动中的状态。这一点比较迷惑人。
总之,要不然你的client的tnsname.ora没有设置正确,要不然你的数据库实例没有启动。