Configuring ORACLE IADB with Oracle Advanced Security setup.

Answer

To setup IADB with Oracle Advanced Security enabled we need to follow following steps :

1. Enable Oracle Advanced Security on Server side using following steps :

(a). Navigate to the Oracle Advanced Security profile using Oracle Net Manager .

(b). Click the Encryption tab.

(c). Select CLIENT or SERVER option from the Integrity box.

(d). From the Encryption Type list, select one of the following:

REQUESTED

REQUIRED

ACCEPTED

REJECTED

(e). (Optional) In the Encryption Seed field, enter between 10 and 70 random characters. The encryption seed for the client should not be the same as that for the server.

(f). Select an encryption algorithm in the Available Methods list. Move it to the Selected Methods list by choosing the right arrow (>). Repeat for each additional method you want to use.

(g). Select File, Save Network Configuration. The sqlnet.ora file is updated.

(h). Repeat this procedure to configure encryption on the other system. The sqlnet.ora file on the two systems should contain the following entries:

On the server:

SQLNET.ENCRYPTION_SERVER = [accepted | rejected | requested | required]
SQLNET.ENCRYPTION_TYPES_SERVER = (valid_encryption_algorithm [,valid_encryption_algorithm])

On the client:

SQLNET.ENCRYPTION_CLIENT = [accepted | rejected | requested | required]
SQLNET.ENCRYPTION_TYPES_CLIENT = (valid_encryption_algorithm [,valid_encryption_algorithm])





2.Change IADB ODBC DSN and add following additional options in existing DSN.

DataIntegrityLevel=1
DataIntegrityTypes=MD5
EncryptionLevel=1
EncryptionTypes=

Restart IADB .