1 Reply Latest reply: Nov 20, 2013 1:33 PM by Alex.Keh .Product.Manager-Oracle RSS

    CLIENT_IDENTIFIER  is always empty in sessions

    user11995598

      We are using a  asp.net web application with one common connection string so we want to set clientid property of OracleConnection to distinct connections.

       

      We use 11.2.0.3 Oracle Database Server and Oracle.DataAccess Client x64 (4.112.3.0) for .NET.

       

      This is the code:

       

        string oracleConnString = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.XXX.XXX.XX)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)));User Id=scott;Password=tiger;";

              

        OracleConnection oracleConn = new OracleConnection(oracleConnString);

       

        oracleConn.Open();

       

        oracleConn.ClientId = "SpyrusTheDragon";

             

      --At this point I can see that the connection is open but CLIENT_IDENTIFIER remains null in database:

       

      SELECT username, client_identifier FROM v$session where username='scott';

       

      --------------------------------------------

       

      Any help?