下載

• 官網(wǎng)下載地址
• 找到 Oracle Database 11g Release 2
• 下載 11.2.0.1.0 對(duì)應(yīng)的 windows 版本

安裝

• 參考安裝教程

配置遠(yuǎn)程鏈接

補(bǔ)充說(shuō)明，好像可以把 HOST = 這里的地址留空即可支持本機(jī)和遠(yuǎn)程客戶端使用TNS方式連接了。

(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))

監(jiān)聽(tīng)配置路徑：C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
需要在 LISTENER 下新增一個(gè)本機(jī)IP的監(jiān)聽(tīng)，然后重啟監(jiān)聽(tīng)和實(shí)例的服務(wù)：

• OracleOraDb11g_home1TNSListener
• OracleServiceORCL

# 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")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.150)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\app\Administrator

客戶端連接遠(yuǎn)程數(shù)據(jù)庫(kù)

客戶端下載地址：https://www.oracle.com/database/technologies/instant-client/downloads.html

• Oracle SQL Developer 無(wú)需單獨(dú)下載客戶端
• Navicat Premium 自帶的instantclient_11_2精簡(jiǎn)版不一定能用，需要換成instantclient_12_2并配置tns
• PLSQL Developer 需要下載客戶端并配置tns instantclient_12_2，首選項(xiàng)中配置客戶端和oci.dll路徑

客戶端tns配置說(shuō)明
創(chuàng)建文件：instantclient_12_2\NETWORK\ADMIN\tnsnames.ora
HOST = Oracle服務(wù)器IP地址

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