Installing Sql Developer On Parallels

 admin

This short post covers the installation of Oracle SQL Developer and the IP tables change required on OEL 6.4 to open up port 1521 so SQL Developer can connect to the Oracle database.

Installing sql developer on parallels download

The illustration below from my earlier post, Host to Install OEL 6.4 as a VirtualBox Guest, shows that I run my Oracle 11g Enterprise Edition spatial learning lab on VirtualBox, but my tools run on the host OS, Ubuntu:

Download and Install VirtualBox. The first step is to download VirtualBox from the VirtualBox. Download and install Oracle community edition (express edition)Download and configure SQL Developer where you can practice SQLSetting up connection between O. To install SQL Developer simply unzip the downloaded file. With SQL Developer users can connect to any supported Oracle Database, for all Oracle database editions including Express Edition. Before starting this tutorial, you should: Install Oracle SQL Developer 2.1 early adopter from OTN here. Follow the readme instructions here. This short post covers the installation of Oracle SQL Developer and the IP tables change required on OEL 6.4 to open up port 1521 so SQL Developer can connect to the Oracle database.

Configure the Hosts File

Add the host name of the Oracle database server to /etc/hosts on the machine running SQL Developer.

Open Port 1521

SQL Developer needs to connect to the TNS listener on the Oracle database server over port 1521 (or some other configured port), so Linux needs to accept traffic on port 1521. Use Telnet to test whether the port is open on the database server. From the machine running SQL Developer issue the following command substituting your Oracle database server host name and listener port.

A stupid query is not running on that standard SQL Server, it takes 45 minutes to execute, while on my laptop it takes 2 seconds with the same db. So I suspect either SQL Server is corrupted or windows is corrupted (other ideas?). This is why I would like to try to install express (to bypass 'SQL Server is corrupted').

If telnet cannot get through on that port check the /etc/sysconfig/iptables file on the Oracle database server. Confirm that port 1521 is open. I had to add the rule outlined in red. Please talk to your Systems Administrator about the risks of making this change. My house is behind a firewall appliance and port 1521 is blocked to the outside world, so I felt secure making this change.

Installing Sql Developer On Parallels Free

If you make changes to /etc/sysconfig/iptables run the following command to restart iptables afterwards:

Download SQL Developer

Installing Sql Developer On Parallels Download

Download SQL Developer from here: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html. Pick the appropriate distribution for your system. For OEL 6.4 that is Other Platforms.

Install SQL Developer

The installation itself is very well documented here: https://forums.oracle.com/forums/thread.jspa?threadID=2302774. Follow the instructions found on that page to install SQL Developer.

The SQL Developer software requires Java. The link above includes a step where you have to add the Java installation location to a configuration file. I’ve had to do that in the past on other machines, but I did not have to do that on this machine. Since I’m a Java developer and need to use an older Sun distribution of Java for compatibility reasons I did a separate set-up step not mentioned before in my blog. That included added JAVA_HOME to my .bashrc file.

Add a Database Connection

After installing and launching SQL Developer click the green plus sign to add a new database connection:

Supply the information displayed when the TNS Listener was started.

Connect to the Oracle Database Server

As long as your database is started, your listener is listening to port 1521, and iptables allows traffic on port 1521 you should now be able to connect to the SPATIAL_LEARNING database.

Installing Sql Developer On Parallels 2019

In my next post, I will setup Oracle Map Viewer.