Shulou(Shulou.com)05/31 Report--

What this article shares to you is about how to modify the monitoring IP address in Oracle. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

1. Modify hosts file

Open cmd, type hostname, write down the hostname, open the c:\ windows\ system32\ drivers\ etc\ hosts file in notepad, and add the hostname.

# 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 [Host IP] [hostname]

2. Modify the oracle listening file

1. Open listener.ora

The file is in the F:\ app\ young\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN directory, and change the localhost in it to your own hostname.

# 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 was originally localhost)) ADR_BASE_LISTENER = F:\ app\ young

2. Modify tnsnames.ora

The directory is the same as above, and change the host name of localhost as well.

# 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 was originally localhost ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (PROTOCOL = IPC) (KEY = EXTPROC1521) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO)) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)) ) (HOST = Young-PC) (PORT = 1521) / / Young-PC was originally localhost (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)

3. Restart tnslsnr.

Open cmd and enter the following command.

Lsnrctl stop lsnrctl start lsnrctl stat

The above is how to modify the listening IP address in Oracle. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.