My Oracle Support Banner

Setting up TDE_CONFIGURATION parameter in the spfile of a 19c database error with ORA-46693: The WALLET_ROOT location is missing or invalid. (Doc ID 2625496.1)

Last updated on OCTOBER 06, 2021

Applies to:

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

Symptoms

sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Dec 30 09:39:29 2019
Version 19.4.0.0.0

Copyright (c) 1982, 2019, Oracle. All rights reserved.

Enter user-name: /as sysdba

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.4.0.0.0

SQL> show parameter TDE_CONFIGURATION;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
tde_configuration string
SQL>
SQL>
SQL>
SQL> ALTER SYSTEM SET TDE_CONFIGURATION="KEYSTORE_CONFIGURATION=FILE" scope=both;
ALTER SYSTEM SET TDE_CONFIGURATION="KEYSTORE_CONFIGURATION=FILE" scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-46693: The WALLET_ROOT location is missing or invalid.

Changes

 Setting up TDE_CONFIGURATION parameter in the spfile of a 19c database to configure TDE

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.