Remote installing Oracle on Fedora7.text-server

Hello All,

My scenario:
1) I have a Fedora 7 linux server. This server is text-based only installation. 
No X-Windows, no-Gnome and no-KDE installed;
2) I have an other machine with MS Windows plus CYGWIN installed;
3) Both are networked and no firewall running;
4) From Cygwin I am able to "ssh" Fedora7.

What I want:
1) I want install Oracle10gr2 on Fedora7. I mean... on a linux with no X, no 
Gnome and no KDE.

My background:
I always known that to install oracle database one should have graphic 
environment and java... both installed on the linux target server. BUT I have 
read that:
a) java is not necessary as oracle installation already comes with java;
b) graphic environment could be used from some remote host;

Guidance needed:
Having my scenario as above stated... how to proceed?
I mean in term of: xhost and export DISPLAY settings at least.

I have tried but with no sucess... no sure if is config problems or cygwin 
installation problem or variables setting... ?!?!?!

I have googled also... and now I ask for help in this house.

Regards,


mson77

Welcome to OraPros mson77!

What you are trying to do can be accomplished.  I have not worked on 
Fedora7/CYGWIN but do the same exact thing on Solaris all the time, in fact 
none of our solaris boxes have "heads" we always export DISPLAY to our 
workstations.

From what I understand you have MS Windows with CYGWIN (with X server) and you 
want to install ORACLE on remote linux box using your PC's monitor to drive the 
installer.

Here's what needs to happen:

 
  1. make sure X server is started

  2. find out the ID of display and ID of screen started by the X server:
        Cygwin-x faq - display and screen explained

  3. take a note of your IP address

  1. export DISPLAY variable to:
        ip_addr:display_id.screen_id

     where:
        ip_addr =  IP address of your MS-WIN pc with CYGWIN X server
        display_id = display ID of your X server (typically 0)
        screen_id = screen ID of your X server (typically 0)

     example KSH/BASH:
        $ DISPLAY=207.71.117.101:0.0; export DISPLAY

     example CSH:
        % setenv DISPLAY 207.71.117.101:0.0

   2. from the same session where you set DISPLAY run xclock as a test
      you should be able to see XCLOCK windows on your PC

Let me know If this doesn't work -- I'll try to install CYGWIN on my PC and 
test it here.

- Vitaliy

> Welcome to OraPros mson77!
> 
> What you are trying to do can be accomplished.  I have not worked on 
> Fedora7/CYGWIN but do the same exact thing on Solaris all the time, in fact 
> none of our solaris boxes have "heads" we always export DISPLAY to our 
> workstations.
> 
> From what I understand you have MS Windows with CYGWIN (with X server) and 
> you want to install ORACLE on remote linux box using your PC's monitor to 
> drive the installer.
> 
> Here's what needs to happen:
> 
> @#ON_CYGWIN 
>   1. make sure X server is started
> 
>   2. find out the ID of display and ID of screen started by the X server:
>         Cygwin-x faq - display and screen explained
> 
>   3. take a note of your IP address
> 
> @#ON_LINUX
>   1. export DISPLAY variable to:
>         ip_addr:display_id.screen_id
> 
>      where:
>         ip_addr =  IP address of your MS-WIN pc with CYGWIN X server
>         display_id = display ID of your X server (typically 0)
>         screen_id = screen ID of your X server (typically 0)
> 
>      example KSH/BASH:
>         $ DISPLAY=207.71.117.101:0.0; export DISPLAY
> 
>      example CSH:
>         % setenv DISPLAY 207.71.117.101:0.0
> 
>    2. from the same session where you set DISPLAY run xclock as a test
>       you should be able to see XCLOCK windows on your PC
> 
> Let me know If this doesn't work -- I'll try to install CYGWIN on my PC and 
> test it here.
> 
> - Vitaliy

Hello Vitaliy,

Thank you for your very kind attention, reply and information.
I will test... and I will post the results here.

Regards,


mson77

Sounds good!

Talk to you tomorrow - time to sleep it's midnight here :-)

- Vitaliy

> Sounds good!
> 
> Talk to you tomorrow - time to sleep it's midnight here :-)
> 
> - Vitaliy

And it is 04:00AM here...  :-) (Brazil)

Thank you.


mson77

I got a chance to test Cygwin-X today - it worked fine, a bit slow over SSH 
tunnel but it works as far as I can tell.  Here's a write up I put together:

Download And Run:
   http://cygwin.com/setup.exe

At the "Cygwin Setup" screen click Next
   
   (o) install from the internet
   click Next
   
   Root Directory: C:\cygwin
   (o) All USERS (o) Unix / binary
   click Next
   
   Local Package Dir: C:\Program Files\cygwin
   click Next
   
   (o) Direct Connection
   click Next
   
   Download Site: select first one
   click Next
   
At the "Cygwin Packages" Window click Next
  runs for a while (30 minutes?)
  click Finish

Launch Cygwin-X:

   run C:\cygwin\usr\X11R6\bin\startxwin.bat

   (this should startup a white window on your PC)

At this point your Xterm is ON and you can start serving remote clients. There 
are two options you have:

open Putty create new 
SSH session and setup X11 Forwarding:

      Connection -> 
         SSH ->
            Tunnels
               [x] Enable X11 forwarding
               X display location: localhost:0.0

on the linux server make sure that X11 tunneling is enabled by sshd

         bash-2.05# pwd
         /opt/OBSDssh/etc
         bash-2.05# cat ssh_config
         Host *
            ForwardAgent yes
            ForwardX11 yes
            VerifyHostKeyDNS yes

      you might be able to use this instead of VerifyHostKeyDNS?:

            X11UseLocalhost yes


connect to the host and make sure DISPLAY is set to:

         callisto.portal-> echo $DISPLAY
         localhost:10.0

      NOTE: SSH automatically sets up DISPLAY to localhost:10.0 OR
            localhost:11.0 or localhost:12.0 depending on how many
            users have Xforwarding enabled and on the system

test XTERM by running xclock which should pop-up on your PC

Once you have xclock working you can now run Oracle Installer.  Just remember 
that SSH tunnel / X11 forwarding does not work if you SSH as root and then SU 
to oracle - you need to SSH as oracle in the first place.

Alternatively you can skip SSH tunnel / X11 forwarding if both PC and Linux 
boxes are on the same network and can talk to each other directly, to do this 
simply startup Xterm on your PC:

Launch Cygwin-X:

   run C:\cygwin\usr\X11R6\bin\startxwin.bat

   (this should startup a white window on your PC)

then SSH or TELNET to linux box SU to oracle and export DISPLAY to your PC's 
ip_Addr:0.0, example:

  # su - oracle
  $ DISPLAY=207.71.117.177:0.0;export DISPLAY
  $ xclock

- Vitaliy

I forgot to mention that if you use Option #2 you will need to add your linux 
box's IP address/name to your XTERM's access list, here's how to do it:

From the Xterm window allow linux host to run on your xterm:
 
   $ /usr/X11R6/bin/xhost linuxhost
   linuxhost being added to access control list

Hello Vitaliy,

Brilliant! Perfect!

It worked at first try!

Deeply thankful!
Regards,


mson77

No problem, I am glad it worked!

Short , sweet and crisp.
Just the kind of instructions i was looking for.
Thanks for taking time to share it with others.