Fails To Open / Create The Wallet: ORA-28353 (Doc ID 395252.1)

Last updated on MARCH 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 12.1.0.1 [Release 10.2 to 12.1]
Oracle Solaris on SPARC (64-bit)
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 19-Nov-2012***

Symptoms

Trying to create the encryption key and hence the wallet file for the first time fails with the following errors:

 

SQL> alter system set encryption key authenticated by "welcome1";
ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "welcome1"
*
ERROR at line 1:
ORA-28368: cannot auto-create wallet

or

 

SQL> alter system set encryption key authenticated by "welcome1";
alter system set encryption key authenticated by "welcome1"
*
ERROR at line 1:
ORA-28353: failed to open wallet 

 

Changes

On some 64-bit platforms the default wallet location may not work as documented, this was ultimately identified as a porting issue and it has been fixed in RDBMS version 11g, and in patchset 10.2.0.4 (and higher).
Therefore, and also because it is best practice to know and determine the wallet location deliberately (since it is a pretty important file), please consider to always set the ENCRYPTION_WALLET_LOCATION in the sqlnet.ora file.

Comment: If you have specified an ENCRYPTION_WALLET_LOCATION in your sqlnet.ora file you should not have the problem writing to any default location, in that case check for the proper format and indentation of your sqlnet.ora file.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms