instantclient-basic-windows.x64-11.2.0.4.0.zip(含 OCI、SQL*Plus、ODBC)。C:\instantclient_11_2。| 變數 | 值 |
|---|---|
| ORACLE_HOME | C:\instantclient_11_2 |
| TNS_ADMIN | C:\instantclient_11_2 |
| PATH | 在 Path 末尾追加 ;C:\instantclient_11_2 |
在 C:\instantclient_11_2 新建 tnsnames.ora:
MYDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.250)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MYDB)
)
)
MYDB:連線別名(自訂)。HOST/PORT/SERVICE_NAME:目標資料庫實際值。C:\instantclient_11_2> sqlplus user/pwd@MYDB -- 或 PL/SQL Developer / TOAD 直接選擇 Instant Client 模式,指定 ORACLE_HOME 即可。