This discussion is archived
0 Replies Latest reply: Dec 18, 2012 10:57 AM by Roger25 RSS

testing network data encryption

Roger25 Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points