Home » RDBMS Server » Networking and Gateways » application hostname (oracle 10g,linux)
icon4.gif  application hostname [message #452590] Thu, 22 April 2010 22:29 Go to next message
vinodraj4u@gmail.com
Messages: 15
Registered: January 2010
Location: bangalore
Junior Member

hi all,

i got to find out the users hostname who are connecting to databse through remote,i tried with v$session bt it is showing null values in the terminal column.how to find out ?
Re: application hostname [message #452592 is a reply to message #452590] Thu, 22 April 2010 22:35 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
SELECT MACHINE FROM V$SESSION;

but will be less than useful in 3-tier application
Re: application hostname [message #452597 is a reply to message #452592] Thu, 22 April 2010 23:35 Go to previous messageGo to next message
vinodraj4u@gmail.com
Messages: 15
Registered: January 2010
Location: bangalore
Junior Member

bt terminal column showing null values.what values will present in these columns.if try the same thing in windows platform machine im getting the values for terminal.what is the reason behind this?how can get those values in linux platform oracle database.
Re: application hostname [message #452598 is a reply to message #452597] Thu, 22 April 2010 23:38 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
ALWAYS
Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: application hostname [message #452602 is a reply to message #452598] Thu, 22 April 2010 23:52 Go to previous messageGo to next message
vinodraj4u@gmail.com
Messages: 15
Registered: January 2010
Location: bangalore
Junior Member

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production


this is the output of select * from v$session;
Re: application hostname [message #452604 is a reply to message #452602] Thu, 22 April 2010 23:54 Go to previous messageGo to next message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
>this is the output of select * from v$session;
duly underwhelming & not what was requested

Re: application hostname [message #452607 is a reply to message #452604] Fri, 23 April 2010 00:03 Go to previous messageGo to next message
vinodraj4u@gmail.com
Messages: 15
Registered: January 2010
Location: bangalore
Junior Member

os name: hcid004
db server :RHEL5
oracle version:10.2.0.4
Re: application hostname [message #452613 is a reply to message #452590] Fri, 23 April 2010 00:45 Go to previous messageGo to next message
vinodraj4u@gmail.com
Messages: 15
Registered: January 2010
Location: bangalore
Junior Member

i got the value what i wanted in the machine column
thank you,but here we are using application,i want to know the user who connects from the application,both terminal and program column values showing null for the session created from the application.
Re: application hostname [message #452710 is a reply to message #452613] Fri, 23 April 2010 08:58 Go to previous message
BlackSwan
Messages: 22901
Registered: January 2009
Senior Member
>>i got to find out the users hostname who are connecting to databse
>i got the value what i wanted in the machine column
>thank you,but here we are using application,i want to know the user

Changing requirements!

Oracle RDBMS can not control application & can not control client.

If you require application username, then application code needs to make that available by calling DBMS_APPLICATION_INFO.SET_CLIENT_INFO with needed data.

Previous Topic: TNS ERROR
Next Topic: IP address settings
Goto Forum:
  


Current Time: Tue Oct 21 12:22:46 CDT 2014

Total time taken to generate the page: 0.10036 seconds