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