oracle 11g怎样配置才能连接远程数据库

http://jingyan.baidu.com/article/414eccf645c3b46b431f0ab8.html

客户端配置

打开所有程序->找到oracle-oradb11g-home1->Net Configuration Assistant,

选择本地网络服务名配置，点击下一步

选择添加，点击下一步

填写服务名，点击下一步

选择通信协议：TCP，点击下一步

填写数据库所在的主机名（也可以是IP地址），选择端口号（根据数据库所在的主机的端口号进行选择，一般是标准端口号），点击下一步，选择测试，点击下一步

更改登录名

如图测试成功

服务器端配置 http://www.360doc.com/content/14/1212/10/10529016_432330997.shtml

修改 ORACLE_HOME/network/admin/目录下面的tnsnames.ora和listener.ora文件

1、tnsnames.ora (修改红色的地方即可)

LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.212)(PORT = 1521))

ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )

ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )

SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:oracleproduct11.2.0dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:C:oracleproduct11.2.0dbhome_1inoraclr11.dll") ) )

LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.212)(PORT = 1521)) ) )

ADR_BASE_LISTENER = C:oracle

最后好记住重启监听服务：OracleOraDb11g_home1TNSListener