Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » How to get ip/host form server application (10g)
How to get ip/host form server application [message #396589] Tue, 07 April 2009 05:17 Go to next message
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
Re: How to get ip/host form server application [message #396730 is a reply to message #396589] Tue, 07 April 2009 19:24 Go to previous messageGo to next message
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
Re: How to get ip/host form server application [message #396742 is a reply to message #396730] Tue, 07 April 2009 22:46 Go to previous messageGo to next message
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
Re: How to get ip/host form server application [message #397188 is a reply to message #396742] Thu, 09 April 2009 05:52 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Try

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


Babu
Re: How to get ip/host form server application [message #397582 is a reply to message #397188] Sun, 12 April 2009 22:41 Go to previous messageGo to next message
Theracersman
Messages: 28
Registered: November 2007
Location: Indonesia
Junior Member

i needed,host server not client..
Re: How to get ip/host form server application [message #397594 is a reply to message #397582] Sun, 12 April 2009 23:49 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You are trying to get HTTP server address? Load balance address? database server address?
Re: How to get ip/host form server application [message #397665 is a reply to message #396589] Mon, 13 April 2009 03:57 Go to previous message
Theracersman
Messages: 28
Registered: November 2007
Location: Indonesia
Junior Member

how to get http address with query language?
Previous Topic: OLAP Queries
Next Topic: Installing Oracle HTTP Server
Goto Forum:
  


Current Time: Thu Mar 28 20:31:03 CDT 2024