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解決的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。