While configuring the Oracle TDE encryption with wallet getting the following error:

Error:

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.

Solution:

Before setting this parameter we need to set the WALLET_ROOT and restart the database for taking this WALLET_ROOT Parameter in effects.

SQL> ALTER SYSTEM SET WALLET_ROOT='E:\ORACLE\wallets\orcl' SCOPE=SPFILE;

System altered.


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.


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.

Total System Global Area 2550133384 bytes
Fixed Size                  9269896 bytes
Variable Size             553648128 bytes
Database Buffers         1979711488 bytes
Redo Buffers                7503872 bytes
Database mounted.
Database opened.
SQL>

SQL> ALTER SYSTEM SET TDE_CONFIGURATION="KEYSTORE_CONFIGURATION=FILE" SCOPE=BOTH;
System altered.