Solution to local LAN access failure in oracle11

Oracle Database Access to the local area network of oracle11 is not feasible. In the case that the local area network cannot access the oracle database for three times, the entire R & D department is basically unable to do things. Www.2cto.com is unwilling to get up in the morning and go to work. Finally, find a way to remember to restart the computer after the settings are complete, and after the settings are complete, if there is no Internet, the database access will be slow. Now there are two computers A and B; computer A has Oracle11G server; IP address 192.168.1.120; port 1521; computer A is connected to the database normally, you can log on to and perform operations. If The Network Adapter cocould not establish the connection reports this error when computer B configures access to computer A, there is A saying on The Internet that the firewall is not closed, or the server service is not enabled .. according to my actual situation, the access address listening needs to be configured for the oracle server access configuration. For details, see the Oracle installation path: % product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \ listener. ora is the configuration file of my oracle listening service. The content is # listener. ora Network Configuration File: E: \ app \ rcfeng \ 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 = E: \ app \ rcfeng \ product \ 11.2.0 \ dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS = ONLY: E: \ app \ rcfeng \ product \ 11.2.0 \ dbhome_1 \ bin \ lrlr11.dll "))) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521) (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521) ADR_BASE_LISTENER = E: \ app \ rcfeng where (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521) (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521) refers to the address of the listener. Because the server of the local machine is generally accessed during the test, why do we write localhost: 1521 can be accessed, because (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521), we listened to localhost, so you can access .. to be accessed by a LAN, you only need to add the listening access ADDRESS, for example: (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.120) (PORT = 1521 )) in this way, the local computer can access our oracle service .. complete content: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521) (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.120) (PORT = 1521 ))))