Installing Sql Developer On Parallels Free
Installing Sql Developer On Parallels 2019

Home Forums Parallels Desktop for Mac Installation and Configuration Macbook Retina + Parallels + SQL Developer blurry! Discussion in ' Installation and Configuration ' started by ErminC, Mar 6, 2013. I have a problem to install the SQL Developer in Parallels on Windows 10. If I click on the setup icon, the installation setup doesn't start. Sometimes I see it for a half second, but I can't detect anything. I disabled optimal for retina in the parallels settings, but it doesn't help. Have someone an idea, what I could do? I look forward to. 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').

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.

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:

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.

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.

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

Installing sql developer on parallels free

Download SQL Developer

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

Installing Sql Developer On Parallels Free

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.