A simple listener. ora
# Listener. ora network configuration file: D: \ app \ zyd \ 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 \ zyd \ product \ 11.2.0 \ dbhome_1)
(Program = EXTPROC)
(Envs = "extproc_dlls = only: D: \ app \ zyd \ 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 ))
???? (Address = (Protocol = TCP) (host = 192.168.1.160) (Port = 1666 ))
)
)
?
Adr_base_listener = D: \ app \ zyd
------------------------ End of file ---------------------------
Note that the firewall must allow port 1666.
Listener. ora adds listening ports