Windows Server 安装 Oracle11g 配置远程连接

下载

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

安装

参考安装教程

配置远程链接

补充说明，好像可以把 HOST = 这里的地址留空即可支持本机和远程客户端使用TNS方式连接了。
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))

监听配置路径：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)
    )
  )