安装完oracle数据库之后运行CMD
出现
监听器是打开了
但是依然报这个错误。
NETWORK\ADMIN文件夹中的
listener内容为：
#listener.oraNetworkConfigurationFile:F:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = zhangchen.HIGREEN.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
------------------------
sqlnet的内容为
# 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.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
------解决方案--------------------
晕，那你没有装实例或安装未成功呀
这个是实例的服务名称，你连sqlplus可以不启动OracleOraDb10g_home1TNSListener，但你的实例服务必须启动的