局域网中远程连接oracle时提示拒绝连接.docVIP

局域网中远程连接oracle时提示拒绝连接 我们在局域网中远程连接oracle时，突然一直提示拒绝连接，在确定防火墙关闭，而oracle服务器监听端口开启的情况下，有可能是因为oracle的监听IP地址不是预设的那样，而是本地的。下面就让我们来看一下解决方法吧。 排错过程不再细说，这里只分享由于主机名不正确而导致oracle拒绝连接的解决办法。 一、修改hosts文件 打开cmd，输入hostname，记下主机名 用记事本打开c:windowssystem32driversetchosts 文件，添加主机名。 # Copyright (c) 1993-2016 Microsoft Corp. # This is a sample HOSTS file used by Microsoft TCP/IP for Windows. # This file contains the mappings of IP addresses to host names. Each # entry should be kept on an individual line. The IP address should # be placed in the first column followed by the corresponding host name. # The IP address and the host name should be separated by at least one # space. # # Additionally, comments (such as these) may be ed on individual # lines or following the machine name denoted by a # symbol. # For example: # # source server # # x client host # localhost name resolution is handled within DNS itself. # localhost # ::1 localhost 二、修改oracle监听文件 1、打开 文件在F:_1NETWORKADMIN 目录下，将里面的localhost换为自己的主机名。 # Network Configuration File: F:_ # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = F:_1) (PROGRAM = extproc) (ENVS = EXTPROC_DLLS=ONLY:F:_1) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = Young-PC)(PORT = 1521))//Young-PC原为localhost ) ) ADR_BASE_LISTENER = F:appyoung 2、修改 目录同上，也将localhost更改为主机名。 # Network Configuration File: F:_1etworkadmin # Generated by Oracle configuration tools. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = Young-PC)(PORT = 1521))//Young-PC原为localhost ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (S