| 10g plus Fedora7 only text mode server installed [message #262926] |
Tue, 28 August 2007 09:03  |
mson77
Messages: 208
Registered: August 2007
Location: Brazil
|
Senior Member |
|
|
Hello ALL,
I was reading this topic:
http://www.orafaq.com/forum/?t=rview&goto=260444#msg_num_11
And I have been surprised when ThomasG wrote about installing and managing Oracle on a text-based only linux server:
| ThomasG | Basicly yes, but ...
- Java is present on the installation media, so you don't have to install it beforehand.
- The XWindow environment doesn't have to be on the server itself, you can connect with ssh/telnet from a remote workstation which has X installed, and use that X Server (Either a *nix box or MS Windows with Cygwin, Exceed or some other X server running)
|
Then... my understanding is:
1) having a fedora box with text-installed mode only;
2) having a remote workstation with X Server installed;
May I use X Server from remote workstation to connect to fedora text box and install oracle?
3) What are the basic requirements on text-fedora7 to have oracle installed on it?
4) Does anyone may point me a tutorial/url to accomplish this task?
Thank you,
mson77
[Updated on: Tue, 28 August 2007 09:13] Report message to a moderator |
|
|
|
| Re: 10g plus Fedora7 only text mode server installed [message #266108 is a reply to message #262926] |
Sun, 09 September 2007 15:32  |
mson77
Messages: 208
Registered: August 2007
Location: Brazil
|
Senior Member |
|
|
Hello ALL,
Regarding this subject... I got the answer at:
http://dbatoolz.orapros.com/tp/2601.remote_installing_oracle_on_fedora7text-server.html
| Quote: | 2007-SEP-08 14:26:15
Mson77dba
User
Upload Files
Registered On: Sep 2007
Total Posts: 4
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
8209
2007-SEP-08 23:44:55
Vmogilev
Moderator
Registered On: Mar 2006
Total Posts: 110
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
[edited by: Vmogilev at 23:45 (PST) on Sep. 08, 2007]
8210
2007-SEP-08 23:49:34
Mson77dba
User
Upload Files
Registered On: Sep 2007
Total Posts: 4
> 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
8212
2007-SEP-08 23:53:00
Vmogilev
Moderator
Registered On: Mar 2006
Total Posts: 110
Sounds good!
Talk to you tomorrow - time to sleep it's midnight here 
- Vitaliy
8213
2007-SEP-08 23:54:59
Mson77dba
User
Upload Files
Registered On: Sep 2007
Total Posts: 4
> Sounds good!
>
> Talk to you tomorrow - time to sleep it's midnight here
>
> - Vitaliy
And it is 04:00AM here... (Brazil)
Thank you.
mson77
8216
2007-SEP-09 12:11:39
Vmogilev
Moderator
Registered On: Mar 2006
Total Posts: 110
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:
Option #1 - SSH Tunnel
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.
Option #2 - manually export DISPLAY
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
8217
2007-SEP-09 12:31:17
Vmogilev
Moderator
Registered On: Mar 2006
Total Posts: 110
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
8220
2007-SEP-09 13:17:14
Mson77dba
User
Upload Files
Registered On: Sep 2007
Total Posts: 4
Hello Vitaliy,
Brilliant! Perfect!
It worked at first try!
Deeply thankful!
Regards,
mson77
|
Again... I am deeply thankful to Vitaliy.
Hope this been useful.
Regards,
mson77
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
