How to access the Oracle database at window 7 64-bit PL/SQL

The general Plsql Developer does not have a 64-bit version, so an error occurs when running the subroutines 64-bit Oracle on a 64-bit system. The workaround is as follows:

0th Step: Install the Oracle 11g 64 database in Windows 7, such as installing to f:\

P10404530_112030_mswin-x86-64_1of7.zip

P10404530_112030_mswin-x86-64_2of7.zip

Unzip to a folder, then install the Oracle 11g 64 database, but do not create a database. After installation, configure Tnsnames.ora via net Manager

First step: Oracle official Web Download a 32-bit client (instantclient), be sure to download the basic version, do not download the Basiclite version. such as instantclient-basic-win32-11.2.0.1.0. zip

Step Two: Extract to Oracle installation directory,f:\app\administrator\product

Step three: Copy the F:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\Tnsnames.ora to F:\app\Administrator\ Product\instantclient_11_2\

Fourth step: Set Environment variables:

Variable name: tns_admin

Variable Value: F:\app\Administrator\product\instantclient_11_2

　　　　

After setting the environment variable, create the Start.bat file in the Plsql Developer directory.

The following are the contents of Start.bat:

@echo off
Set Path=f:\app\administrator\product\instantclient_11_2
Set Oracle_home=f:\app\administrator\product\instantclient_11_2
Set Tns_admin=f:\app\administrator\product\instantclient_11_2
Set Nls_lang=american_america. Zhs16gbk
Start Plsqldev.exe

where set Nls_lang=american_america. ZHS16GBK's ZHS16GBK is your database encoding.

Then start your plsql Developer, but don't log in and go straight in.

Then click tools → preferences → Connect, set the "Oracle home directory name" to NULL, and set the "OCI Library" to the path of the Oci.dll in the Instantclient directory,

Example: F:\app\administrator\product\instantclient_11_2\oci.dll

　　

Then save and exit Plsql Develoer, and then run Start.bat.

How to access the Oracle database at window 7 64-bit PL/SQL