For pluggable databases, when a PDB is registered with the directory, the Database Configuration Assistant (DBCA) creates the wallet at the following location:
If the ORACLE_BASE
environment variable is set:
ORACLE_BASE/admin/db_unique_name/pdb_GUID/wallet
If ORACLE_BASE
is not set:
ORACLE_HOME/admin/db_unique_name/pdb_GUID/wallet
The GUID of the PDB is used because the PDB name can change, but the GUID does not change. So, the PDB wallet location is still valid even if the PDB name changes.
Note:
On the Microsoft Windows x64 platform, without specifying the WALLET_LOCATION
parameter in the listener.ora
file and server side sqlnet.ora
file, the server does not pick up the wallets from the default system location, which is %USERPROFILE%
\ORACLE\WALLETS
. Hence, when you try to login using an SSL connection, the login fails with the following error: ORA-28864: SSL connection closed gracefully
. There is no workaround to this known issue.