PL/SQL Developer login to Oracle 12c (RPM)

Source: Internet
Author: User

installed a Oracle 12c is not able to connect to Oracle 12c after using PL/SQL developer. Look online, according to Fcflying said the operation succeeded, so make a note:


1) Install Oracle 12c 64-bit

: HTTP://WWW.ORACLE.COM/TECHNETWORK/CN/DATABASE/ENTERPRISE-EDITION/DOWNLOADS/INDEX.HTML?SSSOURCESITEID=OCOMCN

2) Installing the 32-bit Oracle Client (instantclient-basic-nt-12.1.0.1.0)

: http://www.oracle.com/technetwork/topics/winsoft-085727.html

3) Install Plsql Developer

: http://pan.baidu.com/s/1gdelc5d

4) Unzip the downloaded "instantclient-basic-nt-12.1.0.1.0" file to get "instantclient_12_1" file, copy "Instantclient_12_1" to "D:\app\ administrator\product\12.1.0 ". (Note that I am Oracle installed on the D drive)

5) Copy "D:\app\Administrator\product\12.1.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora" file to "D:\app\Administrator\product\ 12.1.0\instantclient_12_1\network\admin "directory. To illustrate, there is no "network\admin" directory structure in the "instantclient_12_1" directory, so you have to create it yourself and then copy the "Tnsnames.ora" file.

6) Install PL/SQL Developer
Install PL/SQL Developer, set the OCI library and Oracle_home in the preferences connection, such as native settings:
Oracle Home:c:\oracleapp\orcl\product\instantclient_12_1
OCI Library:c:\oracleapp\orcl\product\instantclient_12_1\oci.dll

garbled condition after processing Plsql developer connection

Problem description: After using the Oracle Green client to connect to other Oracle databases, the queried information is garbled.

Workaround:

6. Open the Plsql Developer installation directory and see the PLSQLDev.exe directory,

Create a new "Plsql_run.bat" file within the Plsql Developer folder and enter the following in the file:

---------------------------------------------------------------------------------------------

Set Nls_lang=simplified Chinese_china. Zhs16gbk

PLSQLDev.exe

Http://www.linuxidc.com/Linux/2014-10/108399.htm

Http://www.cnblogs.com/Warmsunshine/p/3647327.html

http://wanwentao.blog.51cto.com/2406488/456195

PL/SQL Developer login to Oracle 12c (RPM)

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.