Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 780
  • Last Modified:

Oracle Sys.aud$ table registering wrong entry for userhost

Hello,
I am running an Oracle 11.2.0.1 database on a solaris system.  I am using the system auditing to monitor a couple of tables in my database.

My question is about the USERHOST entry in the sys.aud$ table.  For some reason, instead of registering the actual userhost(i.e. my machine name).  all it says is 'jdbcclient'.  I've verified that my machine is named correctly, so I'm slightly confused on where 'jdbcclient' is coming from.

Does anyone know where Oracle gets the USERHOST information, and why it wouldn't be registering the correct name?
0
Alex Matzinger
Asked:
Alex Matzinger
1 Solution
 
martin_seaCommented:
check the terminal value for the auditing

SYS @ oracle >col COMMENT$TEXT for a60
SYS @ oracle >select SESSIONID,USERID,TERMINAL,LOGOFF$TIME,COMMENT$TEXT from aud$;


Rem: in aud$

The host name of the machine from which the user logged on. In Windows, it is null.

The terminal of the host machine from where the user logged on. In Windows, it is the machine name.
0
 
Wasim Akram ShaikCommented:
incase the user is accessing the database via a jdbc connection not directly via the user name or any db interface then it would appear as jdbc thin client.. coz its the client which is directly interacting with the db.. not the user itself..!!!
0
 
AnandCommented:
audit tools will aid in this type of situation. they will capture the user information also and co-relate with jdbc client and displays the full information. native audit features are not sophisticated enough like third party audit tools.
0
 
Alex MatzingerAuthor Commented:
This is kinda a late entry.  We discovered that our database had lost connections with its DNS entries, and therefore had no clue who was talking to it, other than the most basic info.  Once it was able to get to the DNS entries again, the correct names and servers are being recorded again.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now