Oracle client +plsqldeveloper enables 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 Oracle Client installation directory (my installation path is C:\Program files (x86) \oracle\odac_client), create a new file Tnsnames.ora with the following file contents:

ORCL = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.24.24 8) (PORT = 1521)) (Connect_data = (SERVER = dedicated) (service_name = ORCL)))

Host is the IP address of the remote Oracle database and 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 Plsql developer,tool-->prefrence, set the Oracle home installation path for the client (my is C:\Program Files (x86) \oracle\odac_client), OCI Library for 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 the system environment variable named Nls_lang, and the value is the execution 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 that my explanation can help you.

Transferred from: http://www.2cto.com/database/201407/315285.html

Oracle client +plsqldeveloper enables remote login to Oracle Database