Re: user= nobody in listener.log file

From: Fred Stojentin <stojentin_at_orgdv.din.de>
Date: 2000/04/06
Message-ID: <38ec86cb.19794036@news.cis.dfn.de>#1/1

On Wed, 05 Apr 2000 15:32:32 -0600, Sheng Jin <sheng.jin_at_ualberta.ca> wrote:

>When I checked the listener.log file, I found many these kind lines in
>it.
>05-APR-00 13:14:46 *
>(CONNECT_DATA=(SID=My_DB_Name)(CID=(PROGRAM=)(HOST=My_Server_Name)(USER=nobody)))
>* (ADDRESS=(PROTOCOL=tcp)(HOST=My_Sever_IP)(PORT=40673)) * establish *
>uarms * 0
>There is no account called "nobody" in our database. I don't know who
>want to access our database.

A user logged in as nobody on My_Server_Name had established a connection to the database My_DB_Name. In the logfile you cannot see the db_account name, but the system account name.

>Could anyone help to find out what's wrong with our database and how to
>correct this error?
>Thanks
>
>Sheng Jin
>

Look at v$session, column osuser="nobody" to find out which db_account is used.

I hope this helps a bit.

Fred Stojentin Received on Thu Apr 06 2000 - 00:00:00 CDT