Solution for PL/SQL Developer in Windows 8 64-bit + Oracle 12c 64-bit, window812c
1) install Oracle 12c 64-bit
2) install a 32-bit Oracle client (instantclient-basic-nt-12.1.0.1.0.zip)
Download instantclient-basic-win32-11.2.0.1.0.zip, must be win32 version, Oracle official website has download, unzip it to the Oracle Installation Directory of the Product: D: \ oracle \ product \ instantclient_12_1.
Copy the NETWORK \ ADMIN \ tnsnames. ora file to the Directory D: \ oracle \ product \ instantclient_12_1.
3) install PL/SQL Developer
Install PL/SQL Developer and set OCI Library and Oracle_Home in perference-> Connection. For example, set:
Oracle Home: D: \ oracle \ product \ instantclient_12_1
OCI Library: D: \ oracle \ product \ instantclient_12_1 \ oci. dll
4) set environment variables (modify PATH and TNS_ADMIN environment variables)
Run cmd to enter DOS and enter the command sqlplus/as sysdba to view NLS_LANG
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 "computer"-"properties"-"Advanced System settings"-"environment variables"-"system environment variables ":
1>. Select "Path"-click "edit" to add "D: \ oracle \ product \ instantclient_12_1;
2>. Click "new", set the variable name to "TNS_ADMIN", set the variable value to "D: \ oracle \ product \ instantclient_12_1;", 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 ";
Click "OK" to exit.
Start PL/SQL Developer and run it normally.
Solutions to PLSQL in Windows 7 64-bit Oracle 12c
PL/SQL Developer? It is 32-bit and only 32-bit, while oracle is 64-bit. It cannot call a 64-bit oracle client, so it cannot be used.
There are two solutions:
If 32-bit oracle is directly installed without 64-bit oracle, it can be used normally.
Install a 32-bit oracle client, or streamline the client. In plsql, the home and oci path of the device are supported.
For self-testing or development, you are advised to directly use 32-bit oracle.
My win764-bit installation is oracle11gR264-bit SQL plus can be used to log on, but the log on with pl/SQL developer shows ORA-12560
Use PL/SQL Developer to connect to OracleX64:
• 1. Download the 32-bit Oracle InstantClient and expand it to a directory, such as C: \ instantclient-basic-nt-11.2.0.2.0;
• 2. Copy the system tnsnames. ora to this directory;
• 3. Set Oracle_Home and OCI Library in PLSQL Developer:
Tools configure Preferences configure Oracle connector Connection:
Oracle_Home: C :\ instantclient-basic-nt-11.2.0.2.0
OCI Library: C :\instantclient-basic-nt-11.2.0.2.0 \ oci. dll
• 4. Edit the following bat file in the PLSQL Developer directory, replace the shortcut, and start PLSQL Developer:
@ Echo off
Set path = C: \ instantclient-basic-nt-11.2.0.2.0
Set ORACLE_HOME = C: \ instantclient-basic-nt-11.2.0.2.0
Set TNS_ADMIN = C: \ instantclient-basic-nt-11.2.0.2.0
Set NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
Start plsqldev.exe