PL/SQL Developer 8.0 Forum

This is a community forum and not official technical support. — If you need official support: Contact Us

The following comments are owned by whoever posted them. We are not responsible for them in any way.

Back to Threads Reply to Thread

Setup Guide

Works fine using CrossOver 7.1.0 and PL/SQL Developer 7.1.5.1398.

adapted from Original Message

  • Run the setup
  • Download Oracle InstantClient for Win32 from the Oracle site
  • unpack them in under C:\Program Files\instantclient\
    (note: The easiest way to get to the C: drive is to go to the Configure menu and select Manage Bottles. Under the Advanced tab there is a button "Open C: Drive in Finder")
  • Create a link to your tnsnames.ora file inside C:\Program Files\instantclient\
    • You will have to create the network and admin folders
    • cd instantclient
    • mkdir network/admin
    • cd network/admin
    • Create the actual link
    • ln -s $ORACLE_HOME/network/admin/tnsnames.ora .
      OR
    • ln -s $TNS_ADMIN/tnsnames.ora
    • wherever your tnsnames.ora lives...
  • Launch pl/sql developer
  • Go to preferences.
  • set oracle home to C:\Program Files\instantclient
  • set oci.dll to C:\Program Files\instantclient\oci.dll
  • Close it, and launch it again.
  • You should be able to connect to a database now.

Hi Rogers,

I use PL/SQL developer a lot and recently switched myself to Mac Air Book and I'm trying to get it working in OS/X environment.

I followed your instructions above to get pl/sql developer running on crossover. I could see my tnsnames entries fine, when I open PL/SQL developer. But, I'm having trouble figuring out the ssh tunneling part needed to connect to remote oracle database server. Do I need to get windows specific ssh client and set up port forwarding etc? I'd appreciate any help here.

e.g. my tnsname local & remote hosts are:

HOME.xxxdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1530))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxxx)
)
)

on the remote host

REMOTE.xxxdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = remote.xxx.org)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxxx)
)
)

How do I get the tunnel set up?

thanks in advance,
krishna

There are some Mac apps for setting up SSH tunnels, or you can familiarize yourself with the ssh command-line program. For the GUI apps, I can't vouch for any in particular, but you can search Apple's Download section, macupdates.com, or versiontracker.com.

I install Oracle Develoer 6i , now i cannot connect to database
I udate tnsnames.ora file but not connect to database.
How i can do this.
Thanks

Did you follow the guide from Brett A. Rogers?

Do you get any error specific error message or something that could be used to follow the problem?

I have been using PL/SQL Developer without incident for the most part, thanks for the setup guide.

I am, however, having one tiny problem. If I minimize the PL/SQL Developer window it will do the animation down to the Dock, but nothing I've tried will restore it. I work around it by not minimizing it, but sometimes I do it out of habit to move the window.

Any way to bring it back to the screen? Does not show up in Expose and CMD+Tab lets me cycle to it, but does not restore it.

Are you also using Apple's X11? If so, this is a known problem that should be solved in CrossOver 8.0.3, which was just released.

The problem was that Apple's X11 and CrossOver both use quartz-wm as a window manager. The integration of quartz-wm and the Dock relies on some funky magic behind the scenes. Prior to CrossOver 8.0.3, the Dock could get confused about which instance of quartz-wm owned which minimized windows. It would essentially pick one at random. However, if it picked the wrong one, the window couldn't be restored from minimization.

Anyone else try this software with the shiny new 9.0?

Seems to work fine other than most of the toolbar icons being corrupted. The buttons themselves work, just (for me) all but Connect and Execute icons are blank/black/grey boxes.

This is with CO 9.0 Pro, PLSQL Developer 8.0.2, in an upgraded from 8.0 WinXP bottle and also in brand new under 9.0 XP and Vista bottles.

I am still getting the issue where I minimize the PLSQL Developer app and not being able to restore it if I click the PLSQL Developer icon in the dock. IF the minimized app pops itself down to the right hand side of the dock I can restore using that, but clicking the application icon on the left hand side of the dock will make the folder side icon vanish and will not restore.

BTW, not really a PL/SQL Developer issue, but the 9.0 install process for "Unsupported Applications" is WAY counterintuitive.

Edited to add: I can post screen shots if this helps

I am having the same problem with icons in the toolbar of PL SQL developer 8.0.2 being black or gray. The app worked fine under CO 8.0

Leo Gelman wrote:

I am having the same problem with icons in the toolbar of PL SQL
developer 8.0.2 being black or gray. The app worked fine under CO
8.0
:::whew::: I was worried it was just me. ;) Sorry you've got the same issue, but glad to have someone able to repro.

Are you minimize/restore PL/SQL Developer without any problems?

An additional piece of information, I am running multi monitor: an external LCD and my MBP LCD. Does not seem to matter if I am minimizing from either monitor, but figured I would throw that out there.

Larry wrote:

Are you minimize/restore PL/SQL Developer without any problems?

Just tested minimization using only MBP display - yep, a strange small window appears in the top left corner after restoration of the minimized window. Once the small window is deleted, the main restored window disappears as well.

I just upgraded to PL/SQL Developer 8.0.3 and still have both the button corruption and faulty minimize/restore actions. The application works fine for what I am using it for, but seems disappointing to go backwards in the level of UI support in the button bar and no movement on the minimize/restore. :(

I have the same problem with PLSQL Developer 8.x and Crossover 9.0 Pro.

But you can restore the application window if you try to click the panel many times.

To solve the issue with unreadable buttons and also the issue with not working reports, I found the following solution in wine support forum:

  1. For the buttons simply uncheck option for shade buttons in Tools->Preferences-> Appearance

  2. For not working reports (OLE Error 80070057) install IE6 (even if crossover is telling you, that the bottle is incompatible).

For setting propper NLS_LANG parameters in registry, I simply copied the oracle client folder of a working windows installation, put it into the c_drive and also exported the Oracle Key from Registry of the windows machine. Loaded Oracle key to bottle registry and everything works.

1 to 14 of 14

CrossOver Forums: the place to discuss running Windows applications on Mac and Linux

CodeWeavers or its third-party tools process personal data (e.g. browsing data or IP addresses) and use cookies or other identifiers, which are necessary for its functioning and required to achieve the purposes illustrated in our Privacy Policy. You accept the use of cookies or other identifiers by clicking the Acknowledge button.
Please Wait...
eyJjb3VudHJ5IjoiVVMiLCJsYW5nIjoiZW4iLCJjYXJ0IjowLCJ0enMiOi02LCJjZG4iOiJodHRwczpcL1wvbWVkaWEuY29kZXdlYXZlcnMuY29tXC9wdWJcL2Nyb3Nzb3Zlclwvd2Vic2l0ZSIsImNkbnRzIjoxNzM0NzIyMzMzLCJjc3JmX3Rva2VuIjoiV2MzSjdnUVVHUHVCQzJVZCIsImdkcHIiOjB9