My Oracle Support Banner

ENCRYPTION_WALLET_LOCATION Not Configured In Sqlnet.ora In Alert.log (Doc ID 2868389.1)

Last updated on MARCH 05, 2023

Applies to:

Advanced Networking Option - Version 19.15.0.0.0 and later
Information in this document applies to any platform.

Symptoms

After an upgrade database from 19.11 to  19.15  following messages arise in alert-log file

2022-05-04T19:17:03.778165+02:00
ENCRYPTION_WALLET_LOCATION not configured in sqlnet.ora
ENCRYPTION_WALLET_LOCATION not configured in sqlnet.ora
ENCRYPTION_WALLET_LOCATION not configured in sqlnet.ora
ENCRYPTION_WALLET_LOCATION not configured in sqlnet.ora
ENCRYPTION_WALLET_LOCATION not configured in sqlnet.ora
ENCRYPTION_WALLET_LOCATION not configured in sqlnet.ora
2022-05-04T20:47:57.235353+02:00

Changes

 Database upgrade to 19.15 RU or fresh 19.15 installation.

IF TDE is not enabled BUT you are doing anyone of those actions mentioned below without configuring WALLET_ROOT then the message is expected because of mis-config even though there is no encrypted tablespaces.

If we remove that message then to debug TDE wallet issues, you have to explicitly  enable the debug event and reproduce the issue again.

DB would look for encryption_wallet_location or wallet_root to open the wallet and access the keys only if we try to access -

- TDE Views (v$encryption_wallet, v$encryption_keys)

- Try to use any 'Administer Key Management' command.

- Try to encrypt Data (column or tablespace)

- Try to read encrypted data if present.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.