Solution for PL/SQL Developer in Windows 8 64-bit + Oracle 12c 64-bit, window812c

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.