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

First, the solution

Because I installed the 64-bit Oracle, the Plsql is 32-bit and it is not connected. There are ways to connect online.

1. File download

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

2. Installation of Plsql_developer and Chinese

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

3. instantclient file Decompression and replication

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.

4. Found two files listener.ora and Tnsnames.ora

Mine is inside the E:\Files\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN.

are copied to the bottom of the E:\Files\Oracle\product\11.2.0\client_1\network\admin.

5. Configure the Plsql_developer

Find your Plsql_developer installed directory, mine is: E:\Files\Oracle\plsql_developer\

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

@echo off
Set path=e:\files\oracle\product\11.2.0\client_1
Set oracle_home=e:\files\oracle\product\11.2.0\client_1\
Set tns_admin=e:\files\oracle\product\11.2.0\client_1\
Set Nls_lang=american_america. Al32utf8
Start Plsqldev.exe

Attention:

My instantclient_10_2, the address is: E:\Files\Oracle\product\11.2.0\client_1\

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.

6

After opening the Plsql_developer, cancel the login and enter the main interface.

1. Click--Tools--preferences--Connect:

2. Change the above cancellation to submit

The 3.OCI library is changed to a path with instantclient_10_2.

E:\Files\Oracle\product\11.2.0\dbhome_1\bin\oci.dll

4. Apply--OK--turn off Plsql_developer to run again.

7. Complete

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!

second, Chinese garbled problem throw to solve

1. Analysis of the reason of Chinese display garbled

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.

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

2. Problem solving

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

Create a new variable name: Nls_lang (if the variable name already exists, click-Edit).

Change its variable value to: Simplified Chinese_china. Zhs16gbk

Then click-OK.

3

Press Win+r (Win is the button with the Microsoft icon), enter: Regedit to open the registry.

Find Hkey_local_machine-> software-> oracle>key_oradb11g_home1

Found: Nls_lang.

Right click nls_lang--click-Modify--Value data to: Simplified Chinese_china. Zhs16gbk

Last click-OK.

4 PostScript

OK, rerun your plsql_developer, test it, if not successful, check it according to the above steps.

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, finally thank you!

Precautions

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

Reference articles

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

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