Direct Mode does not supply domain name in V$SESSION.MACHINE column

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Apparel21
Posts: 15
Joined: Mon 01 Sep 2008 01:55

Direct Mode does not supply domain name in V$SESSION.MACHINE column

Post by Apparel21 » Tue 15 Mar 2016 03:02

Hi everyone,

In our applications we typically use a non-direct method of connecting, and the MACHINE column of V$SESSION is correctly populated with the domain and terminal, as below:

Code: Select all

var oracleConnection1 = new OracleConnection();
oracleConnection1.Direct = false;
oracleConnection1.Server = "DEV";
oracleConnection1.UserId = "MYSCHEMA";
oracleConnection1.Password = "xxx";
MACHINE = 'MYDOMAIN\MYLAPTOP'
However when I use Direct Mode the MACHINE column just has the terminal name:

Code: Select all

oracleConnection2.Direct = true;
oracleConnection2.Server = "Server01";
oracleConnection2.Port = 1521;
oracleConnection2.Sid = "DEV";
oracleConnection2.UserId = "MYSCHEMA";
oracleConnection2.Password = "xxx";
oracleConnection2.Open();
MACHINE = 'MYLAPTOP'
Additionally, I also noticed that the process was 00000:00000.

We are unable to use the non-direct mode in this particular case, but we rely on the values in the MACHINE column for other processes.

Does anyone know any workarounds or fixes? We're running C# against Devart.Data.Oracle.dll v 8.5.602.0.

Thanks,
Jonathan

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Post by Pinturiccio » Tue 15 Mar 2016 13:51

Currently this is a normal behavior, and dotConnect for Oracle does not support output of the domain to the "machine" column and output of the "process" column values in the Direct mode. We will investigate the possibility to support domains for the "machine" column and values for the "process" column in the Direct mode and post here about the results as soon as possible.

Apparel21
Posts: 15
Joined: Mon 01 Sep 2008 01:55

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Post by Apparel21 » Wed 16 Mar 2016 01:36

Thanks for the quick reply! I look forward to hearing how it goes.

Apparel21
Posts: 15
Joined: Mon 01 Sep 2008 01:55

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Post by Apparel21 » Wed 13 Apr 2016 01:10

Hi again,

Any news on whether this will be modified or not?

Cheers,
Jonathan

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Post by Pinturiccio » Wed 13 Apr 2016 14:14

We are investigating the issue and will notify you about the result as soon as possible, but we can't tell any timeframe at the moment.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Post by Pinturiccio » Wed 05 Oct 2016 13:04

We have supported the output of the domain to the "machine" column and output of the "process" column values in the Direct mode. We will post here when the corresponding build of dotConnect for Oracle is available for download.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Post by Pinturiccio » Thu 06 Oct 2016 15:24

New build of dotConnect for Oracle 9.1.121 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=34384

Apparel21
Posts: 15
Joined: Mon 01 Sep 2008 01:55

Re: Direct Mode does not supply domain name in V$SESSION.MACHINE column

Post by Apparel21 » Mon 07 Nov 2016 04:20

Fantastic, thanks for the update!

Post Reply