Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Wallet Not opening automatically

Junaidullah.Khan-OracleAug 5 2016 — edited Sep 13 2016

auto TDE wallets have been configured and there are multiple databases in one oracle home. After database restart wallet doesn't open automatically.

We have to set ORACLE_UNQNAME=dbname and then connect as sysdba to wallet to open.

DB was restarted using srvctl, wallet is still showing not_available, i had to go to the node and export ORACLE_UNQNAME on each node and just log in to open the wallet. Is this the natural behavior of wallet for multiple databases in a ORACLE_HOME?

SQL> select status, inst_id from gv$encryption_Wallet;

STATUS                            INST_ID
------------------------------ ----------
OPEN                                    1
NOT_AVAILABLE                           3
NOT_AVAILABLE                           2

SQL>

[oracle@d01pexadb02 ~]$ export ORACLE_UNQNAME=sieblprd
[oracle@d01pexadb02 ~]$ sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Thu Aug 4 02:50:24 2016

Enter user-name: / as sysdba

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL>
SQL> select * from v$encryption_Wallet
2 ;

WRL_TYPE
--------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS                         WALLET_TYPE          WALLET_OR FULLY_BAC
------------------------------ -------------------- --------- ---------
    CON_ID
----------
FILE
/u01/wallet_volume/sieblprd/
OPEN                           UNKNOWN              SINGLE    NO
         0

SQL> set lines 1000
SQL> select status, inst_id from gv$encryption_Wallet;

STATUS                            INST_ID
------------------------------ ----------
OPEN                                    1
OPEN                                    2
NOT_AVAILABLE                           3

SQL> SQL>

Customer Visible

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 11 2016

Added on Aug 5 2016

#database-security, #database-security-general

5 comments

3,821 views