0 Modifying port number methods
Command Window (Cmd.exe): Run sqlplus/nolog, then conn/as sysdba, then exec dbms_xdb.sethttpport (1521)
1 Modifying the connection properties of a service ORCL
Administrators run database configuration Assistant, configure database options, select instance ORCL, connect mode to Shared server mode
"Private Server Mode" after re-opening
2 modifying Tnsnames.ora
All localhost changed to dell-pc. (DELL-PC is host name)
3 Modify Listner.ora (cause: When Java connects to a database, localhost and 127.0.0.1 can connect, but dell-pc and 223.3.75.198 are not connected)
Added in std_list_listener 's std_list :
(Sid_desc =
(Sid_name = ORCL)
(Oracle_home = E:\app\ora\product\12.1.0\dbhome_2)
(Envs = "Extproc_dlls=only:e:\app\ora\product\12.1.0\dbhome_2\bin\oraclr12.dll")
)
Results Java still cannot connect via 223.3.75.198 (native IP)
4 Configuring Oracle Net Manager
Listener under the address 1, the host changed to dell-pc
The address of the ORCL under the service naming is changed to dell-pc(the system changes automatically when the Tnsnames.ora is changed?). )
After restarting listener, Java can be connected via 223.3.75.198!!!
Note: The above operation has modified the configuration file to restart the database service and monitoring services, in the actual configuration in order to perform the above operations, after 3 is not available for LAN access, but after 4 can be LAN access, so do not know what the actual role of the operation.
Oracle configuration LAN access to Windows OS