Win8 64-bit connection to oracle Database Using plsql developer, win8plsql

Win8 64-bit connection to oracle Database Using plsql developer, win8plsql

Problem: When plsql developer is used on a 64-bit win8 system to connect to a local oracle database, an inexplicable problem may occur. The error prompt box may even be blank.

Reason: according to the Internet, it is estimated that the 64-bit Oracle database is installed on the 64-bit system, but there is no corresponding 64-bit PL/SQL Developer for us to use, therefore, you cannot connect directly at this time. You need to install the oracle client.

Solution:

1. Download instantclient_11_2 (database version is 10g, 11g can be connected), address http://download.csdn.net/detail/zxnlmj/8063243

This file does not need to be configured in this case (to connect to remote oracle)

3. Configure environment variables (example) ORACLE_HOME = D: \ ProgramFile \ oracle \ product \ 10.2.0 \ db_1,

PATH = D: \ ProgramFile \ oracle \ product \ 10.2.0 \ db_1 \ bin,

NLS_LANG = simplified chinese. ZHS16GBK.

4. Modify plsql developer-cancel login-tools-preferences-ORACLE-connection

ORACLE_HOME = D: \ ProgramFile \ oracle \ product \ instantclient_11_2

OCI library = D: \ ProgramFile \ oracle \ product \ instantclient_11_2 \ oci. dll

Application, exit and log on again.

OK.

In win7 64-bit operating system, how does plsql connect to the oracle database?

Solution to PLSQL + Developer + in win7 + 64-bit + Oracle + 11g + 64-bit

1) install Oracle 11g 64-bit (this part will not be mentioned)
2) install a 32-bit Oracle client (instantclient-basic-win32-11.2.0.1.0)
Download instantclient-basic-win32-11.2.0.1.0.zip (it must be a 32-bit version. Do not download it on the Oracle official website.) decompress it to the Product in the Oracle Installation Directory (the local name is instantclient_11_2 ): d: \ Oracle \ app \ dd \ product \ instantclient_11_2.
Copy a Directory D: \ Oracle \ app \ dd \ product \ 11.2.0 \ dbhome_1 \ NETWORK under the root directory of the database installation to the Oracle Client Directory D: \ Oracle \ app \ dd \ product \ instantclient_11_2 (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 perference-> Connection. For example, set the local machine:
Oracle Home: D: \ Oracle \ app \ dd \ product \ instantclient_11_2
OCI Library: D: \ Oracle \ app \ dd \ product \ instantclient_11_2 \ oci. dll
4) set environment variables (modify 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;
NLS_LANG
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Right-click "my computer"-"properties"-"advanced"-"environment variables"-"system environment variables ":
1>. Click "new", set the variable name to "NLS_LANG", set the variable value to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and click "OK ";
2>. Create an environment variable "TNS_ADMIN" with the value "D: \ Oracle \ app \ dd \ product \ instantclient_11_2"
Click "OK" to exit.

Start PL/SQL Developer and run it .... Remaining full text>

In 64-bit win81, PL/SQL and SQL Developer cannot connect to the local database, but sqlplus can connect

PL/SQL and SQL Developer may need to manually specify the location of the connected database file