Oracleclient+plsql developer Implement remote login to Oracle Database

Oracle databases are powerful, performance-rich, and, at the same time they are created, Oracle accounts for more memory. In response to this question, how do we take its essence to its dross?

Workaround: We are able to install a large Oracle database on the server on the LAN, install OracleClient on the developer's PC, and telnet to the Oracle database via OracleClient.

Operation Steps:

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

2. Install Plsql Developer;

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

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 of 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;

7. Run the select Userenv (' language ') from dual in Plsql developer, add the system environment variable named Nls_lang, and the value is the run result of the above command.

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

I hope my commentary will be of help to you.

Oracleclient+plsql developer Implement remote login to Oracle Database