64-bit Oracle connection configuration in Plsql

After 64-bit oracle is installed, when plsql is used for connection, the database option is blank. To solve this problem, the following records are generated:

1. Download and install oracle 11g r2

Http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_1of2.zip

Http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_2of2.zip

2. Download the oracle client 32-bit

Http://download.oracle.com/otn/nt/instantclient/11204/instantclient-basic-nt-11.2.0.4.0.zip

1) decompress the package to % ORACLE_HOME %/product/instantclient.
2) copy the % ORACLE_HOME %/product/11.2.0/dbhome_1/NETWORK directory to % ORACLE_HOME %/product/instantclient.

3. Download plsql

Http://n.uzzf.com//pc3/PLSQLDeveloper11.zip

4. Create environment variables

1), TNS_ADMIND = % ORACLE_HOME %/product/11.2.0/dbhome_1/NETWORK/ADMIN or % ORACLE_HOME %/product/instantclient/NETWORK/ADMIN
2), NLS_LANG = AMERICAN_AMERICA.ZHS16GBK # modify according to the actual situation
3) add % ORACLE_HOME %/product/instantclient/To PATH

5. Configure plsql

Go to plsql and Click Tools> Preferences

Oracle main directory name: % ORACLE_HOME %/product/instantclient/
OCI Library: % ORACLE_HOME %/product/instantclient/oci. dll

6. Restart PL/SQL Developer to log on.

7. Verify whether the connection to Oracle is successful.After the preceding configuration, run plsql again.

Write an SQL statement for verification. The query shows the following results, indicating that the connection is successful.