Solve the Problem of connecting 32-bit plsql clients to databases without 64-bit Oracle11g

Solve the Problem of connecting 32-bit plsql clients to databases without 64-bit Oracle11g
Since I installed 64-bit Oracle, plsql cannot be connected because it is 32-bit. There is a way to connect to the Internet;

Download PLSQL_Developer:

Http://pan.baidu.com/share/link? Consumer id = 3768883331 & uk = 3557941237

Download instantclient-basic-win32-10.2.0.5 address:

Http://pan.baidu.com/share/link? Consumer id = 3782452820 & uk = 3557941237

2

Install the PLSQL_Developer file you downloaded and click the Chinese file for localization.

After the installation is enabled, you will find that your PLSQL_Developer cannot connect to the database normally and there is no database initialization content ,:

Steps
3

Please uncompress the instantclient-basic-win32-10.2.0.5 file you downloaded. Copy it to The producti folder installed in your database. Mine is:

E: \ app \ Administrator \ product.

VcmFjbGUxMWdfNjTOu8GsvdMzMs67UExTUUxfRGV2ZWxvcGVy "src =" http://www.bkjia.com/uploads/allimg/140928/0405342V3-1.png "/> step by step
4

Find the listener. ora and tnsnames. ora files in E: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN. All are copied to the following in E: \ app \ Administrator \ product \ instantclient_10_2.

5

Find the installation directory of your PLSQL_Developer, and mine is:

C: \ Program Files (x86) \ PLSQL Developer

Create a notebook and write the following code:

@ 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

Your path may be different from mine, so you need to change it to your instantclient_10_2 path!

After writing it, change your notepad name to start. bat and click Run.

If PLSQL Developer is not enabled, check whether the preceding steps and code are correct and then run start. bat.

Steps
6

Open PLSQL_Developer, cancel login, and enter the main interface.

1. Click -- tool -- preferences -- connection:

2. Change the above cancellation to submit

3. Change the OCI Library to the path with instantclient_10_2.

4. Run the application -- OK -- disable PLSQL_Developer and run it again.

Steps
7

Congratulations! Now you can run properly and perfectly solve the problem of win7_oracle11g_64-bit connection 32-bit PLSQL_Developer!

However, when you add Chinese characters to a database table, you will be troubled and puzzled because the text in the table turns into garbled characters or question marks, and complain about your luck, think that life is so unfair to you. Don't be sad and don't be discouraged at this time. This is a deliberate headache made by God, so that you can gain more benefits in overcoming difficulties!

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

Steps
8

First, we need to find out why Chinese garbled characters appear.

You forgot, our database is 64-bit, and the operating software PLSQL_Developer is 32-bit.

That is to say, the Chinese text you write with PLSQL_Developer is a 32-bit character set, and the database can only properly store the 64-bit Chinese Character Set, which leads to the absence of a character set for writing and reading, this eventually leads to question marks or garbled characters in Chinese.

9

Then, we found the problem and now start to solve the problem!

Right-click my computer-computer properties-advanced system settings-environment variables.

Find the variable name: NLS_LANG (if there is no new one, click -- edit if there is one ).

Change its variable value to: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Click -- OK.

10

Press WIN + R (WIN is the key with the Microsoft icon) and enter regedit to open the registry.

Find 1HKEY_LOCAL_MACHINE-> SOFTWARE-> ORACLE-> HOMEO> HKEY_LOCAL_MACHINE-> SOFTWARE-> ORACLE> KEY_OraDb11g_home1

Locate: NLS_LANG.

Right-click NLS_LANG -- click -- modify -- the value data is changed to: SIMPLIFIED CHINESE_CHINA.ZHS16GBK.

Finally, click -- OK.

Okay. Run your PLSQL_Developer again. Test it. If it fails, check it according to the above steps.

Steps
11

Succeeded! Start to manage your database now!

Finally, congratulations! You have successfully solved the problem. First of all, thanks to the country, Baidu's experience, and finally, thank you!

END considerations

After you open the management terminal, you cannot directly open plsql. If you run start. bat, plsql is automatically opened.