0 Replies Latest reply: Dec 18, 2012 12:57 PM by Roger25 RSS

    testing network data encryption

    Roger25
      Hi,
      My sqlnet.ora file contains also:
      TRACE_LEVEL_CLIENT = SUPPORT
      
      TRACE_DIRECTORY_CLIENT = c:\temp
      
      TRACE_FILE_CLIENT = sqlnet_encryption.trc
      
      SQLNET.ENCRYPTION_TYPES_CLIENT= (AES256, AES192)
      
      SQLNET.ENCRYPTION_TYPES_SERVER= (3DES168)
      
      DIAG_ADR_ENABLED = OFF
      I want to test the network encryption. I have issued a select within hr schema (select * from employees), but when i access that .trc file, i can see it contains:
      ...
      [18-DEC-2012 20:51:04:002] naeecom: entry
      [18-DEC-2012 20:51:04:002] naeecom: Encryption inactive[18-DEC-2012 20:51:04:002] naeecom: exit
      [18-DEC-2012 20:51:04:002] naeccom: entry
      [18-DEC-2012 20:51:04:002] naeccom: Crypto-Checksumming inactive[18-DEC-2012 20:51:04:002] naeccom: exit
      [18-DEC-2012 20:51:04:002] na_tns: entry
      [18-DEC-2012 20:51:04:002] na_tns: Secure Network Services is available.
      [18-DEC-2012 20:51:04:002] nau_adi: entry
      [18-DEC-2012 20:51:04:002] nau_adi: exit
      [18-DEC-2012 20:51:04:002] na_tns:      authentication is active, using NTS
      [18-DEC-2012 20:51:04:002] na_tns:      encryption is not active
      [18-DEC-2012 20:51:04:002] na_tns:      crypto-checksumming is not active
      ...
      I want to know why it says encryption is not active, if i used Net Manager to specify encryption algorithms for both server and client.
      I have also restarted the database (shutdown / startup), with no effect (same 'encryption inactive').

      Thanks