Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "PLSQL Developer connection Oracle11g 64-bit database configuration example analysis", the content is easy to understand, well-organized, hope to help you solve your doubts, the following let the editor lead you to study and learn "PLSQL Developer connection Oracle11g 64-bit database configuration example analysis" this article.

1. Download instantclient-basic-win32-11.2.0.1.0 (oracle official website download address: http://www.oracle.com/technetwork/topics/winsoft-085727.html

two。 Extract instantclient-basic-win32-11.2.0.1.0 and place it under product in the oracle installation directory (no mandatory location, you can place it at will), as shown below:

3. Copy the tnsnames.ora file under E:\ app\ Administrator\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN to instantclient_11_2.

4. Open PLSQL Developer, select Tools-> perference-> Connection, and configure the Oracle Home and OCI Library entries, as shown below:

Where Oracle Home:E:\ app\ Administrator\ product\ instantclient_11_2

OCI Library:E:\ app\ Administrator\ product\ instantclient_11_2\ oci.dll

5. Configure system environment variables

Right-click "my computer"-"Properties"-"Advanced"-"Environment variables"-"system Environment variables":

1 >. Select "Path"-Click "Edit" to add "E:\ app\ Administrator\ product\ instantclient_11_2;"

2 >. Click New, set the variable name to "TNS_ADMIN", set the variable value to "E:\ app\ Administrator\ product\ instantclient_11_2;", and click "OK".

3 >. Click New, set the variable name to "NLS_LANG", set the variable value to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and click "OK".

The above is all the contents of the article "sample Analysis of PLSQL Developer connection Oracle11g 64-bit Database configuration". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.