Windows Server 安装 Oracle11g 配置远程连接

下载

• 官网下载地址
• 找到 Oracle Database 11g Release 2
• 下载 11.2.0.1.0 对应的 windows 版本

安装

• 参考安装教程

配置远程链接

监听配置路径：C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
需要在 LISTENER 下新增一个本机IP的监听，然后重新实例和监听的服务：

• 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

客户端连接远程数据库

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

• Oracle SQL Developer 无需单独下载客户端
• Navicat Premium 自带的instantclient_11_2精简版不一定能用，需要换成instantclient_12_2并配置tns
• PLSQL Developer 需要下载客户端并配置tns instantclient_12_2，首选项中配置客户端和oci.dll路径

客户端tns配置说明
创建文件：instantclient_12_2\NETWORK\ADMIN\tnsnames.ora
HOST = Oracle服务器IP地址

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