Oracle (XE) database remote connection requires modification of configuration parameters

1. Locate the Oracle installation directory, and then locate the Tnsnames.ora file

Modify the relevant file contents:

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.107) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = XE)
)
)

Extproc_connection_data =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))
)
(Connect_data =
(SID = Plsextproc)
(PRESENTATION = RO)
)
)

Oraclr_connection_data =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1))
)
(Connect_data =
(SID = Clrextproc)
(PRESENTATION = RO)
)
)

Modify the cost machine IP and port number (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.107) (port = 1521),

Then other computers can connect remotely to your own Oracle server via the associated IP port

Oracle (XE) database remote connection requires modification of configuration parameters