1.在oracle客戶端中按照如下路徑找到tnsnames.ora文件,并以文本格式打開
D:\oracle\ora92\network\admin\tnsnames.ora
2.在打開的文本中加入以下內(nèi)容
LSD_192.168.1.32 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(
HOST = 192.168.1.32)(PORT = 1521))
)
(CONNECT_DATA =
(
SID = ora9i)
(SERVER = DEDICATED)
)
)
3.打開oracle客戶端,進(jìn)行連接服務(wù)器的操作
此時(shí)可以發(fā)現(xiàn)在"數(shù)據(jù)庫"選項(xiàng)中多出了"LSD_192.168.1.32"這條記錄,
如果選擇該項(xiàng),就可以連接到ip為192.168.1.32的服務(wù)器上
數(shù)據(jù)庫的SID為 ora9i.