Re: 12.1.0.2 RAC Wallet NOT Open on 1 Node ?

Hi Chris, are you sure the ENCRYPTION/WALLET_LOCATION is correct in sqlnet.ora ? That's the first place it is supposed to check and if Oracle can't find it there it will default to
$ORACLE_BASE/admin/<DB_UNIQUE_NAME>/wallet, which looks like what is happening in your case.

Andy K

On Mon, Jul 20, 2020 at 10:18 AM Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> So we have a 4-Node 12.1.0.2 RAC on Linux (Exadata CC) where one node
> doesn't have the wallet open. The wallet is on a shared filesystem.
>
> Is there a command to open a specific wallet location in the DB?
>
> I've checked TNS_ADMIN and its set correctly so that the sqlnet.ora file
> should be read correctly :
>
> srvctl getenv database -db <DB_NAME>
>
> TNS_ADMIN=/u02/app/oracle/product/12.1.0/dbhome_2/network/admin/<db_name>
>
> GV$ENCRYPTION_WALLET shows:
>
> INST_ID WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_ORDER
> FULLY_BACKED_UP CON_ID
> 1 FILE /u02/app/oracle/admin/DB_NAME/wallet NOT_AVAILABLE UNKNOWN SINGLE
> UNDEFINED 0
> 2 FILE /acfs01/dbaas_acfs/DB_NAME/TDE/ OPEN AUTOLOGIN SINGLE NO 0
> 3 FILE /acfs01/dbaas_acfs/DB_NAME/TDE/ OPEN AUTOLOGIN SINGLE NO 0
> 4 FILE /acfs01/dbaas_acfs/DB_NAME/TDE/ OPEN AUTOLOGIN SINGLE NO 0
> If I attempt to do:
> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "password" ;
>
> It doesn't try to open the correct wallet, so is there a way to open the
> keystore specified by a keystore location?
>
> Chris
>
>

--
http://www.freelists.org/webpage/oracle-l