Can PLSQL connect to the server remotely? I want to install the client. I remember what SQL deveplore or other tools I used before. I don't need to install the client, and it comes from the green software. I just thought, I must do it, 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.
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 (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: \ your lient, 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 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.