在oracle服務(wù)器上：

C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN目錄

文件：listener.ora（10.144.118.12是oracle服務(wù)器地址）

# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
? (SID_LIST =
??? (SID_DESC =
????? (SID_NAME = CLRExtProc)
????? (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
????? (PROGRAM = extproc)
????? (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
????)(SID_DESC =?
????? (GLOBAL_DBNAME = ORCL)?
????? (ORACLE_HOME =? C:\app\Administrator\product\11.2.0\dbhome_1)?
????? (SID_NAME = ORCL)?
?? )?
? )

LISTENER =
? (DESCRIPTION_LIST =
??? (DESCRIPTION =
????? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
????? (ADDRESS = (PROTOCOL = TCP)(HOST =?10.144.118.12)(PORT = 1521))
??? )
? )

ADR_BASE_LISTENER = C:\app\Administrator

?

文件：tnsnames.ora

# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
? (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
??? )
??? (CONNECT_DATA =
????? (SID = CLRExtProc)
????? (PRESENTATION = RO)
??? )
? )

ORCL =
? (DESCRIPTION =
??? (ADDRESS = (PROTOCOL = TCP)(HOST =?10.144.118.12)(PORT = 1521))
??? (CONNECT_DATA =
????? (SERVER = DEDICATED)
????? (SERVICE_NAME = orcl)
??? )
? )

?

配好后重啟服務(wù)：

客戶端需要安裝oracle client 和 toad軟件，登錄界面

?

?

轉(zhuǎn)載于:https://www.cnblogs.com/ShaYeBlog/p/6526494.html

總結(jié)

以上是生活随笔為你收集整理的配置toad远程连接oracle的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。