Oracle Sys.aud$ table registering wrong entry for userhost

Posted on 2012-09-11
Last Modified: 2013-01-22
I am running an Oracle 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?
Question by:Alex Matzinger
    LVL 3

    Expert Comment

    check the terminal value for the auditing

    SYS @ oracle >col COMMENT$TEXT for a60

    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.
    LVL 16

    Expert Comment

    by:Wasim Akram Shaik
    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..!!!
    LVL 5

    Expert Comment

    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.
    LVL 4

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now