Wallet Location for Pluggable Databases

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.