Oracle can be remotely connected using PLSQL without installing a client Every time I ask people whether PLSQL can connect to the server remotely, they say they want to install the client. Remember what SQL deveplore or other tools have been used before, and there is no need to install the client, in addition, it comes from the green software. I just want to solve this problem, so you don't have to bother installing the client. 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. First, install Oracle Search for the following files on the server machine, OCI. dll Ocijdbc10.dll Ociw32.dll Orannzsbb10.dll Oraocci10.dll Oraociei10.dll (the server may not exist. If not, you can log on to pl SQL with the username and password) Sqlnet. ora Tnsnames. ora Classes12.jar Ojdbc14.jar Put it in a folder, such as your 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) ) ) 3. Add an environment variable named tns_admin with the value tnsnames. the path of the ora file (for example, D: \ release lient, especially after reinstallation or other operations, if you forget the tns_admin variable, PLSQL logs in and reportsThe specified connection identifier cannot be resolved.) To find tnsnames. 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 environment variables: "Nls_lang = simplified chinese_china.zhs16gbk) (This step is currently correct. If the encoding is incorrect, garbled characters will be generated) 5. download and install the Pl. SQL. developer configuration application Configure tools> preferences> connection Oracle Home = D: \ oracleclient OCI library = D: \ oracleclient \ OCI. dll 6. If you enable PLSQL again, you can log on to the database by entering the username and password with the oracledata option. |