Oracle remote logon Solution

Oracle remote logon solution: Oracle remote Logon: in cmd: sqlplus scott/tiger @ oracle // there is no space between tiger and @ (and no space is allowed ), the name of the remote connection service added by oracle in netca is in cmd: sqlplus/nolog SQL> conn scott/tiger@192.168.0.101/orcl // orcl for normal installation of the service name on the server, first install oracle10G, and then configure the client, connect to the oracle10g server.
Client configuration method:
1. Open cmd and enter netca. 2. Select Local net service name configuration → next. 3. Select Add> next. Www.2cto.com 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. Www.2cto.com 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 @ local service name // remember to remember, the local service name above is the service name you wrote in step 1. Author ljasdf123