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
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.