編輯連接配置文件 tnsnames.ora,該文件需要自行在即時客戶端目錄(C:\instantclient_11_2)中創建。在該文件內輸入如下內容:
MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.250)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB)
)
)
MYDB:是數據庫實例名
192.168.3.259:是數據庫的 IP 地址
1521:是數據庫的端口