Oracle LISTENER host name modified to IP address LISTENER Unable to monitor instance Oracle Listener error and Hosts file configuration

Oracle 11g Disconnect Network installation, there is no detection net function, so after installation, Netstat-an found that automatic monitoring is 127.0.0.1:1521, so that after the installation, the other host can not connect, what is the reason.

After the error is found, is the host name of the problem:

1 in cmd, enter hostname to discover host name

2 in folder: C:\windows\system32\drivers\etc Modify Hosts file:

The source file is:

# Copyright (c) 1993-2009 Microsoft Corp.
# This is
a sample HOSTS file used by Microsoft TCP/IP for Windows.
# This
file contains the mappings's IP addresses to host names. Each
# entry should is kept on a individual line. The IP address should # is placed in the ' in the ' the ' the ' the ' the '
corresponding host name followed by.
# The IP address and the host name should is separated by at least one
#.
#
Additionally, comments (such as) may is inserted on individual
# lines or following the machine name de Noted 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
..... Add host IP       host name here

Join on the last line

Native IP host Name

Save to use Lsnrctl stat to view the listening status at this time listening to or 127.0.0.1:1521 this IP modify listening file Listener.ora file in D:\app\Administrator\product\11.2.0\dbhom E_1\network\admin directory, the comment part of the host name is the original localhost

# Listener.ora Network Configuration File:d:\app\administrator\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 = D:\app\ Administrator\product\11.2.0\dbhome_1)
      (program = extproc)
      (Envs = "Extproc_dlls=only:d:\app\administrator \product\11.2.0\dbhome_1\bin\oraclr11.dll ")
    )
 
LISTENER =
  (description_list =
    ( DESCRIPTION =
      (address = (PROTOCOL = IPC) (KEY = EXTPROC1521))
      (address = (PROTOCOL = TCP) (HOST = win-asa0gb1av61 ) (PORT = 1521))//win-asa0gb1av61 originally localhost))
Adr_base_listener = D:\app\Administrator

Replace the localhost with your own hostname and modify the host name file Tnsnames.ora

# Tnsnames.ora Network Configuration File:d:\app\administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
 
LISTENER_ORCL =
  (address = (PROTOCOL = TCP) (HOST = win-asa0gb1av61) (PORT = 1521))//win ... The original is localhost
 
 
oraclr_connection_data =
  (DESCRIPTION = (
    address_list =
      (address = (PROTOCOL = IPC) (KEY = EXTPROC1521))
    )
    (Connect_data =
      (SID = clrextproc)
      (presentation = RO)
    )
 
ORCL =
  (DESCRIPTION =
    (address = (PROTOCOL = TCP) (HOST = win-asa0gb1av61) (PORT = 1521))//win ... Originally localhost
    (connect_data =
      (SERVER = dedicated)
      (service_name = ORCL
  ))

Also replace the localhost with their own host name and Lsnrctl.ora detection, found that the listening IP address into: 192.168.1.251:1521 0.0.0.0 (192.168.1.251 for this host IP) success.