Plsql Developer configuration oralce11g Connection Go

Plsql developer because there is no corresponding 64-bit program, you can use this program to connect to Oracle only for x86 Oracle clients. This example is oracle11g, go to the official website to download instantclient_11_2 version x86. You can use this green program directly after 11g without installing the program.

1. Configure environment variables: Oracle_home=d:\program Files (x86) \instantclient_11_2

Tns_admin=d:\program Files (x86) \instantclient_11_2\network\admin

The NETWORK and admin are created manually if they are not.

2. Set Plsql Developer:

1) Enter the program, Menu: Tools-Preferences

2) Set the Oracle home directory, OCI Library, if the environment variables are set correctly, the dropdown will be found automatically.

Oracle home directory: D:\Program Files (x86) \instantclient_11_2

OCI Library: D:\Program Files (x86) \instantclient_11_2\oci.dll

OK, save. Exits the program.

3) Start the program and enter the login screen:

Database and other drop-down will have tns_admin Tnsnames.ora configured connection name, enter the user name, password to log in.

This article is from the "people in the Forest" blog, make sure to keep this source http://penseestroller.blog.51cto.com/3167878/1562806

Plsql Developer configuration oralce11g Connection Go