Oracle Client +PLSQL Developer for remote login to Oracle Database

The Oracle database is powerful and performance-rich, and while creating these benefits, Oracle accounts for more memory. In response to this question, how do we take its essence to its dross?

Solution: We can install a large Oracle database on a server within the LAN, install an Oracle client on the developer's PC, and telnet to the Oracle database via an Oracle client.

Operation Steps:

1. We can download Oracle client software from Oracle website, also can download from Baidu Network disk, the network disk recommends: HTTP://PAN.BAIDU.COM/S/1KTYZDSZ, after downloading completes installs;

2. Install Plsql Developer;

3. Under the installation directory of the Oracle client (my installation path is C:\Program Files (x86) \oracle\odac_client), new File Tnsnames.ora, file contents are as follows:

ORCL =
        (DESCRIPTION =
         (address_list =
          (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.24.248) (PORT = 1521))
            )
          (Connect_data =
          (SERVER = dedicated)
          (service_name = ORCL)
            )
          )

HOST for the IP address of the remote Oracle database, port is the port number for the connection.

4. Add the system environment variable, the variable name is tns_admin, the value is the path of the Tnsnames.ora file;

5. Open the Plsql developer,tool-->prefrence, set the Oracle home for the client installation path (my is C:\Program Files (x86) \ oracle\odac_client), OCI Library is the client installation path +oci.dll (mine is C:\Program Files (x86) \oracle\odac_client\oci.dll);

6. Restart Plsql Developer after configuration is complete;

7. Execute Select Userenv (' language ') from dual in Plsql Developer; command, add system environment variable, variable named Nls_lang, value is the result of the above command.

This allows us to telnet to the Oracle database on the 192.168.24.248 server via the native Plsql developer.

  I hope I can help you with my explanation.