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

As an excellent development management tool of oracle, PL/SQL Developer can bring great convenience in daily work. It is really a great help for us to make good use of some tools. This article will talk about the installation and configuration process of PL/SQL Developer in detail.

1. Download PL/SQL Developer at http://www.cncrk.com/downinfo/38983.html#softdown. After downloading.

(1) Click PLSQL Developer10.0.3.1701.exe to install, select I Agree, choose your own installation path according to the actual situation, and click Next.

(2) after the installation is complete, click PLSQL Developer10.0.3.1701_CHS.exe for Sinicization, select the installation path just now, and click start to match for Sinicization.

(3) double-click the PLSQL Developer10.0.3.1701_keygen.exe registrator at this time to register and open the PLSQL Developer software (no link for the time being). Select registration in the help and copy it to the registry according to the information of the registrant.

2. Install the oracle client and download it at http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html,.

Be sure to download 32-bit Instant Client for Microsoft Windows (32-bit) here, because the database version I installed is 11.2.0.1, so install

Instantclient-basic-win32-11.2.0.1.0.zip (51458190 bytes) in Version 11.2.0.1.0; ps: if you want to install PL/SQL Developer 12, you need to download 64-bit clients from the official website.

3. Start the configuration below:

(1) Open PL/SQL Developer, tool → preferences → oracle → connection, and configure the oracle main directory name and OCI library, as shown in the figure:

Where the main directory name is the path where the oracle client is installed, and the OCI library is the oci.dll file under the client installation path. Find these two addresses and fill in them.

(2) establish the NETWORK and ADMIN folders under the instantclient_11_2 directory, and copy the sqlnet.ora and tnsnames.ora files from the database server to the ADMIN folder.

(3) configure the environment variable, my computer → properties → advanced system settings → environment variable, the new variable is named TNS_ADMIN, and the value of the variable is G:\ oracleclient\ instantclient_11_2\ NETWORK\ ADMIN. In fact, the value of this variable is the path where the tnsnames.ora is located.

Pay attention to setting the character set, otherwise there will be garbled: variable name: NLS_LANG variable value: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

4. Open PL/SQL Developer and enter the user name and password. The database refers to the previously configured network service name.

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.