下载
- 官网下载地址
- 找到
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_home1TNSListenerOracleServiceORCL
# 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)
)
)
