How to connect a client from one machine to another Server 1. Open cmd and enter netca. 2. Select Local net service name configuration → next. 3. Select Add> next. 4. enter the name of the oracle service on the server you want to connect to in [service name] → next step. 5. select tcp> next. 6. Enter the ip address of the server you want to connect to in host name. The port number remains unchanged → next step. 7. Select "test"> "Next. (You can also choose not to test) ※1 if the test fails, click Change logon and enter a user name and password that will certainly be logged on. → OK, [connecting... the test is successful.] The test is successful. ※2 if the test fails, click [previous] to confirm the [service name] and [host name] you wrote, make sure that the oracle listening service on the server you want to connect to is enabled. 8. Enter the local service name you want to use in [net service name] → next step. ※Sqlplus user/passwd @ local service name ]. 9. Select "no"> "Next. 10. The word "net service configuration completed" appears → next step. 11. Click Finish to complete the service configuration. 12. After the above service configuration is complete, enter the following command in cmd to remotely log on to the oracle server: sqlplus user_name/password @ the local service name must be remembered, the local service name above is the service name you wrote in step 1.