Install SQL Developer on RHEL5

Source: Internet
Author: User

Install SQL Developer on RHEL5

The process of installing SQL Developer is relatively simple. You should first install java support and then install the SQL Developer software. The order can also be reversed. Then configure the Java point of SQL Developer, because this program needs to call Java.

1. Prepare the Software Package

Uname-I view the current system architecture

When RHEL5.8 _ x64 is used in my system, you need to prepare a corresponding java installation package.

Oracle SQL Developer displays the icon on Ubuntu and double-click it to run

Detailed configuration method for connecting PL/SQL Developer to Oracle Database

PL/SQL Developer import SQL files to Oracle

PLSQL Developer connects to a remote Oracle database

Oracle PL/SQL Developer import and export data

2. install java

# Rpm-ivh jdk-7u45-linux-x64.rpm

The installation of this software package is very slow. Please wait...

3. Install sqldeveloper

# Rpm-ivh sqldeveloper-3.2.20.09.87-1.noarch.rpm

4. Change the configuration

I usually use Oracle users to directly log on to the operating system. Therefore, every time I use Oracle as the SQL Developer user, the following operations will be performed: su-oracle, the remaining installation will be completed in Oracle $.

# Su-oracle

$ Sqldeveloper can run directly after installation.

Oracle SQL Developer

Copyright (c) 1997,201 1, Oracle and/or itsaffiliates. All rights reserved.

Type the full pathname of a J2SEinstallation (or Ctrl-C to quit), the path will be stored in ~ /. Sqldeveloper/jdk

However, the above prompt is reported during running, and the complete installation path of j2se is required.

This path must be recorded in ~ /. Sqldeveloper/jdk

That is to say, the full path of the file needs to be written in/home/oracle/. sqldeveloper/jdk, then sqldeveloper finds this file, and then uses this file to find java

$ Mkdir/home/oracle/. sqldeveloper

$ Rpm-ql jdk | tail-3 // find the installation path

/Usr/java/jdk1.7.0 _ 45/man/man1/xjc.1

/Usr/java/jdk1.7.0 _ 45/release

/Usr/java/jdk1.7.0 _ 45/src.zip

$ Echo '/usr/java/jdk1.7.0 _ 45/'>/home/oracle/. sqldeveloper/jdk

Redirects the installation path to the jdk file.

5. log on

A super user must provide an x environment for Oracle or log on to the system directly using oracle. If either of the preceding conditions is not met, an error is returned when SQL Developer is executed. Do you want to see what I reported? Try it by yourself ~~~

# Xhost ++ // provides the x environment for oracle users. Note that the environment is currently a root user.

Access control disabled, clients canconnect from any host

# Su-oracle

$ Sqldeveloper

The prompt indicates that the current version is a bit high. When running SQL Developer, the minimum java version is 1.6.0 _ 04, and the largest Java version is 1.7.7. Our current version is 1.7.0 _ 45. It may not be fully supported, and the operation may fail.

Ignore him. I have used it. Directly select This "Skip This Message Next Time" and then Yes.

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.