1. Configuring Monitoring
Listener.ora
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = Clrextproc)
(Oracle_home = ORACLE path \product\11.2.0\dbhome_1)
(program = Extproc)
(Envs = "extproc_dlls=only:oracle path \product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
(Sid_desc =
(Global_dbname = ORCL)
(oracle_home =oracle path \product\11.2.0\dbhome_1)
(Sid_name = ORCL)
)
)
LISTENER =
(Description_list =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
(DESCRIPTION =
(address = (PROTOCOL = TCP) (HOST = IP address) (PORT = 1521))
)
)
The red part is the new Plus section, and then the Oracle listener is restarted
For security reasons, you can turn on the firewall, open ports/programs (primarily FTP) to the specified IP access. View Local Computer extranet IP (Baidu search ' IP ')
Oracle Extranet Access