1、win + r,输入cmd进入界面。
2、输入命令tnsping orcl
3、报错 TNS-03505:无法解析名称
4、查看D:\software\WINDOWS.X64_193000_db_home\network\admin\sqlnet.ora配置信息,修改成如下:
# 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)
NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME)
5、查看D:\software\WINDOWS.X64_193000_db_home\network\admin\tnsnames.ora,修改成如下
# tnsnames.ora Network Configuration File: #D:\software\WINDOWS.X64_193000_db_home\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
6、输入命令tnsping orcl,报错TNS-12541: TNS: 无监听程序
7、开始菜单点击Net Configuration Assistant,添加监听程序,如果报不能创建监听程序,把D:\software\WINDOWS.X64_193000_db_home\NETWORK\ADMIN\listener.ora删掉,再次添加会重新生成这个文件
8、tnsping orcl,ok
----D:\software\WINDOWS.X64_193000_db_home(Oracle_Home目录)
如果觉得《The Network Adapter could not establish the connection解決》对你有帮助,请点赞、收藏,并留下你的观点哦!