Obviously the terminal window is command line only, so if you need to run a GUI application (typically for new installations and creating databases, but you might use the GUI tools for ASM and/or listener adminstration also) you’ll need to run the application on the server with the display showing on your local machine. There are several steps to this, and you likely won’t need to do them all, but you might if you run into any errors. I typically use puTTY and Exceed, but this should be similar with F-Secure/SecureCRT and Xming or whatever you’re using.
1. Enable X11 forwarding When you first open the puTTY window, look in the left navigation pane under Connection->SSH->X11 and check the box to ‘Enable X11 forwarding’. Then continue to login to the server as you usually do.
2. Set xhost Run ” xhost + ” from your terminal window. This will give you access to communicate to your local machine, I’m not a UNIX expert so I’m not sure of the exact mechanism that makes this work:
[charlotte@testbox ~]$ xhost +
access control disabled, clients can connect from any host
3. Find out your local IP address On your local machine, open the command prompt and run ” ipconfig ” then find your IP address, I’ve edited down this output, but find the line that says IPv4:
C:\Users\charlotte>ipconfig
IPv4 Address. . . . . . . . . . . : 123.456.789.012
4. Set the DISPLAY variable Back in your puTTY window, set the DISPLAY variable to your IP address with 0:0 at the end:
[charlotte@testbox ~]$ export DISPLAY=123.456.789.012:0.0
[charlotte@testbox ~]$ echo $DISPLAY
123.456.789.012:0.0
5. Open your xwindows server On your local machine open Exceed or Xming or whatever xwindows server you’re using. (Yes, the server is your local machine and the client is the database server, long story… ) A window shouldn’t open, but you can see the application running if you check the task manager.
You should be able to go ahead and run your server-side GUI application now. You can test with ” xclock ” which should open a small analog clock on your local machine.