PL/SQL connection to Oracle database-no connection option



the 7 - bit Oracle database installed on the Win Oracle client, with Plsql Connection Oracle appears when situation , only user name, password, database fill or select box, there is no "login as" (role) selection box.

Solution:

1) Installation Oracle 11g 64-bit

2) installation 32-bit Oracle client (instantclient-basic-win32-11.2.0.1.0)

copy a directory under the root directory of the database installation D:\app\min\product\11.2.0\dbhome_1\NETWORK\ to the Oracle client directory D:\Program Files (x86) \oracle\odac_client (actually only need Network\admin\tnsnames.ora)

3) Install PL/SQL Developer

installation PL/SQL Developer, the OCI library and Oracle_home are set up in tools->perference->connection, for example, the local settings are:

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 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;

Right-click "My Computer"-"Properties"-"advanced"-"Environment variables"-"System environment variables":

1> Select "Path"-click "Edit" to add "D:\app\min\product\11.2.0;"

2> Click " new", the variable name is set to "Tns_admin", the variable value is set to "D:\app\min\product\11.2.0;", 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, re-login PL/SQL, the "login as" option appears ~ ~ ~ After landing, we can operate on Oracle.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

PL/SQL connection to Oracle database-no connection option