How to install PL/SQL developer on Linux (RPM)

Source: Internet
Author: User
Tags win32

How to install PL/SQL developer on Linux
工欲善其事 its prerequisite, PL/SQL and Toad are important tools for Oracle practitioners, but none of these tools have a Linux distribution, and if you want to use these tools on Linux, you need
Wine or crossover This Windows application Simulator, crossover is wine's enhanced version, nonsense said, the following starts to demonstrate the installation steps:

1: Environment Introduction
Operating system: RHEL5.4 64-bit operating system, KVM client (other Linux operating systems can also try)
PL/SQL Developer version: 8.0.4.1514
Crossover version: 7.00
Oracle Client: instantclient-basic-win32-10.2.0.5

2: Install crossover
First give the crossover installer (actually a shell script) the executable permission, and then run in the graphical interface to install the success

3: Install the PL/SQL Developer Setup program
After installing crossover, click "Applications"--"crossover"--"Install Windows software", tick "install Unsupport software" and click "Next" button to continue
After selecting the "Other Installer file" button, browse the path of the PL/SQL installer Setup.exe file and click the "Next,continue" button to install the success

4: Import Oracle Client
instantclient-basic-win32-10.2.0.5 for Green Software, for: http://www.oracle.com/technetwork/indexes/downloads/index.html
After the download is complete, upload to the server, unzip to the/root/.cxoffice/winxp/drive_c/program files directory, and rename instantclient where "WinXP" is the name of crossover bottle, You can also specify a new bottle
Create the Network/admin directory under the Instantclient directory using the Mkdir-p command, and then create the Tnsnames.ora file under the directory
(Note: There is also a way to install the wfclient2635 program in the crossover, but also can be installed on the Oracle client, this practice has been tested, no success, still needs to be researched!)

5: Configure the PL/SQL Developer client program
Double-click the PL/SQL icon on the desktop, the landing page appears, if the Connect as option box appears at the bottom, the previous Oracle client import step is successful, otherwise please perform step 4th
Enter user name, password, connection will fail, click "Cancel" button, pop-up interface box, click "Tools"--"preferences"--"connection"
Specifies that the value of Oracle home is/root/.cxoffice/winxp/drive_c/program files/instantclient
Specify the value of the OCI library as/root/.cxoffice/winxp/drive_c/program Files/instantclient/oci.dll
Click "Apply" button and exit from new login to connect successfully

6: Client Character Set issues
When using PL/SQL in the VNC or Virt-manager interface, there is no problem logging in, but the ora-24329:invalid character Set identifier error occurs when executing the statement

Use Xmanager connection login, prompted character set mismatch, need to modify the registry prompt! But after naming it, it appears normal.

7: Reference Document
http://www.codeweavers.com/compatibility/browse/name/?app_id=3633;forum=1;msg=44522
If you need related software, please contact Q Group: 135919739

Coding problems According to Xmanager hint, modify the crossover registry, according to the author, directly on the RHEL5 and RHEL6 64-bit system installed as above, there will be no incorrect character set encoding problem

http://ylw6006.blog.51cto.com/470441/541262/

How to install PL/SQL developer on Linux (RPM)

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.