So I have been having trouble getting the oracle wallet to auto open, and it’s always messed up in gv$encryption_wallet
1 2 3 4 5 6 7 8 |
select * from gv$encryption_wallet; INST_ID WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR FULLY_BAC CON_ID ---------- ------------ ---------------------- ------------- ---------- ------------ ------ 4 FILE OPEN AUTOLOGIN SINGLE NO 0 1 FILE OPEN AUTOLOGIN SINGLE NO 0 3 FILE NOT_AVAILABLE UNKNOWN SINGLE UNDEFINED 0 2 FILE NOT_AVAILABLE UNKNOWN SINGLE UNDEFINED 0 |
According to Oracle this is is because TNS_ADMIN is not set, so I set it and several other suggested variables.
1 2 3 4 5 6 7 8 9 10 11 |
$ srvctl setenv database -d oradb1 -T "ORACLE_UNQNAME=oradb1" $ srvctl setenv database -d oradb1 -T "ORACLE_BASE=/u01/app/oracle" $ srvctl setenv database -d oradb1 -T "ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/" $ srvctl setenv database -d oradb1 -T "TNS_ADMIN=/u01/app/oracle/product/12.2.0.1/db/network/admin/" $ srvctl getenv database -d oradb1 oradb1: ORACLE_UNQNAME=oradb1 ORACLE_BASE=/u01/app/oracle TNS_ADMIN=/u01/app/oracle/product/12.2.0.1/db/network/admin/ ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/ |
After restarting the database, the ACFS volume now showsÂ
1 2 3 4 5 6 7 8 |
select * from gv$encryption_wallet; INST_ID WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR FULLY_BAC CON_ID ---------- -------------------- -------------------------------- -------- -------------------- --------- --------- ---------- 1 FILE /u01/app/oracle/wallet/oradb1/ OPEN AUTOLOGIN SINGLE NO 0 2 FILE /u01/app/oracle/wallet/oradb1/ OPEN AUTOLOGIN SINGLE NO 0 3 FILE /u01/app/oracle/wallet/oradb1/ OPEN AUTOLOGIN SINGLE NO 0 4 FILE /u01/app/oracle/wallet/oradb1/ OPEN AUTOLOGIN SINGLE NO 0 |
Recent Comments