The Network Adapter could not establish the connection解決

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目录)