-
访问局域网Oracle 数据库 解决在不能上网的情况下面局域网内无法访问oracle数据库
记住设置完之后要重启电脑,而且设置完之后,如果在没有因特网的情况下面数据库访问很慢
因为oracle服务端访问配置是需要配置访问地址监听的,具体见Oracle安装路径:% product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora这个是我的oracle监听服务的配置文件,内容为# listener.ora Network Configuration File: E:\app\rcfeng\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 = E:\app\rcfeng\product\11.2.0\dbhome_1)(PROGRAM = extproc)(ENVS = "EXTPROC_DLLS=ONLY:E:\app\rcfeng\product\11.2.0\dbhome_1\bin\oraclr11.dll")))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))))ADR_BASE_LISTENER = E:\app\rcfeng其中(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))是指监听的地址;由于本机的服务端一般都是自己做测试的时候访问 ;而为什么我们写localhost:1521 的时候可以访问到,就是因为(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))这一句,我们监听了localhost,所以可以访问到..如果需要被局域网访问的话,我们只需要加入监听访问地址就可以了,如:(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.120)(PORT = 1521))这样局域网的机子就可以访问我们的oracle服务了..完整内容为:LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.120)(PORT = 1521))))
oracle11局域网访问 连接失败
最新推荐文章于 2023-03-16 14:43:56 发布