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.