Fixing ORA-12578: TNS:wallet open failed in SIOS
When scanning Oracle databases with SIOS, you may encounter the error ORA-12578: TNS:wallet open failed. This error occurs when Oracle Wallet is in use for authentication, but SIOS (through SQL*Plus) cannot locate the wallet information needed to connect.
Issue
In the SIOS log, you may see output similar to the following:
Verbose; *None*; se.snow.oracleaudit.oracle.SqlPlusExecutor; doTheSqlPlusAction;
Result from server:
SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 7 15:29:24 2025
Version 19.25.0.0.0 Copyright (c) 1982, 2024, Oracle.
All rights reserved.
ERROR: ORA-12578: TNS:wallet open failed
Enter user-name:
ERROR: ORA-01017: invalid username/password; logon deniedThis happens when Oracle Wallet is required for authentication, but the wallet location is not passed to SQL*Plus during the connection attempt.
This error occurs because SQL*Plus cannot locate the Oracle Wallet. To fix this, you need to pass the correct $TNS_ADMIN environment variable to SIOS so it knows where to find the wallet.
This error occurs because SQL*Plus cannot locate the Oracle Wallet. To fix this, you need to pass the correct $TNS_ADMIN environment variable to SIOS so it knows where to find the wallet.
You can configure this by updating the snowagent.config file. For step-by-step instructions, see: Exporting environment variables to the SIOS.
