進入系統屬性頁面

rundll32.exe shell32.dll,Control_RunDLL sysdm.cpl,,3

并添加系統環境變量?

ORACLE_HOME = ${path} TNS_ADMIND = ${path}\network\admin NLS_LANG = AMERICAN_AMERICA.ZHS16GBK

其中${path} = 從http://www.oracle.com/technetwork/topics/winx64soft-089540.html?下載的 instantclient-basic-windows.x64-12.2.0.1.0.zip 解壓目錄.

將${path}值追加進系統環境變量Path值，并在${path}下創建子目錄\network\admin 并創建 tnsnames.ora 文件

注意：目標數據庫需要創建監聽并開啟服務. 狀態查詢 參考命令 lsnrctl status

ora文件參考

# tnsnames.ora Network Configuration File: ${path}\network\admin\tnsnames.ora # Generated by Oracle configuration tools.#LISTENER_ORCL = # (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.148)(PORT = 1521))# #ORACLR_CONNECTION_DATA = # (DESCRIPTION = # (ADDRESS_LIST = # (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) # ) # (CONNECT_DATA = # (SID = CLRExtProc) # (PRESENTATION = RO) # ) # )ORCL =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.18.148)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl))) View Code

?

轉載于:https://www.cnblogs.com/wjshan0808/p/7929417.html

總結

以上是生活随笔為你收集整理的ORA-12154: TNS:could not resolve the connect identifier specified. Solved.的全部內容，希望文章能夠幫你解決所遇到的問題。

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