PL/SQL connection to the Oracle database -- no connection is required, ploracle

PL/SQL connection to the Oracle database -- no connection is required, ploracle
Zookeeper

The 64-bit Oracle database installed on Win 7 is then installed with a 32-bit Oracle client. When you connect to Oracle using PLSQL, only the username, password, and database enter or select box are displayed, there is no select box for "Logon as" (role.

Solution:

1) InstallationOracle 11g 64-bit

2) Installation32-bit Oracle clientInstantclient-basic-win32-11.2.0.1.0)

Copy a Directory D: \ app \ min \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ in the root directory of the database to D: \ Program Files (x86) in the Oracle client directory) \ Oracle \ odac_client (in fact, only NETWORK \ ADMIN \ tnsnames is required. ora)

3) install PL/SQL Developer

Install PL/SQL Developer and set OCI Library and Oracle_Home in Tools> perference> Connection. For example, set the local machine:

Oracle Home: D: \ Program Files (x86) \ Oracle \ odac_client

OCI Library: D: \ Program Files (x86) \ Oracle \ odac_client \ oci. dll

4) set environment variables (modify PATH and TNS_ADMIN environment variables)

For the NLS_LANG environment variables, it is best to set them to be consistent with the database. First, query the character set information from the database:

SQL> select userenv ('language') nls_lang from dual;

Right-click "my computer"-"properties"-"advanced"-"environment variables"-"system environment variables ":

1>. Select "Path"-click "edit" and add "D: \ app \ min \ product \ 11.2.0;

2>. Click "new", set the variable name to "TNS_ADMIN", set the variable value to "D: \ app \ min \ product \ 11.2.0;", and click "OK ";

3>. Click "new", set the variable name to "NLS_LANG", set the variable value to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and click "OK ";

Finally, log on to PL/SQL again. The "Logon As" option appears ~~~ After logging in, we can operate on Oracle.

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.