oracle远程连接参数,oracle（Xe）数据库远程连接需修改配置参数

1.找到oracle安装后的目录，然后找到tnsnames.ora文件

修改相关文件内容：

XE =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = XE)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

ORACLR_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = CLRExtProc)

(PRESENTATION = RO)

)

)

将(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT = 1521))修改成本机IP以及端口号，

然后其他电脑可以通过相关的IP端口远程连接到你自己oracle服务器

原文：http://www.cnblogs.com/Iyce/p/3944750.html