OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » application hostname (oracle 10g,linux)

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

application hostname [message #452590]

Thu, 22 April 2010 22:29

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 ?

Report message to a moderator

Re: application hostname [message #452592 is a reply to message #452590]

Thu, 22 April 2010 22:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SELECT MACHINE FROM V$SESSION;

but will be less than useful in 3-tier application

Report message to a moderator

Re: application hostname [message #452597 is a reply to message #452592]

Thu, 22 April 2010 23:35

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.

Report message to a moderator

Re: application hostname [message #452598 is a reply to message #452597]

Thu, 22 April 2010 23:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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/

Report message to a moderator

Re: application hostname [message #452602 is a reply to message #452598]

Thu, 22 April 2010 23:52

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;

Report message to a moderator

Re: application hostname [message #452604 is a reply to message #452602]

Thu, 22 April 2010 23:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>this is the output of select * from v$session;
duly underwhelming & not what was requested

Report message to a moderator

Re: application hostname [message #452607 is a reply to message #452604]

Fri, 23 April 2010 00:03

vinodraj4u@gmail.com
Messages: 15
Registered: January 2010
Location: bangalore

Junior Member

os name: hcid004
db server :RHEL5
oracle version:10.2.0.4

Report message to a moderator

Re: application hostname [message #452613 is a reply to message #452590]

Fri, 23 April 2010 00:45

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.

Report message to a moderator

Re: application hostname [message #452710 is a reply to message #452613]

Fri, 23 April 2010 08:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Previous Topic:	TNS ERROR
Next Topic:	IP address settings

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 08 13:38:36 CST 2025