ORA-28367: wallet does not exist When Opening TDE Wallet

SYMPTOMS

On 11gR1 or 11gR2, when executing "ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY <password>", the following error is observed:


ORA-28367: wallet does not exist
 (On 12c, the "ADMINISTER KEY MANAGEMENT" commands are used instead.)

CAUSE

In the sqlnet.ora, ENCRYPTION_WALLET_LOCATION is formatted incorrectly.  Specifically, there is no indentation; the entry had multiple lines, but no whitespace.  For example:

ENCRYPTION_WALLET_LOCATION=
(SOURCE=
(METHOD=FILE)
(METHOD_DATA=
(DIRECTORY=/u01/app/oracle/product/11.2.0/network/admin)))

SOLUTION

Modify the sqlnet.ora so that everything is either on one line, or use indentation (whitespace) as follows:

ENCRYPTION_WALLET_LOCATION=
   (SOURCE=
   (METHOD=FILE)
   (METHOD_DATA=
   (DIRECTORY=/u01/app/oracle/product/11.2.0/network/admin)))

Reference : "ORA-28367: wallet does not exist" When Opening TDE Wallet (Doc ID 809763.1)