Resolves a 32-bit Plsql client connection not 64-bit oracle11g on the database

Because I installed the 64-bit oracle,plsql is 32 bits of the connection is not on. There are ways to connect online;

2. Download Plsql_developer Address:

   http://pan.baidu.com/share/link?shareid=3768883331&uk=3557941237

   Download instantclient-basic-win32-10.2.0.5 Address:

   http://pan.baidu.com/share/link?shareid=3782452820&uk=3557941237

4. 2

   Install your downloaded plsql_developer and click on the Chinese file for Chinese.

   Install well open you will find that your plsql_developer can not connect to the database properly, there is no initialization of the database content:

   Steps to read
6. 3

   Do not worry at this time, please unzip the instantclient-basic-win32-10.2.0.5 file you downloaded. Then copy the folder under the Producti folder to your database installation, and mine is:

   E:\app\Administrator\product.

   Step reading Step Reading
8. 4

   Then found two files Listener.ora and Tnsnames.ora mine in E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN. are copied to the bottom of the E:\app\Administrator\product\instantclient_10_2.

9. 5

   Then find your Plsql_developer installed directory, mine is:

   C:\Program Files (x86) \plsql Developer

   Create a new Notepad inside and write a code like this:

   @echo off
   Set Path=e:\app\administrator\product\instantclient_10_2
   Set Oracle_home=e:\app\administrator\product\instantclient_10_2
   Set Tns_admin=e:\app\administrator\product\instantclient_10_2
   Set Nls_lang=american_america. Al32utf8
   Start Plsqldev.exe

   "" Note!!!

   My instantclient_10_2 address is: E:\app\Administrator\product\instantclient_10_2

   And you may not be the same as mine, so you have to change the path to your instantclient_10_2!

   When you're finished, change the name of your Notepad to Start.bat and click Run.

   If Plsql developer is not open, double-check that the steps and code above you are correct, and then run the Start.bat.

   Steps to read
11. 6

    1. Click--Tools--preferences--connect:

    2. Change the above logout to submit

    3.oci library changed to a path with instantclient_10_2.

    4. Application--OK--close plsql_developer rerun.

    Steps to read
13. 7

    Congratulations to you! Now you can work properly and solve the problem of win7_oracle11g_64 bit connection 32 bit Plsql_developer!

    However, when you add Chinese to the table in the database, you will because the table of Chinese has become garbled or question mark and distressed and puzzled, complaining about their luck so bad, feel that life is so unfair to you, at this time do not be sad, do not be discouraged, this is God deliberately created trouble, Let you have a greater harvest when overcoming difficulties!

    Go! Let's continue to put our learning mentality to challenge the problem!

    Steps to read
15. 8

    First of all, we need to figure out why there is a garbled Chinese.

    You forget, our database is 64-bit, and the operating software Plsql_developer is 32-bit.

    That is, you write in Plsql_developer in Chinese is a 32-bit character set, and the database can only be stored correctly is a 64-bit Chinese character set, which led to write and read is not a character set, resulting in Chinese into question marks or garbled.

17. 9

    Right-click My Computer-Computer Properties-Advanced system settings-environment variables.

    then click-OK.

19. 10

    find 1hkey_local_machine->software- >oracle->homeo  > hkey_local_machine->software->oracle>key_oradb11g_home1

    found: Nls_lang.

    Right click nls_lang--click-Modify-- The value data is changed to: Simplified Chinese_china. ZHS16GBK

    Last click-OK.

    Well, run your plsql_developer again, test it, If it is not successful, check it according to the above steps.

    Steps to read
21. 11

    It's a success! Start managing your database now!

    Finally, very congratulations to you, you successfully solve the problem, the first to thank the country, and then thank Baidu Experience, finally thank you!

    END

Precautions

• After opening the management side can not directly open Plsql, run Start.bat will automatically open Plsql

Resolves a 32-bit Plsql client connection not 64-bit oracle11g on the database