OraFAQ Forum: Server Administration » Blank username in v$session , How to find who is connecting

Home » RDBMS Server » Server Administration » Blank username in v$session , How to find who is connecting (Oracle 11.2.0.4) (

) 1 Vote

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

Blank username in v$session , How to find who is connecting [message #678006]

Wed, 30 October 2019 09:12

Akmmhto
Messages: 38
Registered: September 2018

Member

Dear team,

In QA DB server , Today I got ORA-00020

Check and found too many active sessions from v$session.

The question is that the username column is blank.

Program - JDBC Thin Client

OSUSER - pqadmn

Since our sys and system users are in locked state.

Hence I am unable to find the real culprit.

Audit trail is not showing any login information and only filled with ora-01017

Attaching some logs

Attachment: Log_301019.txt
(Size: 21.10KB, Downloaded 2564 times)

Report message to a moderator

[Message index]

		Blank username in v$session , How to find who is connecting By: Akmmhto on Wed, 30 October 2019 09:12
		Re: Blank username in v$session , How to find who is connecting By: cookiemonster on Wed, 30 October 2019 09:22
		Re: Blank username in v$session , How to find who is connecting By: BlackSwan on Wed, 30 October 2019 09:45
		Re: Blank username in v$session , How to find who is connecting By: Akmmhto on Sat, 09 November 2019 02:34
		Re: Blank username in v$session , How to find who is connecting By: Akmmhto on Sat, 09 November 2019 02:38
		Re: Blank username in v$session , How to find who is connecting By: John Watson on Sat, 09 November 2019 02:55
		Re: Blank username in v$session , How to find who is connecting By: Akmmhto on Sat, 09 November 2019 03:16
		Re: Blank username in v$session , How to find who is connecting By: John Watson on Sat, 09 November 2019 03:44
		Re: Blank username in v$session , How to find who is connecting By: Akmmhto on Sat, 09 November 2019 04:08
		Re: Blank username in v$session , How to find who is connecting By: Michel Cadot on Wed, 30 October 2019 10:33
		Re: Blank username in v$session , How to find who is connecting By: John Watson on Wed, 30 October 2019 12:45
		Re: Blank username in v$session , How to find who is connecting By: Akmmhto on Wed, 30 October 2019 14:24
		Re: Blank username in v$session , How to find who is connecting By: BlackSwan on Wed, 30 October 2019 15:23

Previous Topic:	Add new data file or extend existing data files ?
Next Topic:	Object change from valid to invalid

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 09:06:22 CDT 2024