Home » RDBMS Server » Server Administration » v$session issue (10.2.0.1, Windows 2003)
v$session issue [message #379251] Mon, 05 January 2009 12:25 Go to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Hi all,

Happy New year!!

We have a function called gosuser, which basically gets the osuser from v$session. Our client has reported a problem that when they run select gosuser from dual, they get domain\username in their live database. But in their test database they only get the username. Both databases reside on the same server. Since our application does not support '\', we have a constraint for a column that is getting the value from the gosuser function.

One of the option here will be to drop the constraint to allow '\' for that column. But, does anyone know why we get two different values, when both the databases reside on the same server?? Could it be some OS configuration or will it be a database setting??

Thank you.
Re: v$session issue [message #379254 is a reply to message #379251] Mon, 05 January 2009 12:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same version?
Same Oracle home?

Regards
Michel
Re: v$session issue [message #379255 is a reply to message #379251] Mon, 05 January 2009 12:30 Go to previous messageGo to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Yes, Michael. Same version and same Oracle_homes.
Re: v$session issue [message #379259 is a reply to message #379255] Mon, 05 January 2009 13:09 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, something MUST be different between the two.

Maybe you could try to pin down the problem, and see where the difference starts to show up. What is the result of these both from test and production:

From the Windows command prompt on the client :

set


from SQLPlus on the client :

SELECT sys_context('USERENV', 'OS_USER') FROM dual;

select banner from v$version;


and look for differences there.
Re: v$session issue [message #379263 is a reply to message #379255] Mon, 05 January 2009 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sant_new wrote on Mon, 05 January 2009 19:30
Yes, Michael. Same version and same Oracle_homes.

Both connected from same client?

Regards
Michel

Re: v$session issue [message #379264 is a reply to message #379251] Mon, 05 January 2009 13:54 Go to previous messageGo to next message
sant_new
Messages: 165
Registered: June 2008
Senior Member
Yes, Both were connecting from the same client versions.
Re: v$session issue [message #379317 is a reply to message #379264] Tue, 06 January 2009 00:59 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Remote or local connections?

Regards
Michel
Previous Topic: impact of deleting rows on table
Next Topic: Issues with Trace
Goto Forum:
  


Current Time: Sat Dec 03 12:18:49 CST 2016

Total time taken to generate the page: 0.10814 seconds