x11 and oracle dbca over ssh tunnel

Discussion in 'OS X' started by superbovine, Sep 12, 2005.

  1. macrumors 68030

    superbovine

    Joined:
    Nov 7, 2003
    #1
    I have am having problems getting dbca over a ssh tunnel. other software such as firefox work fine. (This is a lan not over the internet). On i386 linux it seems to work fine. However, on tiger it just opens with the "Oracle database assistant" splash screen then a the main window opens but nothing gets draw on it. however, when i try to close the "Are you sure" window opens but it is shaped like a really long rectangle without a "\n" newlines. so the "Are your sentences y/n" is one one line.
     
  2. macrumors 601

    Joined:
    Aug 15, 2005
    #2
    If it is on a LAN, you might try this:

    Open X11 and run:

    xhost +

    then ssh to your box and enter DISPLAY manually:

    export DISPLAY=<your mac's ip>:0.0

    I found Oracle's DBCA to be soooo slow over an SSH tunnel, that I just create the database manually. Thus, I never need an X11 display and can create a database over ssh easily. Let me know if you need some help doing it manually.

    EDIT: Which Oracle version are you working with? I found that some of the 9i scripts work better when run through /bin/sh instead of bash.
     
  3. macrumors 601

    Joined:
    Aug 15, 2005
  4. thread starter macrumors 68030

    superbovine

    Joined:
    Nov 7, 2003
    #4
    I haven't had time to try it. I'll have time later. I had to work on a w2k3 server yesterday... :(
     
  5. thread starter macrumors 68030

    superbovine

    Joined:
    Nov 7, 2003
    #5
    worked like a charm :D
     
  6. macrumors 601

    Joined:
    Aug 15, 2005
    #6
    Sweet. Glad it worked for you. By the way, I had better luck with 10gR2 over release 1. They finally added the feature I was looking for: the ability to drop a file from a tablespace.
     

Share This Page