Oracle can be remotely connected using PLSQL without installing a client)

Source: Internet
Author: User
Tags what sql
Oracle can remotely connect to pl SQL remotely without installing a client.
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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.