PLSQL developer connection Oracle11g 64 bit database configuration details (Graphic)

Time:2019-12-20

Recently, a 64bit computer was replaced, so the Oracle database also changed to 64bit, but the problem also arose. Because PLSQL developer does not have the 64bit version at present, it cannot connect to the 64bit oracle. After some setbacks, it finally successfully connects to the database. Now, the configuration process is recorded for easy viewing.

1. Download instantclient-basic-win32-11.2.0.1.0 (download address: http://www.oracle.com/technology/topics/winsoft-085727.html, download address: https://www.jb51.net/database/572635.html)

2. Unzip the instantclient-basic-win32-11.2.0.1.0 and place it under the product of the Oracle installation directory (the location is not mandatory and can be placed at will), as shown in the following figure:

3. Copy the tnsnames.ora file under E: \ app \ administrator \ product \ 11.2.0 \ dbhome \ 1 \ network \ admin to the instantclient? 11? 2.

4. Open PLSQL developer, select Tools > preference > connection, and configure the Oracle home and OCI library items, as shown in the following figure:

 

Where, Oracle home: e: \ app \ administrator \ product \ instantclient

 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” to the list;

2> . click “new”, the variable name is set to “TNS” and the variable value is set to “E: \ app \ administrator \ product \ instantclient” and click “OK”;

3> . click “new”, the variable name is set to “NLS” and the variable value is set to “simplified Chinese” china.zhs16gbk “, and click” OK “;

The above is the whole content of this article. I hope it will help you in your study, and I hope you can support developepaer more.

Recommended Today

Explain the string matching and replacement operations of regular expressions in ruby

regularmatching Speaking ofRubyOf course, mention itregular expression Mechanism, regular expression as a powerful matching language has been more and more used in different fieldscharacter stringVerification, matching, web page extraction, etc. Although some people criticize the matching efficiency with regular expressions, it doesn’t matter considering the strong matching ability of regular expressions. When we talk about […]