(64-bit oracle uses 32-bit PLSQL) install 64-bit oracle database software, use 32-bit PLSQL Developer Connection method, plsqloracle

(64-bit oracle uses 32-bit PLSQL) install 64-bit oracle database software, use 32-bit PLSQL Developer Connection method, plsqloracle

Since PLSQL Developer does not provide 64-bit, I sorted out the information on the Internet and sent it

 

1. Download and install Oracle 11g R2 64-bit. During Server installation, the hardware detection failure information is ignored;

 

2. Download the Oracle 11g R2 32-bit client, decompress it to the D: \ app \ Jack \ product directory, and name it instantclient;
Client download can go to Baidu a bit: instantclient-basic-nt-11.2.0.2.0.zip can be found, remember is the next 32-bit

 

3. Download and install PL/SQL 9.0 (or above). During the installation process, PL/SQL automatically detects the Client Directory and loads the corresponding dll, which is: Oracle Home = D: \ app \ Jack \ product \ instantclient; OCI library = D: \ app \ Jack \ product \ instantclient \ oci. dll. If Automatic Detection is not performed, set Oracle Home and OCI library in Tools> Preferences Connection without logging in;

 

4. The key step is to copy a Directory D: \ app \ Jack \ product \ 11.2.0 \ dbhome_1 \ NETWORK under the root directory of the database installation to the Oracle Client Directory D: \ app \ Jack \ product \ instantclient;

 

5. Start Oracle Database Service OracleOraDb11g_home1TNSListener and OracleServiceORCL. the user logs on and connects to PL/SQL!

 

6. Let's talk about the Chinese language. Otherwise, the Chinese language may not be well supported, such as stored procedures.

Environment variable: NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

I am a 64-bit Win7 system, recently installed 32-bit oracle 10g client (client), also installed pl/SQL, cannot connect to the database

64: 64: 32: 32. It is very troublesome to install 64. Replace it with 64.

I am a 64-bit Win7 system, recently installed 32-bit oracle 10g client (client), also installed pl/SQL, cannot connect to the database

No problem with 32 databases installed on 64 computers. But I have never tried a 32-bit client. When the client fails to connect to the database, many cases are related to the environment variables. Which step did you display in the blank box?