Oracle授权允许远程访问--Oracle配置允许远程连接

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