Client connects to Oracle database on remote server

In fact, in an intranet, it is very simple to want to remotely connect to the Oracle database on server A at client B.

1, first download the Oracle database client and Plsql software and install in B;

2. Modify the Tnsnames.ora file under the installation directory of the Oracle database client (for example, D:\Instant client\network\admin). Change 1 to the server's IP address, and 2, 3 to the database name in server Oracle.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/87/48/wKioL1fau2uASD3DAACK-r0A4g0109.png "title=" ' ( 9qmjoio9{gq$ $NLON (~bo.png "alt=" Wkiol1fau2uasd3daack-r0a4g0109.png "/>

3, open Plsql software, enter the user name and password, and select the database name, click on the link, the realization of the remote connection server function.

Note: If "TNS: Connection Timeout" is displayed, first check that the firewall on the server is down. Also make sure that the Oracle listener on the server is turned on.

Client connects to Oracle database on remote server