Solving "Ora-28365: Wallet Is Not Open" Issue

Oracle databases can experience an ORA-28365 error when trying to open a wallet. This article will provide a step-by-step guide on how to address this issue. This document is written for developers working with Oracle RDBMS software.


Before you start troubleshooting ORA-28365 errors, you will need to make sure the following prerequisites are met:

  • You have administrative privileges in order to make changes to your Oracle database
  • You have the latest version of Oracle RDBMS software installed and running
  • You have a valid Oracle wallet directory and certificates

Step-By-Step Guide

1. Identify the wallet directory

Before making any changes, you must first identify the current wallet directory specified in your database. To do this:

  • Open the database home directory where the Oracle database was installed.
  • Look for the file sqlnet.ora
  • Open the file and check the DIRECTORY parameter.

The directory listed should be the current wallet directory for the Oracle database.

2. Start the wallet manager

Once you have identified the wallet directory, you can begin the process of creating a new wallet in your Oracle database. To do this:

  • In the database home directory, look for the orapki directory
  • Open the orapki directory and look for the file orapki
  • Using the command orapki wallet create -wallet /path/to/wallet specify the wallet directory
  • Enter your Oracle database system password

The wallet manager should be started successfully, creating a new wallet in the specified directory.

3. Modify the database server configuration

In order to use the newly created wallet successfully, you must modify the database server configuration. To do this:

  • Open the sqlnet.ora file in the database home directory
  • Add the parameter WALLET_LOCATION to the file
  • Specify the path of the new wallet in the WALLET_LOCATION parameter

Once you have updated the sqlnet.ora file, you can exit the file and restart the database server.

4. Test the connection

Once the database server has restarted, you can test the connection to your Oracle database to ensure the ORA-28365 error is resolved. To do this:

  • Open the command line
  • Connect to the database using the command sqlplus '/as sysdba'
  • Enter the database system password

If the connection is successful, the wallet has been set up properly and the ORA-28365 error should be gone.


Q. What is the ORA-28365 error code?

A. ORA-28365 is an Oracle error code that indicates an issue with opening a wallet in the database.

Q. What is Oracle RDBMS software?

A. Oracle RDBMS (Relational Database Management System) is a software system used to manage data in relational database systems.

Q. What is a wallet directory?

A. A wallet directory is a folder that stores your security tokens and other credentials used to connect and authenticate an Oracle database.

Q. What is the orapki directory?

A. The orapki directory is located in the database home directory and includes the orapki utility, which is used to open and manage wallets in an Oracle database.

Q. How do I modify the database server configuration?

A. You can modify the database server configuration by opening the sqlnet.ora file in the database home directory and adding the parameter WALLET_LOCATION with the path to the new wallet.

Understanding Oracle Error Codes

Oracle Wallet Manager

Oracle RDBMS Documentation

Great! You’ve successfully signed up.

Welcome back! You've successfully signed in.

You've successfully subscribed to

Success! Check your email for magic link to sign-in.

Success! Your billing info has been updated.

Your billing was not updated.