WINDOWS64-bit Oracle Database 12c Release 2 installation and PL/SQL Developer configuration

Tossing an afternoon, a few pits, and finally with PL/SQL connected to Oracle, tanning pits experience.

First go to the Oracle website 12c, the official website has the login verification, if not registered, first register it. The database (http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html) has two compressed packages, which are downloaded and extracted together to perform the installation files inside. The first pop up a confirmation box, said what development environment does not meet the requirements, no tube, point is down step by step, go through the long installation process to complete, remember to look at the address of EM, you can use this address to try. I installed locally to the D-Disk Oracle directory D:\DEV\ORACLE\PRODUCT\11.2.0\DBHOME_1,EM address: Https://wulf00.home.langchao.com:1158/em.

The 32-bit client version of 12c from Oracle official website, because PL/SQL only supports 32-bit. Under OK, overwrite to instantclient_12_2 directory D:\Dev\oracle\instantclient_12_2.

finally download PL/SQL and install, open to Tools preferences Configuration connection file, Oracle home:d:\dev\oracle\instantclient_12_2,oci library:d:\dev\oracle \instantclient_12_2\oci.dll. The key is to configure the environment variables, tns_admin:d:\dev\oracle\instantclient_12_2, and then add in path: D:\Dev\oracle\instantclient_12_2.

After the installation of Oracle in the D:\Dev\oracle\instantclient_12_2 directory automatically generated Tnsnames.ora files, there will be a database service, you can add their own configuration. Here is the pit is the second and the last step, 32-bit client must be downloaded, and if not in the path to add the client, PL/SQL opened after the dead or alive will not come out of the database's dropdown box option.

　　

WINDOWS64-bit Oracle Database 12c Release 2 installation and PL/SQL Developer configuration