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

Source: Internet
Author: User
Tags win32

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.