x11 and oracle dbca over ssh tunnel

[superbovine]

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.

 

[belvdr]

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.

 

[belvdr]

Did you ever get this worked out?

 

[superbovine]

Did you ever get this worked out?

I haven't had time to try it. I'll have time later. I had to work on a w2k3 server yesterday...

 

[superbovine]

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.

worked like a charm

 

[belvdr]

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.