Shulou(Shulou.com)06/01 Report--

Download PL/SQL Developer

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

Download Instant Client, which contains files such as oci that access the database

On the Instant Client download page, download the compression package at the beginning of instantclient-basic. You need to decide whether to download 32-bit or 64-bit PL/SQL Developer according to the version of the downloaded PL/SQL Developer.

After download, extract to a directory that does not contain spaces. For example: d:\ instantclient_12_1

An exception may be triggered if the ps:Instant Client version is too high, the digits do not match, or the directory contains spaces.

III. Configuration of relevant parameters

1. Create a new NETWORK\ ADMIN in the directory extracted in the previous step, and create a new tnsnames.ora under the directory. The file content is similar to the following:

Login database = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = remote database ip) (PORT = port)) (CONNECT_DATA = (SERVICE_NAME = database example)

2. Configuration of system environment variables, which needs to restart the system to take effect.

NLS_LANG====AMERICAN_AMERICA.ZHS16GBK character coding

TNS_ADMIN====D:\ instantclient_12_1\ NETWORK\ ADMIN (that is, the directory where the tnsnames.ora file is located)

3. PL/SQL Developer configuration. Just open it for the first time and select cancel.

Configure-preferences-configure in the connection and point to the corresponding directory

4. After the above steps, you can use it. If there are any mistakes or omissions, please point out.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.