WindowsServer安装Oracle11g 11.2.0.1.0 对应的 windows 版本配置远程连接
下载安装这里不详述具体安装步骤了，具体操作可参考安装教程 ： Oracle 11g数据库详细安装步骤图解，
配置远程链接
监听配置路径：D:\Soft\oracle11g\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
需要在LISTENER下新增⼀个本机IP的监听，然后重启监听和实例的服务：
LISTENER
OracleOraDb11g_home1TNSListener
OracleServiceORCL
listener.ora Network Configuration File: D:\Soft\oracle11g\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 = D:\Soft\oracle11g\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\Soft\oracle11g\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.10)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\Soft\oracle11g
或者 （补充说明：好像可以把 HOST = 这⾥的地址留空即可⽀持本机和远程客户端使⽤TNS⽅式连接了 (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))，如下
LISTENER
OracleOraDb11g_home1TNSListener
OracleServiceORCL
listener.ora Network Configuration File: D:\Soft\oracle11g\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 = D:\Soft\oracle11g\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\Soft\oracle11g\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\Soft\oracle11g
上述配置完以后，需要重启监听和实例的服务，这样同一局域网的其他客户端就可以连接远程数据库
原文链接：https://wenku.baidu.com/view/b8503ca36629647d27284b73f242336c1eb930d4.html
Original: https://www.cnblogs.com/1175429393wljblog/p/16381122.html
Author: 龙骑科技
Title: Oracle授权允许远程访问–Oracle配置允许远程连接
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/551086/
转载文章受原作者版权保护。转载请注明原作者出处！