本篇文章给大家分享的是有关Oracle中怎么修改监听IP地址，小编觉得挺实用的，因此分享给大家学习，希望大家阅读完这篇文章后可以有所收获，话不多说，跟着小编一起来看看吧。
创新互联建站专业为企业提供临潼网站建设、临潼做网站、临潼网站设计、临潼网站制作等企业网站建设、网页设计与制作、临潼企业网站模板建站服务，十年临潼做网站经验，不只是建网站，更提供有价值的思路和整体网络服务。
一、修改hosts文件
打开cmd，输入hostname，记下主机名 用记事本打开c:\windows\system32\drivers\etc\hosts 文件，添加主机名。
# Copyright (c) 1993-2009 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 inserted on individual # lines or following the machine name denoted by a '#' symbol. # For example: # 102.54.94.97 rhino.acme.com # source server # 38.25.63.10 x.acme.com # x client host # localhost name resolution is handled within DNS itself. # 127.0.0.1 localhost # ::1 localhost [主机IP] [主机名]
二、修改oracle监听文件
1、打开listener.ora
文件在F:\app\young\product\11.2.0\dbhome_1\NETWORK\ADMIN 目录下，将里面的localhost换为自己的主机名。
# listener.ora Network Configuration File: F:\app\young\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 = F:\app\young\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:F:\app\young\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = Young-PC)(PORT = 1521))//Young-PC原为localhost ) ) ADR_BASE_LISTENER = F:\app\young
2、修改tnsnames.ora
目录同上，也将localhost更改为主机名。
# tnsnames.ora Network Configuration File: F:\app\young\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # 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 = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Young-PC)(PORT = 1521))//Young-PC原为localhost (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )
3、重启tnslsnr。
打开cmd，输入以下命令。
lsnrctl stop lsnrctl start lsnrctl stat
以上就是Oracle中怎么修改监听IP地址，小编相信有部分知识点可能是我们日常工作会见到或用到的。希望你能通过这篇文章学到更多知识。更多详情敬请关注创新互联行业资讯频道。
当前文章：Oracle中怎么修改监听IP地址
链接URL：
http://bjjierui.cn/article/gehiho.html
