You can use plsql to connect to a remote oracle database without installing the oracle client.

Without installing the oracle client, you can also use plsql to connect to a remote oracle database. Every time you ask someone, can plsql directly connect to the server? They all say they want to install the client, I remember what kind of SQL deveplore or tool I used before. I don't need to install the client, and it comes from the green software. I just thought, there is a way to install the client without such trouble. I searched for it online. Next I will record the detailed process of my practice. I hope it will be helpful to you. If anything is wrong, please comment on it and point it out. Www.2cto.com 1. Search for the following files on the machine where the ORACLE server is installed: oci. dll ocijdbc10.dll ociw32.dll orannzsbb10.dll oraocci10.dll oraociei10.dll sqlnet. ora tnsnames. ora classes12.jar ojdbc14.jar is placed in a folder, such as expose lient 2. Configure tnsnames. ora. If oracle is not installed on the local machine, copy one (tnsnames. the ora file is under % ORACLE_HOME %/network/admin) in the Directory D:/clientlient above. Oracledata = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.58) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME = oracledata ))) www.2cto.com 3. Add an environment variable named TNS_ADMIN with the value tnsnames. the path of the ora file (for example, D:/oraclient, especially after reinstallation or other operations, if you forget the TNS_ADMIN variable, the connection identifier cannot be parsed when you log on to plsql ), this is to find the tnsnames mentioned above. ora. If ORACLE is installed on the local machine and the ORACLE_HOME environment variable is set, the tnsnames. ora file is automatically located in % ORACLE_HOME %/network/admin. 4. Set the ORACLE language and add the environment variable "NLS_LANG = SIMPLIFIEDCHINESE_CHINA.ZHS16GBK". (AMERICAN_AMERICA.US7ASCII is of the ASCII encoding type. For other types, go to the server and check it online)