Install SQL Developer on VM

Download link of Oracle SQL Developer Tool (Linux RPM package): http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

How to install
sudo rpm -ivh sqldeveloper-3.2.09.23-1.noarch.rpm

Information about RPM
rpm -qpl sqldeveloper-3.2.09.23-1.noarch.rpm

Remove RPM
rpm -evh sqldeveloper-3.2.09.23-1.noarch.rpm

List of RPM's
rpm -qa | grep -i sql

Information about RPM
rpm -qi sqldeveloper-3.2.09.23-1

Running SQL Developer
/opt/sqldeveloper/sqldeveloper.sh

Installs on menu too:
Applications/Programming/SQL Developer

Connections:

DEVWEB
Connection Type: Advanced
Role: Default
Custom JDBC URL: jdbc:oracle:thin:@//haltstdbs02:37200/devweb

TSTWEB
Connection Type: Advanced
Role: Default
Custom JDBC URL: jdbc:oracle:thin:@//haltstdbs02:37100/tstweb

Additional Details:

The connections property file can be found in:
hal-web/src/main/webapp/WEB-INF/config/spring/spring/jdbc-e1.properties.

Checking rpm’s

-----Original Message-----
From: Guillaume Radde [mailto:guillaume.radde@redhat.com]
Sent: Monday, March 19, 2012 4:25 PM
To: Ruckman, Maurice (HAL)
Subject: A few RPM commands

To get the list of installed rpms:

$ rpm -qa

To get the list of files contained in an rpm:

$ rpm -ql java-1.6.0-sun

To know which rpm provides a file on your filesystem, or to know if a file is managed by rpm:

$ yum whatprovides /usr/lib/jvm/java-1.6.0/jre/lib/security/java.security

To verify the integrity of an rpm, or to know if the files installed by an rpm have been modified by the system admin:

$ rpm -Vv java-1.6.0-sun

To list the Red Hat Channels enabled on a system (Red Hat Channels are rpm repositories managed by Red Hat):

$ rhn-channel -l

-------------------------------------
Guillaume Radde
Senior Consultant, Red Hat Consulting
guillaume.radde@redhat.com
http://www.redhat.com
-------------------------------------