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

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

Postby 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
Apparel21
 
Posts: 15
Joined: Mon 01 Sep 2008 01:55

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

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1936
Joined: Wed 02 Nov 2011 09:44

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

Postby 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

Postby Apparel21 » Wed 13 Apr 2016 01:10

Hi again,

Any news on whether this will be modified or not?

Cheers,
Jonathan
Apparel21
 
Posts: 15
Joined: Mon 01 Sep 2008 01:55

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

Postby 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: 1936
Joined: Wed 02 Nov 2011 09:44

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

Postby 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: 1936
Joined: Wed 02 Nov 2011 09:44

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

Postby 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 http://forums.devart.com/viewtopic.php?t=34384
Pinturiccio
Devart Team
 
Posts: 1936
Joined: Wed 02 Nov 2011 09:44

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

Postby Apparel21 » Mon 07 Nov 2016 04:20

Fantastic, thanks for the update!
Apparel21
 
Posts: 15
Joined: Mon 01 Sep 2008 01:55


Return to dotConnect for Oracle