PL/SQL Developer accessing the remote database (this computer does not contain Oracle clients)

I. Download PL/SQL Developer

PL/SQL Developer download page, you can choose to download 32-bit or 64-bit, if you need Chinese language interface can also download

Second, download instant Client, which contains access to the database of the OCI and other documents

Instant client Download page, download the Instantclient-basic at the beginning of the package, you need to download the PL/SQL Developer version of the decision on downloading 32-bit or 64-bit

Download and unzip to a directory that does not contain spaces. Example: D:\instantclient_12_1

Ps:instant Client version is too high, the number of bits does not match, or the extract directory contains spaces can trigger an exception

Three, the relevant parameter configuration

1, the previous step of the extracted directory after the new network\admin, and in the bottom of the directory to create a new Tnsnames.ora, file content similar to the bottom:

Database at logon = (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = remote Database IP) (port = ports)) (Connect_da TA = (service_name = database example)))

2, System environment variable configuration, need to restart the system to take effect

Nls_lang====american_america. ZHS16GBK character encoding

Tns_admin====d:\instantclient_12_1\network\admin (the directory where the Tnsnames.ora file is located)

3, PL/SQL Developer configuration, the first time to open the direct selection of cancellation can

Configuration--Preferences--connection in the configuration, point to the corresponding directory

Four or more steps later, you can use, if there are errors or omissions please point out

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>

PL/SQL Developer accessing the remote database (this computer does not contain Oracle clients)