Re: Traffic capture : USER=oracle

Hi,

I'm newbie with JDBC -> Oracle connection and I found the following information :

Java use something like this to connect to Oracle : ("jdbc:oracle:thin:@myhost:1521:my_SID", "username", "password");

So I find these informations into the listener.log.

But I always do not understand the string "(USER=oracle)" into the listener.log then I do not have any OS user with the name "oracle" neither on the client nor on server machine.

From where comes this OS user "oracle" ?

When I use Sql*Plus to connect to my Oracle Database I can read "USER=my_OS_user" into listener.log where "my_OS_user" is the OS account I use to login on my client machine.

marcel.fleury_at_bluewin.ch (Fleury Marcel) wrote in message news:<f18358b2.0211290332.72cfc60b_at_posting.google.com>...
> But no OS user with the name "oracle" is defined onto my database server.
>
> Strange, isnt'it ?
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3de618cd$0$711$ed9e5944_at_reading.news.pipex.net>...
> > Assuming this comes from listener.log it is the OS username.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> > "Fleury Marcel" <marcel.fleury_at_bluewin.ch> wrote in message
> > news:f18358b2.0211280330.5f2c40d8_at_posting.google.com...
> > > Hello,
> > >
> > > I captured the trafic during a connection to my database.
> > >
> > > Here is a part of the informations :
> > >
> > > ... (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc___)(USER=oracle)) ...
> > >
> > > Question :
> > >
> > > No user "oracle" is defined into my database.
> > >
> > > Can anybody tell me who is this user oracle in (USER=oracle)
> > >
> > > Thank you
> > >
> > > Marcel
Received on Fri Nov 29 2002 - 16:32:50 CST