Home » RDBMS Server » Server Administration » Changing web IP address(2 Merged)
Changing web IP address(2 Merged) [message #512886] Wed, 22 June 2011 13:12 Go to next message
rihad
Messages: 7
Registered: June 2011
Location: Baku
Junior Member
Hello, I'm a total Oracle newb trying to get oracle-xe-universal_10.2.0.1-1.0_i386.deb rolling on Debian/6.0.1a which coincidentally is on another server, not on my desktop, so I obviously can't reach the web frontend at 127.0.0.1:8080. And I couldn't trick it with a simple TCP proxy on the server:
nc -l -p 80 127.0.0.1 8080

and then on the client:
telnet 192.168.0.252 80

bailed out with an error
invalid connection to [192.168.0.252] from (UNKNOWN) [192.168.0.1] 35798


So, is there a way to change the listening IP address, or to allow IPs other than the local host to connect?

I've tried some googling around, but no one except me seemed puzzled with such an issue.

Report message to a moderator

Re: Changing web IP address [message #512888 is a reply to message #512886] Wed, 22 June 2011 13:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
The DB Server system must be configured with an IP# that is route-able.
This really has nothing to do with Oracle RDBMS.
It Networking Basics 101.

Report message to a moderator

Re: Changing web IP address [message #512889 is a reply to message #512888] Wed, 22 June 2011 13:24 Go to previous messageGo to next message
rihad
Messages: 7
Registered: June 2011
Location: Baku
Junior Member
But I don't remember the install ever asking me for the IP address, only port?

Report message to a moderator

Re: Changing web IP address [message #512890 is a reply to message #512889] Wed, 22 June 2011 13:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>But I don't remember the install ever asking me for the IP address, only port?
While above may be true, it does not change reality.
At OS level, network interface must be changed to have an IP# that is route-able.
Unless & until IP# changes, only processes already running on DB Server system can use network to exchange packets.
my laptop is configured as follows => (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
I do this to ensure that regardless of where I am, nobody can connect to my local DB.

[Updated on: Wed, 22 June 2011 13:31]

Report message to a moderator

Re: Changing web IP address [message #512892 is a reply to message #512890] Wed, 22 June 2011 13:43 Go to previous messageGo to next message
rihad
Messages: 7
Registered: June 2011
Location: Baku
Junior Member
Huh? Does all this have anything to do with me not being able to talk to 127.0.0.1 on another computer?
I suppose there is no easy way to change the IP Oracle's web server listens on, or allows connections from?

Report message to a moderator

Re: Changing web IP address [message #512895 is a reply to message #512892] Wed, 22 June 2011 13:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Huh? Does all this have anything to do with me not being able to talk to 127.0.0.1 on another computer?
127.0.0.1 is a non-route-able IP#. By definition it is always local system itself.
127.0.0.1 is ALWAYS the originating system itself.

>I suppose there is no easy way to change the IP Oracle's web server listens on, or allows connections from?
Oracle uses what ever IP# is configured for host OS.
Oracle can run well without any external or network interface.

If you expect/desire to use network to access DB Server from remote client,
then DB Server network interface must be configured with route-able IP#.
Accept reality & stop whining!

Report message to a moderator

Re: Changing web IP address [message #512900 is a reply to message #512895] Wed, 22 June 2011 14:00 Go to previous messageGo to next message
rihad
Messages: 7
Registered: June 2011
Location: Baku
Junior Member
I can't believe this... I guess I'll wait for someone else to help me with my question, or maybe they'll tell me the same thing you said but in the terms I could understand, sorry but I cannot make sense of what you're saying.

Oh, if this wasn't obvious, there IS a routeable address 192.168.0.252, that the installer didn't bother using.

[Updated on: Wed, 22 June 2011 14:03]

Report message to a moderator

Re: Changing web IP address [message #512901 is a reply to message #512900] Wed, 22 June 2011 14:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://en.wikipedia.org/wiki/Localhost

Report message to a moderator

Re: Changing web IP address [message #512902 is a reply to message #512901] Wed, 22 June 2011 14:08 Go to previous messageGo to next message
rihad
Messages: 7
Registered: June 2011
Location: Baku
Junior Member
Oh, if this wasn't obvious, there IS a routeable address 192.168.0.252, that the installer didn't bother using.

Report message to a moderator

Re: Changing web IP address [message #512905 is a reply to message #512902] Wed, 22 June 2011 14:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Oh, if this wasn't obvious, there IS a routeable address 192.168.0.252
If you say so.
change the configuration to utilize IP# above, then problem will be solved.

Report message to a moderator

Re: Changing web IP address [message #512907 is a reply to message #512905] Wed, 22 June 2011 14:31 Go to previous messageGo to next message
rihad
Messages: 7
Registered: June 2011
Location: Baku
Junior Member
Quote:
change the configuration to utilize IP# above, then problem will be solved.

Brilliant!! And can you please tell me how to do that?
Hint: I'm new to Oracle.

Report message to a moderator

Re: Changing web IP address [message #512910 is a reply to message #512907] Wed, 22 June 2011 15:06 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=oracle+xe+change+ip+address

Report message to a moderator

Re: Changing web IP address [message #512962 is a reply to message #512910] Thu, 23 June 2011 01:58 Go to previous messageGo to next message
rihad
Messages: 7
Registered: June 2011
Location: Baku
Junior Member
Nevermind, problem solved. After much mucking around I could find no easy way to make Oracle listen on any other address than 127.0.0.1, or allow connections from anything other than 127.0.0.1, so a simple SSH tunnel did the trick for me:

Run on the client:
ssh -N -L 127.0.0.1:8080:127.0.0.1:8080 192.168.0.252

and then visit http://127.0.0.1:8080/apex - bingo, everything works!

Report message to a moderator

Re: Changing web IP address [message #512986 is a reply to message #512962] Thu, 23 June 2011 03:17 Go to previous message
cookiemonster
Messages: 13921
Registered: September 2008
Location: Rainy Manchester
Senior Member
Thanks for letting us know.

Report message to a moderator

Previous Topic: Privileges for DROP partition
Next Topic: convert global index to local index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 02 07:15:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.