Home » SQL & PL/SQL » SQL & PL/SQL » Server with two IP Address (SAN, LAN) (oracle 10g, windows XP)
Server with two IP Address (SAN, LAN) [message #439219] Fri, 15 January 2010 00:25 Go to next message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
dear all
I am using this command... to get the name of machine

select UTL_INADDR.Get_Host_Name('IP Address...') from dual;

it is accurately replying me machine name.
but my server is configured on SAN along with LAN.

so my server has two IP addresses. and when i try to get the IP address through name of server .....

select UTL_INADDR.Get_Host_Address('Machine Name ...') from dual;

it simply returns me SAN ip address but i need LAN ip address

how can I get????

Regards.
Re: Server with two IP Address (SAN, LAN) [message #439220 is a reply to message #439219] Fri, 15 January 2010 00:44 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Please post the output for this command
SELECT UTL_INADDR.get_host_address from dual;


sriram Smile
Re: Server with two IP Address (SAN, LAN) [message #439221 is a reply to message #439219] Fri, 15 January 2010 00:49 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>how can I get????
select machine from sid = 1

Re: Server with two IP Address (SAN, LAN) [message #439223 is a reply to message #439220] Fri, 15 January 2010 01:24 Go to previous messageGo to next message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
ramoradba wrote on Fri, 15 January 2010 00:44
Please post the output for this command
SELECT UTL_INADDR.get_host_address from dual;


sriram Smile


--output--
172.17.0.29


it is getting IP address of SAN configuration, where as my server has another IP address configured on LAN. and I want LAN IP Address.

point to remember --- my server is configured on SAN and LAN... two configuration need two IP addresses....
and I am getting only one IP address and I need the second IP Address.

thanks for responce.
Regards.
Re: Server with two IP Address (SAN, LAN) [message #439224 is a reply to message #439221] Fri, 15 January 2010 01:26 Go to previous messageGo to next message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
BlackSwan wrote on Fri, 15 January 2010 00:49
>how can I get????
select machine from sid = 1



can you please tell me the accurate query? and I need IP address not machine name.

regards.
Re: Server with two IP Address (SAN, LAN) [message #439225 is a reply to message #439219] Fri, 15 January 2010 01:27 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
it simply returns me SAN ip address but i need LAN ip address

how can I get????

Oracle can only return one of the addresses, if your server has 2 or more IP addresses there is no way to get the other ones unless you put a different name for each address and use it in UTL_INADDR.

Regards
Michel
Previous Topic: internal error code
Next Topic: How to reduce the column length (CHAR) ? [split topic TG]
Goto Forum:
  


Current Time: Sun Dec 04 22:45:58 CST 2016

Total time taken to generate the page: 0.12324 seconds