Oracle 11g 64-bit solution with PL/SQL not logged in

Because of the use of PL/SQL, we have just installed Oracle 11g 64-bit today, and after the results are turned on, PL/SQL is not automatically configured.

Then find the following blog post on the Internet, follow the steps to solve. Share Next Blog Content

1) Install Oracle 11g 64-bit

2) Installing the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0)

Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website has downloaded), Unzip it to product under the Oracle installation directory (this machine is named: instantclient_11_2): D:\Oracle\app\YM\product\instantclient_11_2.

Copy a directory under the root directory of the database installation D:\Oracle\app\YM\product\11.2.0\dbhome_1\NETWORK to the Oracle client directory D:\Oracle\app\YM\product\ Instantclient_11_2 (in fact only need Network\admin\tnsnames.ora)

3) Install PL/SQL Developer

Install PL/SQL Developer, set up OCI library and Oracle_home in Perference->connection, for example, native settings:

Oracle home:d:\oracle\app\ym\product\instantclient_11_2

OCI Library:d:\oracle\app\ym\product\instantclient_11_2\oci.dll

My comment: There is actually a small problem here, the default directory for Oracle installation now is the app, and you don't see the Oracle Word.

4) Set Environment variables (modify path and tns_admin environment variables)

For Nls_lang environment variables, it is best to set to the same as the database side, first query the character set information from the database side:

Sql> Select Userenv (' language ') Nls_lang from dual;

Nls_lang

----------------------------------------------------

Simplified Chinese_china. Zhs16gbk

My comment: This step does not need to do, directly configure the character set can be.

Right-click My Computer-Properties-advanced-environment variables-system environment variables:

1> Select "Path"-click "Edit" to add "D:\Oracle\app\YM\product\instantclient_11_2;"

2> Click "New", the variable name is set to "Tns_admin", the variable value is set to "D:\Oracle\app\YM\product\instantclient_11_2;", click "OK";

3> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK ";

Finally click "OK" to exit.

Oracle 11g 64-bit solution with PL/SQL cannot log on (go)