PL/SQL Developer installation

For beginners, after installing the Oracle 64-bit version of PL/SQL Developer, or some people do not want to install Oracle client and want to directly use PL/SQL Developer, always encounter a variety of problems, the following simple summary, for future reference.

Method One:

1, installation of 32-bit Oracle client;

2, install Plsql developer;

The advantage is that there are almost no manually configured content, but because the PATH environment variable may be modified, you may encounter other problems when executing sqlplus or other similar commands.

Method Two:

1, installation of PL/SQL Developer;

2, download and unzip the 32-bit version instant client to any directory;

3. Setting Environment variables

Nls_lang=simplified Chinese. Zhs16gbk

4. Start Plsqldev.exe, click Preferences and modify the Oracle home directory name and the OCI library path to the instant Client decompression directory.

This method is basically harmless, but the environment variable must be set, otherwise the Chinese display as "? "The problem is also very confusing.

Method Three:

1, the installation procedure and method Two, just change the setting of the environment variable to batch processing;

2, in the Plsqldev.exe peer directory to establish Plsqldev.txt, add the following information:

set nls_lang=simplified Chinese. ZHS16GBK

start Plsqldev.exe ""

3. Save and change the file to Plsqldev.bat and point the target in the shortcut created at installation to Plsqldev.bat, if necessary, click Change icon to modify the original icon.

This method is a common method of my own because of some slight compulsive tendencies and do not want to set environment variables. But every time there is a bad place, a black command-line window will flash.

Method Four:

1, installation of PL/SQL Developer;

2, download and unzip the 32-bit version instantclient extract to any directory;

3, edit the Params.ini in the Plsqldev.exe sibling directory, the document default all content is the comment content, at the end of the document add the following content:

  instantclient=.\instantclient

  tns_admin=.\instantclient\network\admin

  Nls_lang=simplified Chinese. Zhs16gbk

4, directly double-click the Desktop shortcut icon to start.

This method is the way the individual is currently in use, at the same time, if using a green PL/SQL Developer, you can also directly unzip the instant client into the installation directory together into a new green version, decompression can be used directly.

The above four methods, of which the following three can be used in the environment without the Oracle client, is a relatively green installation, do not want to install the client's package can choose to use.

After the installation, some colleagues also asked the Login window database drop-down list does not have an alternative to do, if there is this requirement, please follow the following steps:

1, in the Instantclient directory to establish the Network\admin path;

2, in the new admin path to put the copy from the server Tnsnames.ora, remember to modify the IP address and other information;

3, if you are familiar with Tnsnames.ora, you can add the usual database services as needed.

PL/SQL Developer installation