OraFAQ Forum: Weblogic & Application Server » How to get ip/host form server application

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » How to get ip/host form server application (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get ip/host form server application [message #396589]

Tue, 07 April 2009 05:17

Theracersman
Messages: 28
Registered: November 2007
Location: Indonesia

Junior Member

hi all,

i'm using application server with 10g with load balancer,and than i have concurrent report.so i have problem to get ip server machine,i need help how to get ip/ host server machine form application.

regards,
Theracersman

Report message to a moderator

Re: How to get ip/host form server application [message #396730 is a reply to message #396589]

Tue, 07 April 2009 19:24

andrew again
Messages: 2577
Registered: March 2000

Senior Member

for your particular session, you can get some details from session view:

select *
  FROM v$session
where sid = ( select sid from v$mystat where rownum = 1 );

Sounds like you want something from the CGI environment though - try calling owa_util.print_cgi_env from the web to see CGI env passed to the pl/sql gateway

Report message to a moderator

Re: How to get ip/host form server application [message #396742 is a reply to message #396730]

Tue, 07 April 2009 22:46

Theracersman
Messages: 28
Registered: November 2007
Location: Indonesia

Junior Member

dear andrew,

your query cannot find ip machine server,cause i want to get ip machine server.

regards,
Theracersman

Report message to a moderator

Re: How to get ip/host form server application [message #397188 is a reply to message #396742]

Thu, 09 April 2009 05:52

babuknb
Messages: 1734
Registered: December 2005
Location: NJ

Senior Member

Try

select sys_context('USERENV','IP_ADDRESS') FROM DUAL;

Babu

Report message to a moderator

Re: How to get ip/host form server application [message #397582 is a reply to message #397188]

Sun, 12 April 2009 22:41

Theracersman
Messages: 28
Registered: November 2007
Location: Indonesia

Junior Member

i needed,host server not client..

Report message to a moderator

Re: How to get ip/host form server application [message #397594 is a reply to message #397582]

Sun, 12 April 2009 23:49

andrew again
Messages: 2577
Registered: March 2000

Senior Member

You are trying to get HTTP server address? Load balance address? database server address?

Report message to a moderator

Re: How to get ip/host form server application [message #397665 is a reply to message #396589]

Mon, 13 April 2009 03:57

Theracersman
Messages: 28
Registered: November 2007
Location: Indonesia

Junior Member

how to get http address with query language?

Report message to a moderator

Previous Topic:	OLAP Queries
Next Topic:	Installing Oracle HTTP Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 07 13:42:41 CDT 2020