Using PL/SQL to connect to an Oracle database, whether local or remote, you typically need to install the Oracle client How do I do not install the Oracle client and use the PL/SQL tools? 1. Oracle website provides instantclient, download Instantclient-basic package, unpack the package to a local directory, the package provides a remote connection tool for the database, etc.: http://www.oracle.com/ TECHNETWORK/DATABASE/FEATURES/INSTANT-CLIENT/INDEX-097480.HTML2, Plsql login, click Cancel, go to the login interface, click Tools-- Preferences configure the extracted instantclient directory, such as: , Oracle home configuration: D:\softPackge\developSoft\softPackge\plsql\ ORACLECONNECTIONTOOL\INSTANTCLIENT-BASIC-WINDOWS.X64-12.2.0.1.0\INSTANTCLIENT_12_2OCI Library Configuration: D:\softPackge\ Developsoft\softpackge\plsql\oracleconnectiontool\instantclient-basic-windows.x64-12.2.0.1.0\instantclient_12_ 2\OCI.DLL 3, remote connection database without configuration, you can enter the login window directly into the user name, password, remote address, 8 remote address namely: IP: Port/instance name, such as: 192.168.0.113:1521/orcl 4, Plsql cracked See Plsql installation, through the registration machine to generate registration code, register Machine network address: https://pan.baidu.com/s/1nvOisMP 5, problem: Plsql connect remote database After query out of data garbled? (1) First through the SQL query database code: SELECT * from V$nls_parameters; View the first line: Nls_language property value to see if it is GBK or UTF-8 set environment variable. (2) Set the environment variable nls_lang=simplified Chinese_china. Zhs16gbklang=zh_cn. Gbk--instantclient Extract Directory Tns_admin=d: \softpackge\developsoft\softpackge\plsql\oracleconnectiontool\instantclient-basic-windows.x64-12.2.0.1.0\ instantclient_12_2 then restart the plsql, if not the best is to restart the computer can be effective
Plsql This machine does not install a database connection to a remote database